單例項的duplicate(non ASM)
Creating a Duplicate Database on a New Host (non ASM). (文件 ID 388431.1) 轉到底部轉到底部
In this Document
Goal
Solution
Duplicate database from server A to server B (Non ASM)
1. Backup of the primary database.
2. Determine how much disk space will be required.
3. Ensuring you have enough space on your target server.
4. Making the backup available for the duplicate process.
5. Creating the init.ora & administration directories for the duplicate database.
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
7. Prepare RMAN duplicate script.
8. Execute the RMAN script.
References
====================================================================================
Solution
Duplicate database from server A to server B (Non ASM)
Assumed database names:
Primary Database SID: PROD
Duplicate Database SID: AUX
RMAN Catalog SID: RMAN
====================================================================================
Steps
1. Backup the primary database.
2. Determine how much disk space will be required.
3. Ensuring you have enough space on your target server.
4. Making the backup available for the duplicate process.
5. Creating the init.ora & administration directories for the duplicate database.
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
7. Prepare RMAN duplicate script.
8. Execute the RMAN script.
=====================================================================================
1. Backup of the primary database.
RMAN>
run
{
allocate channel d1 type disk;
backup format '/backup/df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format '/backup/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
----------------------------------------------------------------
RMAN> run {
allocate channel d1 type disk;
backup format '/backups/PROD/df_t%t_s%s_p%p'
tablespace SYSTEM, SYSAUX, UNDO, USERS;
sql 'alter system archive log current';
backup format '/backups/PROD/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
Figure 1b- This command will perform a tablespace backup ( SYSTEM, SYSAUX, UNDO & USERS) including archive logs and the current controlfile. This would be used if rman is duplicating a subset of the database.
---------------------------------------------------------------
[oracle@xuh admin]$ echo $ORACLE_SID
orcl
[oracle@xuh admin]$ rman target sys/oracle@xuh
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 12 10:58:25 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1414669689)
RMAN> run {
2> allocate channel d1 type disk;
3> backup format '/backup/df_t%t_s%s_p%p' database;
4> sql 'alter system archive log current';
5> backup format '/backup/al_t%t_s%s_p%p' archivelog all;
6> release channel d1;
7> }
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=34 device type=DISK
Starting backup at 12-AUG-15
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oradata/orcl/system01.dbf
input datafile file number=00002 name=/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/oradata/orcl/example01.dbf
input datafile file number=00006 name=/oradata/orcl/backup01.dbf
input datafile file number=00003 name=/oradata/orcl/undotbs01.dbf
input datafile file number=00007 name=/oradata/orcl/backup02.dbf
input datafile file number=00004 name=/oradata/orcl/users01.dbf
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/df_t887540365_s12_p1 tag=TAG20150812T105925 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:15
Finished backup at 12-AUG-15
Starting Control File and SPFILE Autobackup at 12-AUG-15
piece handle=/backup/c-1414669689-20150812-00 comment=NONE
Finished Control File and SPFILE Autobackup at 12-AUG-15
sql statement: alter system archive log current
Starting backup at 12-AUG-15
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=21 STAMP=886958164
input archived log thread=1 sequence=21 RECID=23 STAMP=887463418
input archived log thread=1 sequence=22 RECID=24 STAMP=887471438
input archived log thread=1 sequence=23 RECID=25 STAMP=887472264
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/al_t887540442_s14_p1 tag=TAG20150812T110042 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=26 STAMP=887540442
input archived log thread=1 sequence=2 RECID=27 STAMP=887540442
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/al_t887540445_s15_p1 tag=TAG20150812T110042 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-AUG-15
Starting Control File and SPFILE Autobackup at 12-AUG-15
piece handle=/backup/c-1414669689-20150812-01 comment=NONE
Finished Control File and SPFILE Autobackup at 12-AUG-15
released channel: d1
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
2 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
3 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
4 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
5 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
6 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
7 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 20 1106818 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 21 1106821 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 22 1128050 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 23 1136492 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 1 1137634 11-AUG-15 11 A 1 1 NO TAG20150812T110042
1 2 1140324 12-AUG-15 11 A 1 1 NO TAG20150812T110042
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
1140342 12-AUG-15 12 A 1 1 NO TAG20150812T110046
1140313 12-AUG-15 9 A 1 1 NO TAG20150812T110041
1137716 11-AUG-15 7 A 1 1 NO TAG20150811T173207
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
11-AUG-15 12 A 1 1 NO TAG20150812T110046
11-AUG-15 9 A 1 1 NO TAG20150812T110041
11-AUG-15 7 A 1 1 NO TAG20150811T173207
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 11-AUG-15
Backup Piece 6 11-AUG-15 /home/oracle/temp/db_07qebh80_1_1
Backup Set 7 11-AUG-15
Backup Piece 7 11-AUG-15 /home/oracle/c-1414669689-20150811-03
Backup Set 9 12-AUG-15
Backup Piece 9 12-AUG-15 /backup/c-1414669689-20150812-00
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 11-AUG-15
Backup Piece 6 11-AUG-15 /home/oracle/temp/db_07qebh80_1_1
Backup Set 7 11-AUG-15
Backup Piece 7 11-AUG-15 /home/oracle/c-1414669689-20150811-03
Backup Set 9 12-AUG-15
Backup Piece 9 12-AUG-15 /backup/c-1414669689-20150812-00
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/oracle/temp/db_07qebh80_1_1 RECID=6 STAMP=887473408
deleted backup piece
backup piece handle=/home/oracle/c-1414669689-20150811-03 RECID=7 STAMP=887477528
deleted backup piece
backup piece handle=/backup/c-1414669689-20150812-00 RECID=9 STAMP=887540441
Deleted 3 objects
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
2 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
3 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
4 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
5 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
7 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 20 1106818 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 21 1106821 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 22 1128050 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 23 1136492 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 1 1137634 11-AUG-15 11 A 1 1 NO TAG20150812T110042
1 2 1140324 12-AUG-15 11 A 1 1 NO TAG20150812T110042
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
1140342 12-AUG-15 12 A 1 1 NO TAG20150812T110046
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
11-AUG-15 12 A 1 1 NO TAG20150812T110046
=====================================================================================
2、Determine how much disk space will be required.
Note: sql valid for version 10g only.
SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb"
from dual,
(select sum(a.bytes) TOTAL from dba_data_files a) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
Figure 2a - Calculate total space for all datafiles within database.
SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb" from dual,
(select sum(a.bytes) TOTAL from dba_data_files a
where tablespace_name in('SYSTEM','UNDOTBS1', 'SYSAUX', 'USERS')) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
Figure 2b - If duplicating a subset of the database, calculate space for list of tablespaces within primary database.
DataFile Size Mb Redo Log Size Mb Control File Size Mb Total Size Mb
---------------- ---------------- -------------------- -------------
900 150 20.34375 1070.34375
Figure 2c - Sample output of space calculation.
=====================================================================================
3、Ensuring you have enough space on your target server.
=====================================================================================
4. Making the backup available for the duplicate process.
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 1.08G DISK 00:01:08 12-AUG-15
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20150812T105925
Piece Name: /backup/df_t887540365_s12_p1
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1140278 12-AUG-15 /oradata/orcl/system01.dbf
2 Full 1140278 12-AUG-15 /oradata/orcl/sysaux01.dbf
3 Full 1140278 12-AUG-15 /oradata/orcl/undotbs01.dbf
4 Full 1140278 12-AUG-15 /oradata/orcl/users01.dbf
5 Full 1140278 12-AUG-15 /oradata/orcl/example01.dbf
6 Full 1140278 12-AUG-15 /oradata/orcl/backup01.dbf
7 Full 1140278 12-AUG-15 /oradata/orcl/backup02.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10 44.29M DISK 00:00:01 12-AUG-15
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110042
Piece Name: /backup/al_t887540442_s14_p1
List of Archived Logs in backup set 10
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 20 1106818 05-AUG-15 1106821 05-AUG-15
1 21 1106821 05-AUG-15 1128050 11-AUG-15
1 22 1128050 11-AUG-15 1136492 11-AUG-15
1 23 1136492 11-AUG-15 1136955 11-AUG-15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
11 1.60M DISK 00:00:00 12-AUG-15
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110042
Piece Name: /backup/al_t887540445_s15_p1
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1 1137634 11-AUG-15 1140324 12-AUG-15
1 2 1140324 12-AUG-15 1140332 12-AUG-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 9.36M DISK 00:00:01 12-AUG-15
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110046
Piece Name: /backup/c-1414669689-20150812-01
SPFILE Included: Modification time: 11-AUG-15
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1140342 Ckp time: 12-AUG-15
RMAN>
=====================================================================================
5. Creating the init.ora & administration directories for the duplicate database.
SQL>create pfile='/home/oracle/initorcl.ora' from spfile;
將pfile傳至auxiliary端$ORACLE_HOME/dbs下
修改初始化引數檔案initorcl.ora
SQL>create spfile from pfile;
SQL>startup nomount
=====================================================================================
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
=====================================================================================
7、Prepare RMAN duplicate script.
$rman target sys/oracle@orcl auxiliary sys/oracle
RMAN>
run
{
allocate auxiliary channel C1 device type disk;
duplicate target database to ORCL;
}
------------------------------------------------------
run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
}
Figure 7a - Sample duplicate command.
run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX skip tablespace ABC, XYZ;
}
Figure 7b - Sample duplicate script omitting optional tablespaces;
run {
set until time "to_date('Jan 01 2000 12:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
}
Figure 7c - Sample duplicate script to a point in time.
--------------------------------------------------------
[oracle@zlj dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 12 17:07:44 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zlj dbs]$
[oracle@zlj dbs]$
[oracle@zlj dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 12 17:08:10 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1414669689)
connected to auxiliary database: ORCL (not mounted)
RMAN> run
2> {
3> allocate auxiliary channel C1 device type disk;
4> duplicate target database to ORCL;
5> }
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: SID=19 device type=DISK
Starting Duplicate Db at 12-AUG-15
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
allocated channel: C1
channel C1: SID=18 device type=DISK
Starting restore at 12-AUG-15
channel C1: starting datafile backup set restore
channel C1: restoring control file
channel C1: reading from backup piece /backup/c-1414669689-20150812-03
channel C1: piece handle=/backup/c-1414669689-20150812-03 tag=TAG20150812T170220
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:01
output file name=/oradata/standby/control01.ctl
output file name=/oradata/standby/control02.ctl
Finished restore at 12-AUG-15
database mounted
contents of Memory Script:
{
set until scn 1183861;
set newname for datafile 1 to
"/oradata/standby/system01.dbf";
set newname for datafile 2 to
"/oradata/standby/sysaux01.dbf";
set newname for datafile 3 to
"/oradata/standby/undotbs01.dbf";
set newname for datafile 4 to
"/oradata/standby/users01.dbf";
set newname for datafile 5 to
"/oradata/standby/example01.dbf";
set newname for datafile 6 to
"/oradata/standby/backup01.dbf";
set newname for datafile 7 to
"/oradata/standby/backup02.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-AUG-15
channel C1: starting datafile backup set restore
channel C1: specifying datafile(s) to restore from backup set
channel C1: restoring datafile 00001 to /oradata/standby/system01.dbf
channel C1: restoring datafile 00002 to /oradata/standby/sysaux01.dbf
channel C1: restoring datafile 00003 to /oradata/standby/undotbs01.dbf
channel C1: restoring datafile 00004 to /oradata/standby/users01.dbf
channel C1: restoring datafile 00005 to /oradata/standby/example01.dbf
channel C1: restoring datafile 00006 to /oradata/standby/backup01.dbf
channel C1: restoring datafile 00007 to /oradata/standby/backup02.dbf
channel C1: reading from backup piece /backup/df_t887562072_s43_p1
channel C1: piece handle=/backup/df_t887562072_s43_p1 tag=TAG20150812T170112
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:55
Finished restore at 12-AUG-15
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=887562576 file name=/oradata/standby/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=11 STAMP=887562576 file name=/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=887562576 file name=/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=887562576 file name=/oradata/standby/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=14 STAMP=887562576 file name=/oradata/standby/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=15 STAMP=887562576 file name=/oradata/standby/backup01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=16 STAMP=887562576 file name=/oradata/standby/backup02.dbf
contents of Memory Script:
{
set until scn 1183861;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 12-AUG-15
starting media recovery
channel C1: starting archived log restore to default destination
channel C1: restoring archived log
archived log thread=1 sequence=58
channel C1: restoring archived log
archived log thread=1 sequence=59
channel C1: reading from backup piece /backup/al_t887562139_s45_p1
channel C1: piece handle=/backup/al_t887562139_s45_p1 tag=TAG20150812T170219
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:01
archived log file name=/archive/orcl1_58_887477514.dbf thread=1 sequence=58
channel clone_default: deleting archived log(s)
archived log file name=/archive/orcl1_58_887477514.dbf RECID=124 STAMP=887562577
archived log file name=/archive/orcl1_59_887477514.dbf thread=1 sequence=59
channel clone_default: deleting archived log(s)
archived log file name=/archive/orcl1_59_887477514.dbf RECID=123 STAMP=887562577
media recovery complete, elapsed time: 00:00:01
Finished recover at 12-AUG-15
Oracle instance started
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' 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
sql statement: alter system set db_name = ''ORCL'' 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 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
allocated channel: C1
channel C1: SID=18 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oradata/standby/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oradata/standby/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oradata/standby/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oradata/standby/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/standby/temp01.dbf";
set newname for tempfile 2 to
"/oradata/standby/tmp_backup01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/standby/sysaux01.dbf",
"/oradata/standby/undotbs01.dbf",
"/oradata/standby/users01.dbf",
"/oradata/standby/example01.dbf",
"/oradata/standby/backup01.dbf",
"/oradata/standby/backup02.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/standby/temp01.dbf in control file
renamed tempfile 2 to /oradata/standby/tmp_backup01.dbf in control file
cataloged datafile copy
datafile copy file name=/oradata/standby/sysaux01.dbf RECID=1 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/undotbs01.dbf RECID=2 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/users01.dbf RECID=3 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/example01.dbf RECID=4 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/backup01.dbf RECID=5 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/backup02.dbf RECID=6 STAMP=887562587
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=887562587 file name=/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=887562587 file name=/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=887562587 file name=/oradata/standby/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=887562587 file name=/oradata/standby/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=887562587 file name=/oradata/standby/backup01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=887562587 file name=/oradata/standby/backup02.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 12-AUG-15
released channel: C1
RMAN>
In this Document
Goal
Solution
Duplicate database from server A to server B (Non ASM)
1. Backup of the primary database.
2. Determine how much disk space will be required.
3. Ensuring you have enough space on your target server.
4. Making the backup available for the duplicate process.
5. Creating the init.ora & administration directories for the duplicate database.
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
7. Prepare RMAN duplicate script.
8. Execute the RMAN script.
References
====================================================================================
Solution
Duplicate database from server A to server B (Non ASM)
Assumed database names:
Primary Database SID: PROD
Duplicate Database SID: AUX
RMAN Catalog SID: RMAN
====================================================================================
Steps
1. Backup the primary database.
2. Determine how much disk space will be required.
3. Ensuring you have enough space on your target server.
4. Making the backup available for the duplicate process.
5. Creating the init.ora & administration directories for the duplicate database.
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
7. Prepare RMAN duplicate script.
8. Execute the RMAN script.
=====================================================================================
1. Backup of the primary database.
RMAN>
run
{
allocate channel d1 type disk;
backup format '/backup/df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format '/backup/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
----------------------------------------------------------------
RMAN> run {
allocate channel d1 type disk;
backup format '/backups/PROD/df_t%t_s%s_p%p'
tablespace SYSTEM, SYSAUX, UNDO, USERS;
sql 'alter system archive log current';
backup format '/backups/PROD/al_t%t_s%s_p%p' archivelog all;
release channel d1;
}
Figure 1b- This command will perform a tablespace backup ( SYSTEM, SYSAUX, UNDO & USERS) including archive logs and the current controlfile. This would be used if rman is duplicating a subset of the database.
---------------------------------------------------------------
[oracle@xuh admin]$ echo $ORACLE_SID
orcl
[oracle@xuh admin]$ rman target sys/oracle@xuh
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 12 10:58:25 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1414669689)
RMAN> run {
2> allocate channel d1 type disk;
3> backup format '/backup/df_t%t_s%s_p%p' database;
4> sql 'alter system archive log current';
5> backup format '/backup/al_t%t_s%s_p%p' archivelog all;
6> release channel d1;
7> }
using target database control file instead of recovery catalog
allocated channel: d1
channel d1: SID=34 device type=DISK
Starting backup at 12-AUG-15
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oradata/orcl/system01.dbf
input datafile file number=00002 name=/oradata/orcl/sysaux01.dbf
input datafile file number=00005 name=/oradata/orcl/example01.dbf
input datafile file number=00006 name=/oradata/orcl/backup01.dbf
input datafile file number=00003 name=/oradata/orcl/undotbs01.dbf
input datafile file number=00007 name=/oradata/orcl/backup02.dbf
input datafile file number=00004 name=/oradata/orcl/users01.dbf
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/df_t887540365_s12_p1 tag=TAG20150812T105925 comment=NONE
channel d1: backup set complete, elapsed time: 00:01:15
Finished backup at 12-AUG-15
Starting Control File and SPFILE Autobackup at 12-AUG-15
piece handle=/backup/c-1414669689-20150812-00 comment=NONE
Finished Control File and SPFILE Autobackup at 12-AUG-15
sql statement: alter system archive log current
Starting backup at 12-AUG-15
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=21 STAMP=886958164
input archived log thread=1 sequence=21 RECID=23 STAMP=887463418
input archived log thread=1 sequence=22 RECID=24 STAMP=887471438
input archived log thread=1 sequence=23 RECID=25 STAMP=887472264
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/al_t887540442_s14_p1 tag=TAG20150812T110042 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=26 STAMP=887540442
input archived log thread=1 sequence=2 RECID=27 STAMP=887540442
channel d1: starting piece 1 at 12-AUG-15
channel d1: finished piece 1 at 12-AUG-15
piece handle=/backup/al_t887540445_s15_p1 tag=TAG20150812T110042 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-AUG-15
Starting Control File and SPFILE Autobackup at 12-AUG-15
piece handle=/backup/c-1414669689-20150812-01 comment=NONE
Finished Control File and SPFILE Autobackup at 12-AUG-15
released channel: d1
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
2 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
3 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
4 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
5 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
6 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
7 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 B F A 1137633 11-AUG-15 1 1 NO TAG20150811T162327
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 20 1106818 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 21 1106821 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 22 1128050 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 23 1136492 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 1 1137634 11-AUG-15 11 A 1 1 NO TAG20150812T110042
1 2 1140324 12-AUG-15 11 A 1 1 NO TAG20150812T110042
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
1140342 12-AUG-15 12 A 1 1 NO TAG20150812T110046
1140313 12-AUG-15 9 A 1 1 NO TAG20150812T110041
1137716 11-AUG-15 7 A 1 1 NO TAG20150811T173207
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
11-AUG-15 12 A 1 1 NO TAG20150812T110046
11-AUG-15 9 A 1 1 NO TAG20150812T110041
11-AUG-15 7 A 1 1 NO TAG20150811T173207
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 11-AUG-15
Backup Piece 6 11-AUG-15 /home/oracle/temp/db_07qebh80_1_1
Backup Set 7 11-AUG-15
Backup Piece 7 11-AUG-15 /home/oracle/c-1414669689-20150811-03
Backup Set 9 12-AUG-15
Backup Piece 9 12-AUG-15 /backup/c-1414669689-20150812-00
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 11-AUG-15
Backup Piece 6 11-AUG-15 /home/oracle/temp/db_07qebh80_1_1
Backup Set 7 11-AUG-15
Backup Piece 7 11-AUG-15 /home/oracle/c-1414669689-20150811-03
Backup Set 9 12-AUG-15
Backup Piece 9 12-AUG-15 /backup/c-1414669689-20150812-00
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/oracle/temp/db_07qebh80_1_1 RECID=6 STAMP=887473408
deleted backup piece
backup piece handle=/home/oracle/c-1414669689-20150811-03 RECID=7 STAMP=887477528
deleted backup piece
backup piece handle=/backup/c-1414669689-20150812-00 RECID=9 STAMP=887540441
Deleted 3 objects
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
2 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
3 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
4 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
5 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
6 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
7 8 B F A 1140278 12-AUG-15 1 1 NO TAG20150812T105925
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 20 1106818 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 21 1106821 05-AUG-15 10 A 1 1 NO TAG20150812T110042
1 22 1128050 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 23 1136492 11-AUG-15 10 A 1 1 NO TAG20150812T110042
1 1 1137634 11-AUG-15 11 A 1 1 NO TAG20150812T110042
1 2 1140324 12-AUG-15 11 A 1 1 NO TAG20150812T110042
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
1140342 12-AUG-15 12 A 1 1 NO TAG20150812T110046
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
11-AUG-15 12 A 1 1 NO TAG20150812T110046
=====================================================================================
2、Determine how much disk space will be required.
Note: sql valid for version 10g only.
SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb"
from dual,
(select sum(a.bytes) TOTAL from dba_data_files a) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
Figure 2a - Calculate total space for all datafiles within database.
SQL> select DF.TOTAL/1048576 "DataFile Size Mb",
LOG.TOTAL/1048576 "Redo Log Size Mb",
CONTROL.TOTAL/1048576 "Control File Size Mb",
(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb" from dual,
(select sum(a.bytes) TOTAL from dba_data_files a
where tablespace_name in('SYSTEM','UNDOTBS1', 'SYSAUX', 'USERS')) DF,
(select sum(b.bytes) TOTAL from v$log b) LOG,
(select sum((cffsz+1)*cfbsz) TOTAL from x$kcccf c) CONTROL;
Figure 2b - If duplicating a subset of the database, calculate space for list of tablespaces within primary database.
DataFile Size Mb Redo Log Size Mb Control File Size Mb Total Size Mb
---------------- ---------------- -------------------- -------------
900 150 20.34375 1070.34375
Figure 2c - Sample output of space calculation.
=====================================================================================
3、Ensuring you have enough space on your target server.
=====================================================================================
4. Making the backup available for the duplicate process.
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 1.08G DISK 00:01:08 12-AUG-15
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20150812T105925
Piece Name: /backup/df_t887540365_s12_p1
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1140278 12-AUG-15 /oradata/orcl/system01.dbf
2 Full 1140278 12-AUG-15 /oradata/orcl/sysaux01.dbf
3 Full 1140278 12-AUG-15 /oradata/orcl/undotbs01.dbf
4 Full 1140278 12-AUG-15 /oradata/orcl/users01.dbf
5 Full 1140278 12-AUG-15 /oradata/orcl/example01.dbf
6 Full 1140278 12-AUG-15 /oradata/orcl/backup01.dbf
7 Full 1140278 12-AUG-15 /oradata/orcl/backup02.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10 44.29M DISK 00:00:01 12-AUG-15
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110042
Piece Name: /backup/al_t887540442_s14_p1
List of Archived Logs in backup set 10
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 20 1106818 05-AUG-15 1106821 05-AUG-15
1 21 1106821 05-AUG-15 1128050 11-AUG-15
1 22 1128050 11-AUG-15 1136492 11-AUG-15
1 23 1136492 11-AUG-15 1136955 11-AUG-15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
11 1.60M DISK 00:00:00 12-AUG-15
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110042
Piece Name: /backup/al_t887540445_s15_p1
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1 1137634 11-AUG-15 1140324 12-AUG-15
1 2 1140324 12-AUG-15 1140332 12-AUG-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 9.36M DISK 00:00:01 12-AUG-15
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20150812T110046
Piece Name: /backup/c-1414669689-20150812-01
SPFILE Included: Modification time: 11-AUG-15
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1140342 Ckp time: 12-AUG-15
RMAN>
=====================================================================================
5. Creating the init.ora & administration directories for the duplicate database.
SQL>create pfile='/home/oracle/initorcl.ora' from spfile;
將pfile傳至auxiliary端$ORACLE_HOME/dbs下
修改初始化引數檔案initorcl.ora
SQL>create spfile from pfile;
SQL>startup nomount
=====================================================================================
6. Ensuring SQL*NET connections to primary database and RMAN catalog are working.
=====================================================================================
7、Prepare RMAN duplicate script.
$rman target sys/oracle@orcl auxiliary sys/oracle
RMAN>
run
{
allocate auxiliary channel C1 device type disk;
duplicate target database to ORCL;
}
------------------------------------------------------
run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
}
Figure 7a - Sample duplicate command.
run {
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX skip tablespace ABC, XYZ;
}
Figure 7b - Sample duplicate script omitting optional tablespaces;
run {
set until time "to_date('Jan 01 2000 12:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel C1 device type disk;
duplicate target database to AUX;
}
Figure 7c - Sample duplicate script to a point in time.
--------------------------------------------------------
[oracle@zlj dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 12 17:07:44 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zlj dbs]$
[oracle@zlj dbs]$
[oracle@zlj dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 12 17:08:10 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1414669689)
connected to auxiliary database: ORCL (not mounted)
RMAN> run
2> {
3> allocate auxiliary channel C1 device type disk;
4> duplicate target database to ORCL;
5> }
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: SID=19 device type=DISK
Starting Duplicate Db at 12-AUG-15
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
allocated channel: C1
channel C1: SID=18 device type=DISK
Starting restore at 12-AUG-15
channel C1: starting datafile backup set restore
channel C1: restoring control file
channel C1: reading from backup piece /backup/c-1414669689-20150812-03
channel C1: piece handle=/backup/c-1414669689-20150812-03 tag=TAG20150812T170220
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:01
output file name=/oradata/standby/control01.ctl
output file name=/oradata/standby/control02.ctl
Finished restore at 12-AUG-15
database mounted
contents of Memory Script:
{
set until scn 1183861;
set newname for datafile 1 to
"/oradata/standby/system01.dbf";
set newname for datafile 2 to
"/oradata/standby/sysaux01.dbf";
set newname for datafile 3 to
"/oradata/standby/undotbs01.dbf";
set newname for datafile 4 to
"/oradata/standby/users01.dbf";
set newname for datafile 5 to
"/oradata/standby/example01.dbf";
set newname for datafile 6 to
"/oradata/standby/backup01.dbf";
set newname for datafile 7 to
"/oradata/standby/backup02.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-AUG-15
channel C1: starting datafile backup set restore
channel C1: specifying datafile(s) to restore from backup set
channel C1: restoring datafile 00001 to /oradata/standby/system01.dbf
channel C1: restoring datafile 00002 to /oradata/standby/sysaux01.dbf
channel C1: restoring datafile 00003 to /oradata/standby/undotbs01.dbf
channel C1: restoring datafile 00004 to /oradata/standby/users01.dbf
channel C1: restoring datafile 00005 to /oradata/standby/example01.dbf
channel C1: restoring datafile 00006 to /oradata/standby/backup01.dbf
channel C1: restoring datafile 00007 to /oradata/standby/backup02.dbf
channel C1: reading from backup piece /backup/df_t887562072_s43_p1
channel C1: piece handle=/backup/df_t887562072_s43_p1 tag=TAG20150812T170112
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:55
Finished restore at 12-AUG-15
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=887562576 file name=/oradata/standby/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=11 STAMP=887562576 file name=/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=887562576 file name=/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=887562576 file name=/oradata/standby/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=14 STAMP=887562576 file name=/oradata/standby/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=15 STAMP=887562576 file name=/oradata/standby/backup01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=16 STAMP=887562576 file name=/oradata/standby/backup02.dbf
contents of Memory Script:
{
set until scn 1183861;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 12-AUG-15
starting media recovery
channel C1: starting archived log restore to default destination
channel C1: restoring archived log
archived log thread=1 sequence=58
channel C1: restoring archived log
archived log thread=1 sequence=59
channel C1: reading from backup piece /backup/al_t887562139_s45_p1
channel C1: piece handle=/backup/al_t887562139_s45_p1 tag=TAG20150812T170219
channel C1: restored backup piece 1
channel C1: restore complete, elapsed time: 00:00:01
archived log file name=/archive/orcl1_58_887477514.dbf thread=1 sequence=58
channel clone_default: deleting archived log(s)
archived log file name=/archive/orcl1_58_887477514.dbf RECID=124 STAMP=887562577
archived log file name=/archive/orcl1_59_887477514.dbf thread=1 sequence=59
channel clone_default: deleting archived log(s)
archived log file name=/archive/orcl1_59_887477514.dbf RECID=123 STAMP=887562577
media recovery complete, elapsed time: 00:00:01
Finished recover at 12-AUG-15
Oracle instance started
Total System Global Area 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' 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
sql statement: alter system set db_name = ''ORCL'' 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 242208768 bytes
Fixed Size 2227176 bytes
Variable Size 184550424 bytes
Database Buffers 50331648 bytes
Redo Buffers 5099520 bytes
allocated channel: C1
channel C1: SID=18 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oradata/standby/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oradata/standby/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oradata/standby/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oradata/standby/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/standby/temp01.dbf";
set newname for tempfile 2 to
"/oradata/standby/tmp_backup01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/standby/sysaux01.dbf",
"/oradata/standby/undotbs01.dbf",
"/oradata/standby/users01.dbf",
"/oradata/standby/example01.dbf",
"/oradata/standby/backup01.dbf",
"/oradata/standby/backup02.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/standby/temp01.dbf in control file
renamed tempfile 2 to /oradata/standby/tmp_backup01.dbf in control file
cataloged datafile copy
datafile copy file name=/oradata/standby/sysaux01.dbf RECID=1 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/undotbs01.dbf RECID=2 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/users01.dbf RECID=3 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/example01.dbf RECID=4 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/backup01.dbf RECID=5 STAMP=887562587
cataloged datafile copy
datafile copy file name=/oradata/standby/backup02.dbf RECID=6 STAMP=887562587
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=887562587 file name=/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=887562587 file name=/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=887562587 file name=/oradata/standby/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=887562587 file name=/oradata/standby/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=887562587 file name=/oradata/standby/backup01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=887562587 file name=/oradata/standby/backup02.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 12-AUG-15
released channel: C1
RMAN>
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30310891/viewspace-1769548/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Duplicate database from non ASM to ASM to a different host [ID 382669.1]DatabaseASM
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- 單例項刪除ASM例項單例ASM
- RAC 例項 遷移到 單例項 -- 使用RMAN Duplicate單例
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM
- Duplicate database from non ASM to ASM (vise versa) to a different host-382669.1DatabaseASM
- 11GR2 Active Duplicate過程(單例項對單例項)單例
- RAC+DG(asm單例項)ASM單例
- duplicate搭建DG最大效能（rac-單例項）單例
- 單機環境配置ASM例項ASM
- 單節點執行ASM例項ASM
- RAC asm恢復到單例項ASM單例
- duplicate複製資料庫（rac-單例項）資料庫單例
- Oracle單例項+ASM新增控制檔案Oracle單例ASM
- rac asm 恢復到 單例項 1ASM單例
- rac asm 恢復到 單例項 2ASM單例
- ASM之建立ASM例項ASM
- 管理 ASM 例項ASM
- 停止ASM例項ASM
- oracle11g asm單例項重建hasOracleASM單例
- ASM單例項(Oracle 11.2.0.4)環境(一)ASM單例Oracle
- ASM單例項(Oracle 11.2.0.4)環境(二)ASM單例Oracle
- Oracle單例項+ASM啟動與關閉Oracle單例ASM
- 單機環境安裝配置ASM例項ASM
- 使用RMAN將RAC+ASM複製到單例項+ASM上ASM單例
- 【DG】在Linux平臺上搭建單例項的dataguard--duplicateLinux單例
- 刪除ASM例項ASM
- Windows平臺模擬單例項ASM環境Windows單例ASM
- 恢復RAC資料庫到單例項（ASM）資料庫單例ASM
- Oracle 11g RAC 配置單例項 DataGuard（通過 DUPLICATE 方式）Oracle單例
- ASM之建立ASM例項時的常見故障ASM
- 健壯的例項變數 (Non Fragile ivars)和脆弱的例項變數(Fragile ivars)變數
- ASM單例項安裝後，需要手動設定ASM的引數檔案ASM單例
- ASM之建立ASM例項及ASM資料庫ASM資料庫
- 建立ASM例項及ASM資料庫ASM資料庫
- Window下安裝Oracle ASM單例項資料庫OracleASM單例資料庫
- 10g rac asm 恢復到 單例項(二)ASM單例
- 10g rac asm 恢復到 單例項(一)ASM單例