Duplicate database using RMAN on the same host
Assumed database names:
Primary Database SID: DGTEST9i
Duplicate Database SID: DUPDB
RMAN Catalog SID: N/A
=============================================================
Steps
1. Identify and 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 are working.
7. Prepare RMAN duplicate script.
8. Execute the RMAN script.
9. Duplicate database ready.
- Identify and Backup the primary
database
:/opt/oracle>. setdgtest9i
dgtest9i:/opt/oracle> sql
SQL> select
dbid,name,created,log_mode,force_logging from v$database;
DBID
NAME CREATED LOG_MODE
FORCED LOGGING
-------------- --------------- ---------------
-------------------- ---------------------------
237270920
DGTEST9I 24-OCT-06 ARCHIVELOG YES
Note the DBID
and the forced logging entries after the duplication the DBID of the new
database will be different and forced logging will default to NO.
Check if a
backup exists
dgtest9i:/opt/oracle/admin/dupdb/rman>rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DGTEST9I (DBID=237270920)
RMAN> list backup;
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------
---------------
127 70M SBT_TAPE 00:00:03
05-FEB-07
BP Key:
127 Status: AVAILABLE Tag: TAG20070205T080655
Piece Name:
DGTEST9I.20070205.127.1.1.613728415
List of Archived
Logs in backup set 127
Thrd Seq Low SCN
Low Time Next SCN Next Time
---- -------
---------- --------- ---------- ---------
1 247
15132772 27-JAN-07 15173934 01-FEB-07
1 248
15173934 01-FEB-07 15215150 02-FEB-07
1 249
15215150 02-FEB-07 15256190 02-FEB-07
1 250
15256190 02-FEB-07 15297296 03-FEB-07
1 251
15297296 03-FEB-07 15338448 04-FEB-07
1 252
15338448 04-FEB-07 15379521 04-FEB-07
1 253
15379521 04-FEB-07 15420516 05-FEB-07
1 254
15420516 05-FEB-07 15423007 05-FEB-07
BS Key Type LV
------- ---- -- ---------- ----------- ------------
---------------
128 Full 537M
SBT_TAPE 00:00:42 05-FEB-07
BP Key:
128 Status: AVAILABLE Tag: TAG20070205T080659
Piece Name:
DGTEST9I.20070205.128.1.1.613728419
List of Datafiles
in backup set 128
File LV
---- -- ----
---------- --------- ----
1 Full 15423009
05-FEB-07 /u01/ORACLE/dgtest9i/system01.dbf
2 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/undotbs01.dbf
3 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools01.dbf
4 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users01.dbf
5 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users02.dbf
6 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools02.dbf
7 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/example01.dbf
8 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools03.dbf
9 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users03.dbf
10 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users04.dbf
11 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools04.dbf
12 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/drtest1.dbf
13 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/drtest3.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------
---------------
129 7K SBT_TAPE 00:00:02
05-FEB-07
BP Key:
129 Status: AVAILABLE Tag: TAG20070205T080744
Piece Name:
DGTEST9I.20070205.129.1.1.613728464
List of Archived
Logs in backup set 129
Thrd Seq Low SCN
Low Time Next SCN Next Time
---- -------
---------- --------- ---------- ---------
1 255
15423007 05-FEB-07 15423042 05-FEB-07
BS Key Type LV
------- ---- -- ---------- ----------- ------------
---------------
130 Full 3M
SBT_TAPE 00:00:00 05-FEB-07
BP Key:
130 Status: AVAILABLE Tag:
Piece Name:
c-237270920-20070205-00
SPFILE Included:
Modification time: 27-JAN-07
As per above there exists a backup and it is available,
however if no backup exists you may fire the backup as follows:
dgtest9i:/opt/oracle/admin/dupdb/rman>rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DGTEST9I (DBID=237270920)
RMAN> backup device type sbt database plus archivelog;
Starting backup at 05-FEB-07
current log archived
using target database controlfile instead of recovery
catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=11 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle:
version 5.2.4.0
skipping archive log file
/u01/ORACLE/dgtest9i/arch/arch190.log; already backed up 1 time(s)
skipping archive log file /u01/ORACLE/dgtest9i/arch/arch191.log;
already backed up 1 time(s)
skipping archive log file
/u01/ORACLE/dgtest9i/arch/arch240.log; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting archive log backupset
channel ORA_SBT_TAPE_1: specifying archive log(s) in
backup set
input archive log thread=1 sequence=241 recid=270
stamp=612980669
channel ORA_SBT_TAPE_1: starting piece 1 at 27-JAN-07
channel ORA_SBT_TAPE_1: finished piece 1 at 27-JAN-07
piece handle=DGTEST9I.20070127.113.1.1.612980669
comment=API Version 2.0,MMS Version 5.2.4.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed
time: 00:00:02
Finished backup at 05-FEB-07
………………………………………………………………. ………………………
………………………………………………………………………………………..
Starting Control File and SPFILE Autobackup at 05-FEB-07
piece handle=c-237270920-20070127-02 comment=API Version
2.0,MMS Version 5.2.4.0
Finished Control File and SPFILE Autobackup at 05-FEB-07
RMAN>exit
2. Determine how much disk space will be
required.
After
deciding what you will be duplicating, calculate the entire space this will
required on the host.
SQL> select round(sum(bytes)/1048576) ||' M - DATA' as
DATA
from dba_data_files;
select round(sum(bytes)/1048576) ||' M - TEMP' as TEMP
from dba_temp_files;
select round(sum(bytes)/1048576) ||' M - LOGS' as LOGS
from v$log;
1230 M - DATA
100 M - TEMP
30 M
- LOGS
3. Ensuring you have enough space on your target server.
Prior to starting the duplicate process you must ensure you have enough disk space within file system to hold the database.
Prior to starting the duplicate process you must ensure you have enough disk space within file system to hold the database.
dgtest9i:/opt/oracle>df -h
Filesystem
Size Used Avail Use% Mounted on
/dev/cciss/c0d0p8
4.9G 1.4G 3.2G
31% /
/dev/cciss/c0d0p2
25G 19G 4.4G
81% /opt
/dev/cciss/c0d0p11
14G 12G 2.1G
85% /u01
- Making the backup available for
the duplicate process.
Verify the backup is
available.
dgtest9i:/opt/oracle/admin/dupdb/rman>rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DGTEST9I (DBID=237270920)
RMAN> list backup;
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------
---------------
127 70M SBT_TAPE 00:00:03
05-FEB-07
BP Key:
127 Status: AVAILABLE Tag: TAG20070205T080655
Piece Name:
DGTEST9I.20070205.127.1.1.613728415
List of Archived
Logs in backup set 127
Thrd Seq Low SCN
Low Time Next SCN Next Time
---- -------
---------- --------- ---------- ---------
1 247
15132772 27-JAN-07 15173934 01-FEB-07
1 248
15173934 01-FEB-07 15215150 02-FEB-07
1 249
15215150 02-FEB-07 15256190 02-FEB-07
1 250
15256190 02-FEB-07 15297296 03-FEB-07
1 251
15297296 03-FEB-07 15338448 04-FEB-07
1 252
15338448 04-FEB-07 15379521 04-FEB-07
1 253
15379521 04-FEB-07 15420516 05-FEB-07
1 254
15420516 05-FEB-07 15423007 05-FEB-07
BS Key Type LV
------- ---- -- ---------- ----------- ------------
---------------
128 Full 537M
SBT_TAPE 00:00:42 05-FEB-07
BP Key:
128 Status: AVAILABLE Tag: TAG20070205T080659
Piece Name:
DGTEST9I.20070205.128.1.1.613728419
List of Datafiles
in backup set 128
File LV
---- -- ----
---------- --------- ----
1 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/system01.dbf
2 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/undotbs01.dbf
3 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools01.dbf
4 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users01.dbf
5 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users02.dbf
6 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools02.dbf
7 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/example01.dbf
8 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools03.dbf
9 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users03.dbf
10 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/users04.dbf
11 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/tools04.dbf
12 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/drtest1.dbf
13 Full 15423009 05-FEB-07 /u01/ORACLE/dgtest9i/drtest3.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------
---------------
129 7K SBT_TAPE 00:00:02
05-FEB-07
BP Key:
129 Status: AVAILABLE Tag: TAG20070205T080744
Piece Name:
DGTEST9I.20070205.129.1.1.613728464
List of Archived
Logs in backup set 129
Thrd Seq Low SCN
Low Time Next SCN Next Time
---- -------
---------- --------- ---------- ---------
1 255
15423007 05-FEB-07 15423042 05-FEB-07
BS Key Type LV
------- ---- -- ---------- ----------- ------------
---------------
130 Full 3M
SBT_TAPE 00:00:00 05-FEB-07
BP Key:
130 Status: AVAILABLE Tag:
Piece Name:
c-237270920-20070205-00
SPFILE Included:
Modification time: 27-JAN-07
5 . Creating the init.ora & administration directories for the duplicate database.
Create the
directory structure of the dump destinations and of the datafiles etc.
Also
create set file.
An easy way
to create the dump directories is to copy the existing primary database dump
directories and delete its contents
/opt/oracle/admin/> cp –rp dgtest9i dupdb
Find the
filesystem directories of the database.
SQL>
select distinct substr(name,1,instr(UPPER(name),'ORACLE',1) - 1)
"FILESYSTEM"
from
v$datafile
select
distinct substr(member,1,instr(UPPER(member),'ORACLE',1) - 1)
"FILESYSTEM"
from
v$logfile
select
distinct substr(name,1,instr(UPPER(name),'ORACLE',1) - 1)
"FILESYSTEM"
from
v$controlfile;
FILESYSTEM
--------------------------------------------------------------------------------
/u01/
SQL>
exit
/u01/ORACLE>
mkdir dupdb
Copy the
original initora file of the primary database in this case initdgtest9i.ora and
replace all dgtest9i references to dupdb and make all necessary
directory changes.
*.background_dump_dest='/opt/oracle/admin/dupdb/bdump'
*.control_files='/u01/ORACLE/dupdb/control01.ctl'
*.core_dump_dest='/opt/oracle/admin/dupdb/cdump'
*.db_block_size=16384
*.db_cache_size=104857600
*.db_file_multiblock_read_count=8
*.db_file_name_convert='/u01/ORACLE/dgtest9i/','/u01/ORACLE/dupdb/'
*.db_name='dupdb'
*.java_pool_size=52428800
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=/u01/ORACLE/dupdb/arch'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_format='arch%s.log'
*.log_archive_start=TRUE
*.log_buffer=1048576
*.log_checkpoints_to_alert=TRUE
*.log_file_name_convert='/u01/ORACLE/dgtest9i/','/u01/ORACLE/dupdb/'
*.shared_pool_size=104857600
Ensure the
db_file_name_convert parameter is set
appropiately. This
parameter will instruct RMAN to convert the primary database filenames to the
target database filenames. One can use the SET NEWNAME parameter too in the RMAN
script then db_file_name_convert
parameter is not needed.
Create
password file for new db
:/opt/oracle>. setdupdb
dupdb:/opt/oracle> cd $ORACLE_HOME/dbs
dupdb:/opt/oracle/product9204/dbs>orapwd
file=orapwdupdb password=oracle entries=5
dupdb:/opt/oracle/product9204/dbs>
6. Ensuring SQL*NET connections to primary database and
RMAN catalog are working.
Ensure the production target database is open or at least mounted. If using a catalog database this must also be open. Test your SQL*NET connections: You must be able to connect to the primary DB as sysdba and make an rman connection to RMAN. Perform a basic test using sqlplus. When you have successfully connected exit sqlplus and move onto the next step.
Ensure the production target database is open or at least mounted. If using a catalog database this must also be open. Test your SQL*NET connections: You must be able to connect to the primary DB as sysdba and make an rman connection to RMAN. Perform a basic test using sqlplus. When you have successfully connected exit sqlplus and move onto the next step.
dupdb:/opt/oracle/admin/dupdb/rman>
dupdb:/opt/oracle/admin/dupdb/rman>
sqlplus ‘sys/oracle@dgtest9i as sysdba’dupdb:/opt/oracle/admin/dupdb/rman>
sqlplus rman/rman@RMAN
(not mandatory)
7.
Prepare RMAN duplicate script.
Using RMAN connect
to the primary database to retrieve the SBT Channel settings. This
setting has to be included in the RMAN Duplicate script.
dgtest9i:/opt/oracle/admin/dupdb/rman>rman target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DGTEST9I (DBID=237270920)
RMAN> show all;
using target
database control file instead of recovery catalog
RMAN configuration
parameters are:
CONFIGURE RETENTION
POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP
OPTIMIZATION ON;
CONFIGURE DEFAULT
DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE
CONTROLFILE AUTOBACKUP ON;
CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/ORACLE/dgtest9i/arch/%F';
CONFIGURE DEVICE
TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE
TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE
BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE
BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE
ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE
ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE
'SBT_TAPE' PARMS
'ENV=(TDPO_OPTFILE=/opt/tivoli/t
sm/client/oracle/bin64/tdpo.dgtest9id.opt)'
FORMAT '%d.%T.%s.%p.%c.%t';
CONFIGURE
MAXSETSIZE TO UNLIMITED; # default
CONFIGURE
ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE
ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE
ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT
CONTROLFILE NAME TO '/opt/oracle/product9204/dbs/snapcf_face.f'; # default
RMAN> exit
Note
the current log sequence of the primary database dgtest9i
SQL> archive log
list
Database log
mode Archive Mode
Automatic archival Enabled
Archive
destination /u01/ORACLE/fdgtest9i/arch
Oldest online log
sequence 254
Next log sequence
to archive 256
Current log sequence 256
Create
a script create_dupdb.rcv
Note the log sequence number and the channel parameters.
run{
allocate channel C1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.dgtest9id.opt)';
allocate auxiliary
channel aux1 device type 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.dgtest9id.opt)';
SET UNTIL SEQUENCE
256 THREAD 1;
duplicate target database to dupdb;
}
Start the
dupdb instance in NOMOUNT mode. This will be your auxiliary instance.
:/opt/oracle> . setdupdb
dupdb:/opt/oracle> sql
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Feb 6
09:55:42 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area
287279592 bytes
Fixed Size 731624 bytes
Variable Size
167772160 bytes
Database Buffers
117440512 bytes
Redo Buffers 1335296 bytes
SQL> exit
8. Execute the RMAN script.
Start RMAN, connect to the production target, the catalog instance and also the auxiliary clone. Run the RMAN duplicate script as shown above. Before doing this ensure that the Oracle SID environment variable is set to the duplicate clone database.
Start RMAN, connect to the production target, the catalog instance and also the auxiliary clone. Run the RMAN duplicate script as shown above. Before doing this ensure that the Oracle SID environment variable is set to the duplicate clone database.
dupdb:/opt/oracle/admin/dupdb/rman>rman target sys/oracle@ dgtest9i as sysdba auxiliary /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DGTEST9I (DBID=237270920)
connected to auxiliary database: dupdb (not mounted)
RMAN> spool log to dupdb_creation.log
RMAN> @
create_dupdb.rcv
RMAN> 1 > 2
> 3 > 4 >
Open another
duplicate OS session and navigate to the directory that has the log file
dupdb_creation.log and do a tail –f dupdb_creation.log to monitor the progress
of the duplication.
dupdb:/opt/oracle/admin/dupdb/rman> tail –f
dupdb_creation.log
Spooling started in log file: dupdb_creation.log
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
RMAN>
RMAN> run{
2> allocate channel C1 DEVICE TYPE 'SBT_TAPE' PARMS
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.dgtest9id.opt)';
3> allocate auxiliary channel aux1 device type
'SBT_TAPE' PARMS
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.dgtest9id.opt)';
4> SET UNTIL SEQUENCE 256 THREAD 1;
5> duplicate target database to dupdb;
6> }
using target database controlfile instead of recovery
catalog
allocated channel: C1
channel C1: sid=15 devtype=SBT_TAPE
channel C1: Data Protection for Oracle: version 5.2.4.0
allocated channel: aux1
channel aux1: sid=12 devtype=SBT_TAPE
channel aux1: Data Protection for Oracle: version 5.2.4.0
executing command: SET until clause
Starting Duplicate Db at 05-FEB-07
printing stored script: Memory Script
{
set until
scn 15423042;
set newname for
datafile 1 to
"/u01/ORACLE/dupdb/system01.dbf";
set newname for
datafile 2 to
"/u01/ORACLE/dupdb/undotbs01.dbf";
set newname for
datafile 3 to
"/u01/ORACLE/dupdb/tools01.dbf";
set newname for
datafile 4 to
"/u01/ORACLE/dupdb/users01.dbf";
set newname for
datafile 5 to
"/u01/ORACLE/dupdb/users02.dbf";
set newname for
datafile 6 to
"/u01/ORACLE/dupdb/tools02.dbf";
set newname for
datafile 7 to
"/u01/ORACLE/dupdb/example01.dbf";
set newname for
datafile 8 to
"/u01/ORACLE/dupdb/tools03.dbf";
set newname for
datafile 9 to
"/u01/ORACLE/dupdb/users03.dbf";
set newname for
datafile 10 to
"/u01/ORACLE/dupdb/users04.dbf";
set newname for
datafile 11 to
"/u01/ORACLE/dupdb/tools04.dbf";
set newname for
datafile 12 to
"/u01/ORACLE/dupdb/drtest1.dbf";
set newname for
datafile 13 to
"/u01/ORACLE/dupdb/drtest3.dbf";
restore
check readonly
clone database
;
}
executing script: 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
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 05-FEB-07
channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from
backup set
restoring datafile 00001 to
/u01/ORACLE/dupdb/system01.dbf
restoring datafile 00002 to
/u01/ORACLE/dupdb/undotbs01.dbf
restoring datafile 00003 to /u01/ORACLE/dupdb/tools01.dbf
restoring datafile 00004 to /u01/ORACLE/dupdb/users01.dbf
restoring datafile 00005 to /u01/ORACLE/dupdb/users02.dbf
restoring datafile 00006 to /u01/ORACLE/dupdb/tools02.dbf
restoring datafile 00007 to
/u01/ORACLE/dupdb/example01.dbf
restoring datafile 00008 to /u01/ORACLE/dupdb/tools03.dbf
restoring datafile 00009 to /u01/ORACLE/dupdb/users03.dbf
restoring datafile 00010 to /u01/ORACLE/dupdb/users04.dbf
restoring datafile 00011 to /u01/ORACLE/dupdb/tools04.dbf
restoring datafile 00012 to /u01/ORACLE/dupdb/drtest1.dbf
restoring datafile 00013 to /u01/ORACLE/dupdb/drtest3.dbf
channel aux1: restored backup piece 1
piece handle=DGTEST9I.20070205.128.1.1.613728419
tag=TAG20070205T080659 params=NULL
channel aux1: restore complete
Finished restore at 05-FEB-07
sql statement: CREATE CONTROLFILE REUSE SET DATABASE
"dupdb" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 200
MAXINSTANCES 1
MAXLOGHISTORY 454
LOGFILE
GROUP 1 ( '/u01/ORACLE/dupdb/redo01.log' )
SIZE 10485760 REUSE,
GROUP 2 ( '/u01/ORACLE/dupdb/redo02.log' )
SIZE 10485760 REUSE,
GROUP 3 ( '/u01/ORACLE/dupdb/redo03.log' )
SIZE 10485760 REUSE
DATAFILE
'/u01/ORACLE/dupdb/system01.dbf'
CHARACTER SET
US7ASCII
printing stored script: Memory Script
{
switch clone datafile
all;
}
executing script: Memory Script
datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=613746385
filename=/u01/ORACLE/dupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=613746385 filename=/u01/ORACLE/dupdb/tools01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=613746385
filename=/u01/ORACLE/dupdb/users01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=613746385
filename=/u01/ORACLE/dupdb/users02.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=613746385
filename=/u01/ORACLE/dupdb/tools02.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=613746385
filename=/u01/ORACLE/dupdb/example01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=613746385
filename=/u01/ORACLE/dupdb/tools03.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=613746385
filename=/u01/ORACLE/dupdb/users03.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=613746385
filename=/u01/ORACLE/dupdb/users04.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=613746385
filename=/u01/ORACLE/dupdb/tools04.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=11 stamp=613746385
filename=/u01/ORACLE/dupdb/drtest1.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=12 stamp=613746385
filename=/u01/ORACLE/dupdb/drtest3.dbf
printing stored script: Memory Script
{
set until
scn 15423042;
recover
clone database
delete
archivelog
;
}
executing script: Memory Script
executing command: SET until clause
Starting recover at 05-FEB-07
starting media recovery
archive log thread 1 sequence 255 is already on disk as
file /u01/ORACLE/dgtest9i/arch/arch255.log
archive log
filename=/u01/ORACLE/dgtest9i/arch/arch255.log thread=1 sequence=255
media recovery complete
Finished recover at 05-FEB-07
printing stored script: Memory Script
{
shutdown clone;
startup clone
nomount ;
}
executing script: Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 354387512 bytes
Fixed Size 742968 bytes
Variable Size 234881024 bytes
Database Buffers 117440512 bytes
Redo Buffers 1323008 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE
"dupdb" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 200
MAXINSTANCES 1
MAXLOGHISTORY 454
LOGFILE
GROUP 1 ( '/u01/ORACLE/dupdb/redo01.log' )
SIZE 10485760 REUSE,
GROUP 2 ( '/u01/ORACLE/dupdb/redo02.log' )
SIZE 10485760 REUSE,
GROUP 3 ( '/u01/ORACLE/dupdb/redo03.log' )
SIZE 10485760 REUSE
DATAFILE
'/u01/ORACLE/dupdb/system01.dbf'
CHARACTER SET
US7ASCII
printing stored script: Memory Script
{
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/undotbs01.dbf";
catalog clone
datafilecopy "/u01/ORACLE/dupdb/tools01.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/users01.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/users02.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/tools02.dbf";
catalog clone
datafilecopy "/u01/ORACLE/dupdb/example01.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/tools03.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/users03.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/users04.dbf";
catalog clone
datafilecopy "/u01/ORACLE/dupdb/tools04.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/drtest1.dbf";
catalog clone
datafilecopy
"/u01/ORACLE/dupdb/drtest3.dbf";
switch clone
datafile all;
}
executing script: Memory Script
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/undotbs01.dbf
recid=1 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/tools01.dbf
recid=2 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/users01.dbf
recid=3 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/users02.dbf
recid=4 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/tools02.dbf
recid=5 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/example01.dbf
recid=6 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/tools03.dbf
recid=7 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/users03.dbf
recid=8 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/users04.dbf
recid=9 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/tools04.dbf
recid=10 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/drtest1.dbf
recid=11 stamp=613746391
cataloged datafile copy
datafile copy filename=/u01/ORACLE/dupdb/drtest3.dbf
recid=12 stamp=613746391
datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=613746391 filename=/u01/ORACLE/dupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=613746391
filename=/u01/ORACLE/dupdb/tools01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=613746391
filename=/u01/ORACLE/dupdb/users01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=613746391
filename=/u01/ORACLE/dupdb/users02.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=613746391
filename=/u01/ORACLE/dupdb/tools02.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=613746391
filename=/u01/ORACLE/dupdb/example01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=613746391
filename=/u01/ORACLE/dupdb/tools03.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=613746391
filename=/u01/ORACLE/dupdb/users03.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=613746391
filename=/u01/ORACLE/dupdb/users04.dbf
datafile 11 switched to datafile copy
input datafilecopy recid=10 stamp=613746391
filename=/u01/ORACLE/dupdb/tools04.dbf
datafile 12 switched to datafile copy
input datafilecopy recid=11 stamp=613746391
filename=/u01/ORACLE/dupdb/drtest1.dbf
datafile 13 switched to datafile copy
input datafilecopy recid=12 stamp=613746391
filename=/u01/ORACLE/dupdb/drtest3.dbf
printing stored script: Memory Script
{
Alter clone
database open resetlogs;
}
executing script: Memory Script
database opened
Finished Duplicate Db at 05-FEB-07
released channel: C1
RMAN> **end-of-file**
9. Duplicate database ready.
NOTE: The DBID is changed and FORCED LOGGING
is set to NO. and now there are two pmon
processes one for each database.
SQL> select dbid,name,created,log_mode,force_logging
from v$database;
DBID NAME CREATED
LOG_MODE FORCED LOGGING
----------------
--------- --------------- ------------------
---------------------------
338960471 DUPDB
05-FEB-07 ARCHIVELOG NO
SQL> exit
dupdb:/opt/oracle>ps -ef | grep pmon
oracle 22385 1 0
10:39 ? 00:00:00 ora_pmon_dgtest9i
oracle
24085 1 0 10:41 ? 00:00:00 ora_pmon_dupdb
oracle 26510
17342 0 10:42 pts/2 00:00:00 grep pmon
dupdb:/opt/oracle>
After
registering this database in the listener. You may do a TNS promote.
No comments:
Post a Comment