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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 126181299101;

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 Fri Jan 2 10:10:35 2026

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 '03-JAN-2026';

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

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2368507 Full 57.58M DISK 00:00:00 02-JAN-26

BP Key: 2368509 Status: AVAILABLE Compressed: NO Tag: TAG20260102T010531

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

Control File Included: Ckp SCN: 126181273811 Ckp time: 02-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2368548 Full 57.58M DISK 00:00:00 02-JAN-26

BP Key: 2368550 Status: AVAILABLE Compressed: NO Tag: TAG20260102T020012

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

Control File Included: Ckp SCN: 126181299101 Ckp time: 02-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2368601 Full 57.58M DISK 00:00:00 02-JAN-26

BP Key: 2368607 Status: AVAILABLE Compressed: NO Tag: TAG20260102T090108

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

Control File Included: Ckp SCN: 126181979576 Ckp time: 02-JAN-26

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');