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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 127475347952;

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 Tue Sep 22 11:17:52 2026

Version 19.32.0.0.0

connected to target database: FSPROD (DBID=2773054092)

connected to recovery catalog database

RMAN> list backup of controlfile completed before '23-SEP-2026';

list backup of controlfile completed before '23-SEP-2026';

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2606287 Full 57.58M DISK 00:00:00 22-SEP-26

BP Key: 2606289 Status: AVAILABLE Compressed: NO Tag: TAG20260922T010747

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

Control File Included: Ckp SCN: 127475144382 Ckp time: 22-SEP-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2606328 Full 57.58M DISK 00:00:00 22-SEP-26

BP Key: 2606330 Status: AVAILABLE Compressed: NO Tag: TAG20260922T040008

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

Control File Included: Ckp SCN: 127475229121 Ckp time: 22-SEP-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2606355 Full 57.58M DISK 00:00:00 22-SEP-26

BP Key: 2606357 Status: AVAILABLE Compressed: NO Tag: TAG20260922T060007

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

Control File Included: Ckp SCN: 127475347952 Ckp time: 22-SEP-26

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2606405 Full 57.58M DISK 00:00:00 22-SEP-26

BP Key: 2606410 Status: AVAILABLE Compressed: NO Tag: TAG20260922T090049

Piece Name: /usr/opt/app/dbdump/hot_backup/FSPROD/FSPROD_AutoCTL_c-2773054092-20260922-03.bak

Control File Included: Ckp SCN: 127475942499 Ckp time: 22-SEP-26

RMAN>

alternative:

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 106974398467;