PeopleSoft: Restore CMD To Restore FSDBUG

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

From fsprod:

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

>rman target / catalog fsprod19/bkup_123@rmprod auxiliary sys/v_YHk3vaC8bb2PCuJ@fsdbug <-- DO NOT USE

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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 125829440883;

DUPLICATE target database to fsdbug

nofilenamecheck

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

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

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

'/usr/opt/app/oracle/admin/fsprod/redo01', '/usr/opt/app/oracle/admin/fsdbug/redo01'

'/usr/opt/app/oracle/admin/fsprod/redo02', '/usr/opt/app/oracle/admin/fsdbug/redo02'

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

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

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

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

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

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

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

}

spool log off;

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

on FSPROD:

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 Sat Oct 25 09:43:32 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 '26-OCT-2025';

list backup of controlfile completed before '26-OCT-2025';

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2305549 Full 57.58M DISK 00:00:01 25-OCT-25

BP Key: 2305551 Status: AVAILABLE Compressed: NO Tag: TAG20251025T014321

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

Control File Included: Ckp SCN: 125829433943 Ckp time: 25-OCT-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2305590 Full 57.58M DISK 00:00:00 25-OCT-25

BP Key: 2305592 Status: AVAILABLE Compressed: NO Tag: TAG20251025T020008

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

Control File Included: Ckp SCN: 125829440883 Ckp time: 25-OCT-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2305637 Full 57.58M DISK 00:00:00 25-OCT-25

BP Key: 2305642 Status: AVAILABLE Compressed: NO Tag: TAG20251025T090113

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

Control File Included: Ckp SCN: 125829887139 Ckp time: 25-OCT-25

RMAN>

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

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

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

'/usr/opt/app/oracle/admin/fsprod/redo01', '/usr/opt/app/oracle/admin/fsdbug/redo01'

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

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

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

'/usr/opt/app/oracle/admin/fsprod/arch', '/usr/opt/app/oracle/admin/fsdbug/arch');