rman rac duplicate with catalog and archive

1) Set below parameters in pfile and start the database in nomount stage.

*.db_name='HRPgnet2';

*.db_unique_name='HRPgnet2'

*.control_files='+HRPGNET2_DATA','+HRPGNET2_ARCH'

*.db_file_name_convert='+HRPGNEP2_DATA','+HRPGNET2_DATA'

*.log_file_name_convert='+HRPGNEP2_DATA','+HRPGNET2_DATA' 

SQL> startup nomount pfile='/HRPgnet2/oracle/initHRPgnet2.ora'

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2235208 bytes

Variable Size             507511992 bytes

Database Buffers          545259520 bytes

Redo Buffers               13930496 bytes

SQL> select open_mode from v$database;

select open_mode from v$database

                      *

ERROR at line 1:

ORA-01507: database not mounted

SQL>

2) Restore production controlfile

RMAN> connect target /;

connected to target database: HRPGNEP2 (not mounted)

RMAN> restore controlfile from '/HRPgnet2/oracle/11.2.0/dbs/snapcf_HRPgnep21.f';

Starting restore at 26-NOV-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1777 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+HRPGNET2_DATA/HRPgnep2/controlfile/current.297.832504631

output file name=+HRPGNET2_ARCH/HRPgnep2/controlfile/current.282.832504631

Finished restore at 26-NOV-13

RMAN> 

3) Catalog the backup pieces

rman

connect target / 

CATALOG START WITH '/backup/rman_1060/HRPgnep2/db_bkp_gnep2' NOPROMPT; 

run 

{

ALLOCATE CHANNEL ch00 TYPE DISK;

ALLOCATE CHANNEL ch01 TYPE DISK;

ALLOCATE CHANNEL ch02 TYPE DISK;

ALLOCATE CHANNEL ch03 TYPE DISK;

ALLOCATE CHANNEL ch04 TYPE DISK;

ALLOCATE CHANNEL ch05 TYPE DISK;

ALLOCATE CHANNEL ch06 TYPE DISK;

ALLOCATE CHANNEL ch07 TYPE DISK;

ALLOCATE CHANNEL ch08 TYPE DISK;

ALLOCATE CHANNEL ch09 TYPE DISK;

ALLOCATE CHANNEL ch10 TYPE DISK;

ALLOCATE CHANNEL ch11 TYPE DISK;

set newname for datafile 1 to '+HRPGNET2_DATA';

set newname for datafile 2 to '+HRPGNET2_DATA';

set newname for datafile 3 to '+HRPGNET2_DATA';

set newname for datafile 4 to '+HRPGNET2_DATA';

set newname for datafile 5 to '+HRPGNET2_DATA';

set newname for datafile 6 to '+HRPGNET2_DATA';

set newname for datafile 7 to '+HRPGNET2_DATA';

set newname for datafile 8 to '+HRPGNET2_DATA';

set newname for datafile 9 to '+HRPGNET2_DATA';

set newname for datafile 10 to '+HRPGNET2_DATA';

set newname for datafile 11 to '+HRPGNET2_DATA';

set newname for datafile 12 to '+HRPGNET2_DATA';

set newname for datafile 13 to '+HRPGNET2_DATA';

set newname for datafile 14 to '+HRPGNET2_DATA';

set newname for datafile 15 to '+HRPGNET2_DATA';

set newname for datafile 16 to '+HRPGNET2_DATA';

set newname for datafile 17 to '+HRPGNET2_DATA';

set newname for datafile 18 to '+HRPGNET2_DATA';

set newname for datafile 19 to '+HRPGNET2_DATA';

set newname for datafile 288 to '+HRPGNET2_DATA';

set newname for datafile 295 to '+HRPGNET2_DATA';

set newname for datafile 314 to '+HRPGNET2_DATA';

set newname for datafile 351 to '+HRPGNET2_DATA';

set newname for datafile 352 to '+HRPGNET2_DATA';

set newname for datafile 353 to '+HRPGNET2_DATA';

set newname for datafile 354 to '+HRPGNET2_DATA';

set newname for datafile 379 to '+HRPGNET2_DATA';

set newname for datafile 392 to '+HRPGNET2_DATA';

set newname for datafile 393 to '+HRPGNET2_DATA';

set newname for datafile 394 to '+HRPGNET2_DATA';

set newname for datafile 395 to '+HRPGNET2_DATA';

set newname for datafile 396 to '+HRPGNET2_DATA';

set newname for datafile 397 to '+HRPGNET2_DATA';

set newname for datafile 398 to '+HRPGNET2_DATA';

set newname for datafile 399 to '+HRPGNET2_DATA';

set newname for datafile 400 to '+HRPGNET2_DATA';

set newname for datafile 401 to '+HRPGNET2_DATA';

set newname for datafile 402 to '+HRPGNET2_DATA';

set newname for datafile 403 to '+HRPGNET2_DATA';

set newname for datafile 404 to '+HRPGNET2_DATA';

set newname for datafile 405 to '+HRPGNET2_DATA';

set newname for datafile 406 to '+HRPGNET2_DATA';

set newname for datafile 407 to '+HRPGNET2_DATA';

restore database;

switch datafile all;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

RELEASE CHANNEL ch07;

RELEASE CHANNEL ch08;

RELEASE CHANNEL ch09;

RELEASE CHANNEL ch10;

RELEASE CHANNEL ch11;

}

Once the restore is completed , please recover the database using recover database; command and open the database with resetlogs.