Oracle: RMAN restore command for fstest

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

From FSPROD:

>rman target / catalog fsprod/bkup_123@rmprod auxiliary sys/Ysw8PTgJ@fstest

>rman target / catalog fsprod19/bkup_123@rmprod auxiliary sys/Z_GC3HLU7ZfguQxgw@fstest <-- in post refresh scripts and in pwdfile

>rman target / catalog fsprod19/bkup_123@rmprod auxiliary sys/v_YHk3vaC8bb2PCuJ@fstest <-- do not USE THIS

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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 126297357596;

DUPLICATE target database to fstest

nofilenamecheck

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

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

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

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

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

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

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

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

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

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

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

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

}

spool log off

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 126297357596;

DUPLICATE target database to fstest

nofilenamecheck

db_file_name_convert = (

'fsprod','fstest'

);

}

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

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 Mon Jan 26 10:13:47 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 '27-JAN-2026';

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

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2390090 Full 57.58M DISK 00:00:00 26-JAN-26

BP Key: 2390092 Status: AVAILABLE Compressed: NO Tag: TAG20260126T010510

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

Control File Included: Ckp SCN: 126297311257 Ckp time: 26-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2390131 Full 57.58M DISK 00:00:00 26-JAN-26

BP Key: 2390133 Status: AVAILABLE Compressed: NO Tag: TAG20260126T020012

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

Control File Included: Ckp SCN: 126297357596 Ckp time: 26-JAN-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2390181 Full 57.58M DISK 00:00:00 26-JAN-26

BP Key: 2390186 Status: AVAILABLE Compressed: NO Tag: TAG20260126T090059

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

Control File Included: Ckp SCN: 126298888082 Ckp time: 26-JAN-26

RMAN>

alternative:

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 106974398467;