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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 124754870893;

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 1120731298721;

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

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 9 11:57:54 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 '10-APR-2025';

list backup of controlfile completed before '10-APR-2025';

List of Backup Sets

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2117061 Full 57.58M DISK 00:00:00 09-APR-25

BP Key: 2117063 Status: AVAILABLE Compressed: NO Tag: TAG20250409T015636

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

Control File Included: Ckp SCN: 124754865839 Ckp time: 09-APR-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2117102 Full 57.58M DISK 00:00:01 09-APR-25

BP Key: 2117104 Status: AVAILABLE Compressed: NO Tag: TAG20250409T020011

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

Control File Included: Ckp SCN: 124754870893 Ckp time: 09-APR-25

BS Key Type LV Size Device Type Elapsed Time Completion Time

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

2117155 Full 57.58M DISK 00:00:00 09-APR-25

BP Key: 2117161 Status: AVAILABLE Compressed: NO Tag: TAG20250409T090149

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

Control File Included: Ckp SCN: 124755867635 Ckp time: 09-APR-25

RMAN>

alternative:

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 106974398467;