博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
dg rman
阅读量:6624 次
发布时间:2019-06-25

本文共 6058 字,大约阅读时间需要 20 分钟。

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 6 21:05:43 2015
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size                  2220200 bytes
Variable Size             624955224 bytes
Database Buffers          436207616 bytes
Redo Buffers                5554176 bytes
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@DB200 ~]$ rman target sys/Aa7788123@dadifilma auxiliary sys/Aa7788123@dadifilmb
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Feb 6 21:05:57 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: DADIFILM (DBID=4240448887)
connected to auxiliary database: DADIFILM (not mounted)
RMAN> duplicate target database for standby nofilenamecheck from active database;
Starting Duplicate Db at 06-FEB-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=156 device type=DISK
contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdadifilm' auxiliary format
 '/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdadifilm'   ;
}
executing Memory Script
Starting backup at 06-FEB-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=128 device type=DISK
Finished backup at 06-FEB-15
contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/data/DBData/oradata/dadifilm/control01.ctl';
   restore clone controlfile to  '/data/DBSoftware/app/oracle/flash_recovery_area/dadifilm/control02.ctl' from
 '/data/DBData/oradata/dadifilm/control01.ctl';
}
executing Memory Script
Starting backup at 06-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/data/DBSoftware/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_dadifilm.f tag=TAG20150206T210609 RECID=2 STAMP=870987969
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 06-FEB-15
Starting restore at 06-FEB-15
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 06-FEB-15
contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
   set newname for tempfile  1 to
 "/data/DBData/oradata/dadifilm/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/data/DBData/oradata/dadifilm/system01.dbf";
   set newname for datafile  2 to
 "/data/DBData/oradata/dadifilm/sysaux01.dbf";
   set newname for datafile  3 to
 "/data/DBData/oradata/dadifilm/undotbs01.dbf";
   set newname for datafile  4 to
 "/data/DBData/oradata/dadifilm/users01.dbf";
   set newname for datafile  5 to
 "/data/DBData/oradata/dadifilm/example01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format
 "/data/DBData/oradata/dadifilm/system01.dbf"   datafile
 2 auxiliary format
 "/data/DBData/oradata/dadifilm/sysaux01.dbf"   datafile
 3 auxiliary format
 "/data/DBData/oradata/dadifilm/undotbs01.dbf"   datafile
 4 auxiliary format
 "/data/DBData/oradata/dadifilm/users01.dbf"   datafile
 5 auxiliary format
 "/data/DBData/oradata/dadifilm/example01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /data/DBData/oradata/dadifilm/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 06-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/data/DBData/oradata/dadifilm/system01.dbf
output file name=/data/DBData/oradata/dadifilm/system01.dbf tag=TAG20150206T210617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/data/DBData/oradata/dadifilm/sysaux01.dbf
output file name=/data/DBData/oradata/dadifilm/sysaux01.dbf tag=TAG20150206T210617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/data/DBData/oradata/dadifilm/undotbs01.dbf
output file name=/data/DBData/oradata/dadifilm/undotbs01.dbf tag=TAG20150206T210617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/data/DBData/oradata/dadifilm/example01.dbf
output file name=/data/DBData/oradata/dadifilm/example01.dbf tag=TAG20150206T210617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/data/DBData/oradata/dadifilm/users01.dbf
output file name=/data/DBData/oradata/dadifilm/users01.dbf tag=TAG20150206T210617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 06-FEB-15
sql statement: alter system archive log current
contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=870988015 file name=/data/DBData/oradata/dadifilm/example01.dbf
Finished Duplicate Db at 06-FEB-15

 

转载地址:http://kfnpo.baihongyu.com/

你可能感兴趣的文章
leetcode290
查看>>
003-对象——对象的释放 抽象 封装 继承 多态
查看>>
Cookies 题解报告
查看>>
网络编程(学习整理)---3--(Udp)FeiQ实现广播消息群发
查看>>
联系python爬虫第一天
查看>>
java一行一行写入或读取数据
查看>>
Java中关于WeakReference和WeakHashMap的理解
查看>>
SQL Lazy Spool Eager Spool
查看>>
type的解释
查看>>
python之路--类与类之间的关系
查看>>
js冒泡排序
查看>>
CSS 居中
查看>>
未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序 解决方法
查看>>
global中捕获异常
查看>>
用户态和核心态(转)
查看>>
sublime text 3 常用插件/教程/快捷键等设置方法
查看>>
胆机实作(1)——12AU7甲类单端前级
查看>>
【转】登录流程
查看>>
Proxool配置说明
查看>>
java ConcurrentModificationException探究
查看>>