Tuesday, October 6, 2009

Duplicate database using RMAN on the same host

Applies to:
Oracle Server - Enterprise Edition - Version: 9.0.1.4 to 10.2.0.3
Information in this document applies to any platform.
Goal
The following note will guide a user in creating a duplicate database on the same  host (non ASM).  The scenario does not refer to a recovery catalog however a catalog can also be used. The following example has been completed on a linux box ITLINUXDEVBLADE07.
Solution
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 Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
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 Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  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 Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
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

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.
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 Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
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 Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  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 Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
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
UNION
select distinct substr(member,1,instr(UPPER(member),'ORACLE',1) - 1) "FILESYSTEM"
from v$logfile
UNION
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.
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.
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**

Duplicate database  ready.

 NOTE: The DBID is changed and FORCED LOGGING is set to NO.


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

No comments:

Post a Comment