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/restorefsdvlpJan29th.txt;

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 126322232630 ;

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 Fri Jan 30 10:49:28 2026

Version 19.26.0.0.0

connected to target database: FSPROD (DBID=2773054092)

connected to recovery catalog database

recovery catalog schema version 19.28.00.00. is newer than RMAN version

RMAN> list backup of controlfile completed before '31-JAN-2026';

list backup of controlfile completed before '31-JAN-2026';

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2393969 Full 57.58M DISK 00:00:00 30-JAN-26

BP Key: 2393971 Status: AVAILABLE Compressed: NO Tag: TAG20260130T010609

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

Control File Included: Ckp SCN: 126322210071 Ckp time: 30-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2394010 Full 57.58M DISK 00:00:00 30-JAN-26

BP Key: 2394012 Status: AVAILABLE Compressed: NO Tag: TAG20260130T020016

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

Control File Included: Ckp SCN: 126322232630 Ckp time: 30-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2394054 Full 57.58M DISK 00:00:00 30-JAN-26

BP Key: 2394058 Status: AVAILABLE Compressed: NO Tag: TAG20260130T090048

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

Control File Included: Ckp SCN: 126322854346 Ckp time: 30-JAN-26

RMAN>

DUPLICATE target database to fsdvlp

nofilenamecheck

db_file_name_convert = (

'fsprod','fsdvlp'

);

}

spool log off