Oracle: Restore command for fsdvlp

Run PT_CONFIG_TABLE_EXP.DMS to capture tools tables from target environment - fsdvlp

From FSPROD:

>rman target / catalog fsprod/bkup_123@rmprod auxiliary sys/Ysw8PTgJ@fsdvlp <-- OLD - DO NOT USE

>rman target / catalog fsprod19/bkup_123@rmprod auxiliary sys/Z_GC3HLU7ZfguQxgw@fsdvlp <-- USE THIS

RMAN> spool log to /usr/local/oracle/restorefsdvlpApr16th.txt;

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 124791124359 ;

DUPLICATE target database to fsdvlp

nofilenamecheck

db_file_name_convert = ('/usr/opt/app/oracle/admin/fsprod/data01', '/usr/opt/app/oracle/admin/fsdvlp/data01'

'/usr/opt/app/oracle/admin/fsprod/ndx01', '/usr/opt/app/oracle/admin/fsdvlp/ndx01'

'/usr/opt/app/oracle/admin/fsprod/flash01', '/usr/opt/app/oracle/admin/fsdvlp/flash01'

'/usr/opt/app/oracle/admin/fsprod/red01', '/usr/opt/app/oracle/admin/fsdvlp/redo01'

'/usr/opt/app/oracle/admin/fsprod/red02', '/usr/opt/app/oracle/admin/fsdvlp/redo02'

'/usr/opt/app/oracle/admin/fsprod/system01', '/usr/opt/app/oracle/admin/fsdvlp/system01'

'/usr/opt/app/oracle/admin/fsprod/ext01', '/usr/opt/app/oracle/admin/fsdvlp/ext01'

'/usr/opt/app/oracle/admin/fsprod/temp01', '/usr/opt/app/oracle/admin/fsdvlp/temp01'

'/usr/opt/app/oracle/admin/fsprod/undo01', '/usr/opt/app/oracle/admin/fsdvlp/undo01'

'/usr/opt/app/oracle/admin/fsprod/undo02', '/usr/opt/app/oracle/admin/fsdvlp/undo02'

'/usr/opt/app/oracle/admin/fsprod/arch', '/usr/opt/app/oracle/admin/fsdvlp/arch'

'/usr/opt/app/oracle/admin/fsprod/xdb_wallet', '/usr/opt/app/oracle/admin/fsdvlp/xdb_wallet');

}

RMAN> spool log off;

oracle-psfststdb601.tmw.com:fsdvlp:/usr/opt/app/oracle/admin/fsdvlp>rman target / catalog fsdvlp/bkup_123@rmprod

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Sep 17 15:56:07 2019

connected to target database: FSDVLP (DBID=309128574)

connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

log_file_name_convert =('/usr/opt/app/oracle/admin/fsprod/redo01', '/usr/opt/app/oracle/admin/fsdvlp/redo01');

}

It is preferred that you use 'set until . . . ' else rman will look for most recent archive logs if you don't use that clause,

and you can get these errors while restoring: RMAN-06053 and RMAN-06025

oracle-psfsdb602.tmw.com:fsprod:/usr/opt/app/dbdump/hot_backup/fsprod>rman target / catalog fsprod19/bkup_123@rmprod

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 16 10:42:52 2025

Version 19.26.0.0.0

connected to target database: FSPROD (DBID=2773054092)

connected to recovery catalog database

RMAN> list backup of controlfile completed before '17-APR-2025';

list backup of controlfile completed before '17-APR-2025';

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2122613 Full 57.58M DISK 00:00:01 16-APR-25

BP Key: 2122615 Status: AVAILABLE Compressed: NO Tag: TAG20250416T020514

Piece Name: /usr/opt/app/dbdump/hot_backup/FSPROD/FSPROD_AutoCTL_c-2773054092-20250416-00.bak

Control File Included: Ckp SCN: 124791123940 Ckp time: 16-APR-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2122654 Full 57.58M DISK 00:00:01 16-APR-25

BP Key: 2122656 Status: AVAILABLE Compressed: NO Tag: TAG20250416T020613

Piece Name: /usr/opt/app/dbdump/hot_backup/FSPROD/FSPROD_AutoCTL_c-2773054092-20250416-01.bak

Control File Included: Ckp SCN: 124791124359 Ckp time: 16-APR-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2122701 Full 57.58M DISK 00:00:01 16-APR-25

BP Key: 2122706 Status: AVAILABLE Compressed: NO Tag: TAG20250416T090148

Piece Name: /usr/opt/app/dbdump/hot_backup/FSPROD/FSPROD_AutoCTL_c-2773054092-20250416-02.bak

Control File Included: Ckp SCN: 124791850939 Ckp time: 16-APR-25

RMAN>

DUPLICATE target database to fsdvlp

nofilenamecheck

db_file_name_convert = (

'fsprod','fsdvlp'

);

}

spool log off