Duplicate database using RMAN on the same host

Primary Database SID:       APPLEPRD
Duplicate Database SID:    APPLEDEV
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.

  1. Identify and Backup the primary database

:/opt/oracle>. setAPPLEPRD

APPLEPRD:/opt/oracle> sql

SQL> select dbid,name,created,log_mode,force_logging from v$database;

DBID           NAME         CREATED   LOG_MODE      FORCED LOGGING

————– ————— ————— ——————–     —————————

237270920  APPLEPRD  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

APPLEPRD:/opt/oracle/admin/APPLEDEV/rman>rman target /

Recovery Manager: Release 9.2.0.4.0 – 64bit Production

connected to target database: APPLEPRD (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: APPLEPRD.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: APPLEPRD.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/APPLEPRD/system01.dbf

2       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/undotbs01.dbf

3       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools01.dbf

4       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users01.dbf

5       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users02.dbf

6       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools02.dbf

7       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/example01.dbf

8       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools03.dbf

9       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users03.dbf

10      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users04.dbf

11      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools04.dbf

12      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/drtest1.dbf

13      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/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: APPLEPRD.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:

APPLEPRD:/opt/oracle/admin/APPLEDEV/rman>rman target /

Recovery Manager: Release 9.2.0.4.0 – 64bit Production

connected to target database: APPLEPRD (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/APPLEPRD/arch/arch190.log; already backed up 1 time(s)

skipping archive log file /u01/ORACLE/APPLEPRD/arch/arch191.log; already backed up 1 time(s)

skipping archive log file /u01/ORACLE/APPLEPRD/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=APPLEPRD.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

  1. 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.

APPLEPRD:/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

  1. Making the backup available for the duplicate process.

Verify the  backup is available.

APPLEPRD:/opt/oracle/admin/APPLEDEV/rman>rman target /

Recovery Manager: Release 9.2.0.4.0 – 64bit Production

connected to target database: APPLEPRD (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: APPLEPRD.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: APPLEPRD.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/APPLEPRD/system01.dbf

2       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/undotbs01.dbf

3       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools01.dbf

4       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users01.dbf

5       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users02.dbf

6       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools02.dbf

7       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/example01.dbf

8       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools03.dbf

9       Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users03.dbf

10      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/users04.dbf

11      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/tools04.dbf

12      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/drtest1.dbf

13      Full 15423009   05-FEB-07 /u01/ORACLE/APPLEPRD/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: APPLEPRD.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 APPLEPRD APPLEDEV

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  APPLEDEV

Copy the original initora file of the primary database in this case initAPPLEPRD.ora and replace all APPLEPRD references to APPLEDEV and make all necessary directory changes.

*.background_dump_dest=’/opt/oracle/admin/APPLEDEV/bdump’

*.control_files=’/u01/ORACLE/APPLEDEV/control01.ctl’

*.core_dump_dest=’/opt/oracle/admin/APPLEDEV/cdump’

*.db_block_size=16384

*.db_cache_size=104857600

*.db_file_multiblock_read_count=8

*.db_file_name_convert=’/u01/ORACLE/APPLEPRD/’,’/u01/ORACLE/APPLEDEV/’

*.db_name=’APPLEDEV’

*.java_pool_size=52428800

*.job_queue_processes=10

*.large_pool_size=8388608

*.log_archive_dest_1=’LOCATION=/u01/ORACLE/APPLEDEV/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/APPLEPRD/’,’/u01/ORACLE/APPLEDEV/’

*.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>. setAPPLEDEV

APPLEDEV:/opt/oracle> cd $ORACLE_HOME/dbs

APPLEDEV:/opt/oracle/product9204/dbs>orapwd file=orapwAPPLEDEV password=oracle entries=5

APPLEDEV:/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.

APPLEDEV:/opt/oracle/admin/APPLEDEV/rman>sqlplus ‘sys/oracle@APPLEPRD as sysdba’

APPLEDEV:/opt/oracle/admin/APPLEDEV/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.

APPLEPRD:/opt/oracle/admin/APPLEDEV/rman>rman target /

Recovery Manager: Release 9.2.0.4.0 – 64bit Production

connected to target database: APPLEPRD (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/APPLEPRD/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.APPLEPRDd.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 APPLEPRD

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/ORACLE/fAPPLEPRD/arch

Oldest online log sequence     254

Next log sequence to archive   256

Current log sequence           256

Create a script create_APPLEDEV.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.APPLEPRDd.opt)’;

allocate auxiliary channel aux1 device type ‘SBT_TAPE’ PARMS ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.APPLEPRDd.opt)’;

SET UNTIL SEQUENCE 256 THREAD 1;

duplicate target database to APPLEDEV;

}

Start the APPLEDEV instance in NOMOUNT mode. This will be your auxiliary instance.

:/opt/oracle> . setAPPLEDEV

APPLEDEV:/opt/oracle> sql

SQL*Plus: Release 9.2.0.4.0 – Production on Tue Feb 6 09:55:42 2007

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.

APPLEDEV:/opt/oracle/admin/APPLEDEV/rman>rman target  sys/oracle@ APPLEPRD 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: APPLEPRD (DBID=237270920)

connected to auxiliary database: APPLEDEV (not mounted)

RMAN> spool log to APPLEDEV_creation.log

RMAN> @ create_APPLEDEV.rcv

RMAN> 1 > 2 > 3 > 4 >

Open another duplicate OS session and navigate to the directory that has the log file APPLEDEV_creation.log and do a tail –f APPLEDEV_creation.log to monitor the progress of the duplication.

APPLEDEV:/opt/oracle/admin/APPLEDEV/rman> tail –f APPLEDEV_creation.log

Spooling started in log file: APPLEDEV_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.APPLEPRDd.opt)’;

3> allocate auxiliary channel aux1 device type ‘SBT_TAPE’ PARMS ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.APPLEPRDd.opt)’;

4> SET UNTIL SEQUENCE 256 THREAD 1;

5> duplicate target database to APPLEDEV;

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/APPLEDEV/system01.dbf”;

set newname for datafile  2 to

“/u01/ORACLE/APPLEDEV/undotbs01.dbf”;

set newname for datafile  3 to

“/u01/ORACLE/APPLEDEV/tools01.dbf”;

set newname for datafile  4 to

“/u01/ORACLE/APPLEDEV/users01.dbf”;

set newname for datafile  5 to

“/u01/ORACLE/APPLEDEV/users02.dbf”;

set newname for datafile  6 to

“/u01/ORACLE/APPLEDEV/tools02.dbf”;

set newname for datafile  7 to

“/u01/ORACLE/APPLEDEV/example01.dbf”;

set newname for datafile  8 to

“/u01/ORACLE/APPLEDEV/tools03.dbf”;

set newname for datafile  9 to

“/u01/ORACLE/APPLEDEV/users03.dbf”;

set newname for datafile  10 to

“/u01/ORACLE/APPLEDEV/users04.dbf”;

set newname for datafile  11 to

“/u01/ORACLE/APPLEDEV/tools04.dbf”;

set newname for datafile  12 to

“/u01/ORACLE/APPLEDEV/drtest1.dbf”;

set newname for datafile  13 to

“/u01/ORACLE/APPLEDEV/drtest3.dbf”;

restore

check readonly

clone database

;

}

executing script: Memory Script

executing command: SET until claus

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/APPLEDEV/system01.dbf

restoring datafile 00002 to /u01/ORACLE/APPLEDEV/undotbs01.dbf

restoring datafile 00003 to /u01/ORACLE/APPLEDEV/tools01.dbf

restoring datafile 00004 to /u01/ORACLE/APPLEDEV/users01.dbf

restoring datafile 00005 to /u01/ORACLE/APPLEDEV/users02.dbf

restoring datafile 00006 to /u01/ORACLE/APPLEDEV/tools02.dbf

restoring datafile 00007 to /u01/ORACLE/APPLEDEV/example01.dbf

restoring datafile 00008 to /u01/ORACLE/APPLEDEV/tools03.dbf

restoring datafile 00009 to /u01/ORACLE/APPLEDEV/users03.dbf

restoring datafile 00010 to /u01/ORACLE/APPLEDEV/users04.dbf

restoring datafile 00011 to /u01/ORACLE/APPLEDEV/tools04.dbf

restoring datafile 00012 to /u01/ORACLE/APPLEDEV/drtest1.dbf

restoring datafile 00013 to /u01/ORACLE/APPLEDEV/drtest3.dbf

channel aux1: restored backup piece 1

piece handle=APPLEPRD.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 “APPLEDEV” RESETLOGS ARCHIVELOG

MAXLOGFILES     16

MAXLOGMEMBERS      2

MAXDATAFILES      200

MAXINSTANCES     1

MAXLOGHISTORY      454

LOGFILE

GROUP  1 ( ‘/u01/ORACLE/APPLEDEV/redo01.log’ ) SIZE   10485760  REUSE,

GROUP  2 ( ‘/u01/ORACLE/APPLEDEV/redo02.log’ ) SIZE   10485760  REUSE,

GROUP  3 ( ‘/u01/ORACLE/APPLEDEV/redo03.log’ ) SIZE   10485760  REUSE

DATAFILE

‘/u01/ORACLE/APPLEDEV/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/APPLEDEV/undotbs01.dbf

datafile 3 switched to datafile copy

input datafilecopy recid=2 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/tools01.dbf

datafile 4 switched to datafile copy

input datafilecopy recid=3 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/users01.dbf

datafile 5 switched to datafile copy

input datafilecopy recid=4 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/users02.dbf

datafile 6 switched to datafile copy

input datafilecopy recid=5 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/tools02.dbf

datafile 7 switched to datafile copy

input datafilecopy recid=6 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/example01.dbf

datafile 8 switched to datafile copy

input datafilecopy recid=7 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/tools03.dbf

datafile 9 switched to datafile copy

input datafilecopy recid=8 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/users03.dbf

datafile 10 switched to datafile copy

input datafilecopy recid=9 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/users04.dbf

datafile 11 switched to datafile copy

input datafilecopy recid=10 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/tools04.dbf

datafile 12 switched to datafile copy

input datafilecopy recid=11 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/drtest1.dbf

datafile 13 switched to datafile copy

input datafilecopy recid=12 stamp=613746385 filename=/u01/ORACLE/APPLEDEV/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/APPLEPRD/arch/arch255.log

archive log filename=/u01/ORACLE/APPLEPRD/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 “APPLEDEV” RESETLOGS ARCHIVELOG

MAXLOGFILES     16

MAXLOGMEMBERS      2

MAXDATAFILES      200

MAXINSTANCES     1

MAXLOGHISTORY      454

LOGFILE

GROUP  1 ( ‘/u01/ORACLE/APPLEDEV/redo01.log’ ) SIZE   10485760  REUSE,

GROUP  2 ( ‘/u01/ORACLE/APPLEDEV/redo02.log’ ) SIZE   10485760  REUSE,

GROUP  3 ( ‘/u01/ORACLE/APPLEDEV/redo03.log’ ) SIZE   10485760  REUSE

DATAFILE

‘/u01/ORACLE/APPLEDEV/system01.dbf’

CHARACTER SET US7ASCII

printing stored script: Memory Script

{

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/undotbs01.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/tools01.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/users01.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/users02.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/tools02.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/example01.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/tools03.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/users03.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/users04.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/tools04.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/drtest1.dbf”;

catalog clone datafilecopy  “/u01/ORACLE/APPLEDEV/drtest3.dbf”;

switch clone datafile all;

}

executing script: Memory Script

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/undotbs01.dbf recid=1 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/tools01.dbf recid=2 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/users01.dbf recid=3 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/users02.dbf recid=4 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/tools02.dbf recid=5 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/example01.dbf recid=6 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/tools03.dbf recid=7 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/users03.dbf recid=8 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/users04.dbf recid=9 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/tools04.dbf recid=10 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/drtest1.dbf recid=11 stamp=613746391

cataloged datafile copy

datafile copy filename=/u01/ORACLE/APPLEDEV/drtest3.dbf recid=12 stamp=613746391

datafile 2 switched to datafile copy

input datafilecopy recid=1 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/undotbs01.dbf

datafile 3 switched to datafile copy

input datafilecopy recid=2 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/tools01.dbf

datafile 4 switched to datafile copy

input datafilecopy recid=3 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/users01.dbf

datafile 5 switched to datafile copy

input datafilecopy recid=4 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/users02.dbf

datafile 6 switched to datafile copy

input datafilecopy recid=5 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/tools02.dbf

datafile 7 switched to datafile copy

input datafilecopy recid=6 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/example01.dbf

datafile 8 switched to datafile copy

input datafilecopy recid=7 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/tools03.dbf

datafile 9 switched to datafile copy

input datafilecopy recid=8 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/users03.dbf

datafile 10 switched to datafile copy

input datafilecopy recid=9 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/users04.dbf

datafile 11 switched to datafile copy

input datafilecopy recid=10 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/tools04.dbf

datafile 12 switched to datafile copy

input datafilecopy recid=11 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/drtest1.dbf

datafile 13 switched to datafile copy

input datafilecopy recid=12 stamp=613746391 filename=/u01/ORACLE/APPLEDEV/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**

  1. 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 APPLEDEV 05-FEB-07  ARCHIVELOG   NO

SQL>  exit

APPLEDEV:/opt/oracle>ps -ef | grep pmon

oracle   22385     1  0 10:39 ?        00:00:00 ora_pmon_APPLEPRD

oracle   24085     1  0 10:41 ?        00:00:00 ora_pmon_APPLEDEV

oracle   26510 17342  0 10:42 pts/2    00:00:00 grep pmon

APPLEDEV:/opt/oracle>

After registering this database in the listener. You may  do a TNS promote.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s