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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 127028473232;

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/oracle/admin/fsprod>rman target / catalog fsprod19/bkup_123@rmprod

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jun 23 10:13:48 2026

Version 19.30.0.0.0

connected to target database: FSPROD (DBID=2773054092)

connected to recovery catalog database

RMAN> list backup of controlfile completed before '24-JUN-2026';

list backup of controlfile completed before '24-JUN-2026';

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2516747 Full 57.58M DISK 00:00:00 23-JUN-26

BP Key: 2516749 Status: AVAILABLE Compressed: NO Tag: TAG20260623T011111

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

Control File Included: Ckp SCN: 127028453864 Ckp time: 23-JUN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2516788 Full 57.58M DISK 00:00:00 23-JUN-26

BP Key: 2516790 Status: AVAILABLE Compressed: NO Tag: TAG20260623T020006

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

Control File Included: Ckp SCN: 127028473232 Ckp time: 23-JUN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2516832 Full 57.58M DISK 00:00:00 23-JUN-26

BP Key: 2516836 Status: AVAILABLE Compressed: NO Tag: TAG20260623T090043

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

Control File Included: Ckp SCN: 127029200131 Ckp time: 23-JUN-26

RMAN>

DUPLICATE target database to fsdvlp

nofilenamecheck

db_file_name_convert = (

'fsprod','fsdvlp'

);

}

spool log off