RMAN异机duplicate复制数据库(五)
radata/orcl2/datafilesexample01.dbf
contents of Memory Script:
{
set until scn 883198;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 22-OCT-13
starting media recovery
channel a2: starting archived log restore to default destination
channel a2: restoring archived log
archived log thread=1 sequence=17
channel a2: restoring archived log
archived log thread=1 sequence=18
channel a2: reading from backup piece /orabackup/arc_22_36_1_20131022
channel a2: piece handle=/orabackup/arc_22_36_1_20131022 tag=TAG20131022T140825
channel a2: restored backup piece 1
channel a2: restore complete, elapsed time: 00:00:01
archived log file name=/oradata/orcl2/arch/1_17_829415524.arc thread=1 sequence=17
channel clone_default: deleting archived log(s)
archived log file name=/oradata/orcl2/arch/1_17_829415524.arc RECID=15 STAMP=829493595
archived log file name=/oradata/orcl2/arch/1_18_829415524.arc thread=1 sequence=18
channel clone_default: deleting archived log(s)
archived log file name=/oradata/orcl2/arch/1_18_829415524.arc RECID=16 STAMP=829493595
media recovery complete, elapsed time: 00:00:02
Finished recover at 22-OCT-13
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''ORCL2'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 629149264 bytes
Database Buffers 213909504 bytes
Redo Buffers 5132288 bytes
allocated channel: a2
channel a2: SID=19 device type=DISK
allocated channel: a3
channel a3: SID=20 device type=DISK
allocated channel: a4
channel a4: SID=21 device type=DISK
sql statement: alter system set db_name = ''ORCL2'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 629149264 bytes
Database Buffers 213909504 bytes
Redo Buffers 5132288 bytes
allocated channel: a2
channel a2: SID=19 device type=DISK
allocated channel: a3
channel a3: SID=20 device type=DISK
allocated channel: a4
channel a4: SID=21 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL2" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/oradata/orcl2/redo01.dbf' SIZE 50 M ,
GROUP 2 '/oradata/orcl2/redo02.dbf' SIZE 50 M ,
GROUP 3 '/oradata/orcl2/redo03.dbf' SIZE 50 M
DATAFILE
'/oradata/orcl2/datafilessystem01.dbf'
CHARACTER SET ZHS16GBK