Oracle: RMAN restore command for fscnv1

 From fsprod:

>rman target / catalog fsprod19/bkup_123@rmprod auxiliary sys/Z_GC3HLU7ZfguQxgw@fscnv1

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

RMAN> run {

startup clone nomount;

allocate auxiliary channel aux1 device type disk;

set until scn 127546791093;

DUPLICATE target database to fscnv1 

nofilenamecheck

db_file_name_convert = (

'fsprod','fscnv1'

);

}

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


Recovery Manager: Release 19.0.0.0.0 - Production on Tue Oct 6 09:40:03 2026

Version 19.32.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


connected to target database: FSPROD (DBID=2773054092)

connected to recovery catalog database


RMAN> list backup of controlfile completed before '07-OCT-2026';

list backup of controlfile completed before '07-OCT-2026';


List of Backup Sets

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



BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2620119 Full    57.58M     DISK        00:00:01     06-OCT-26

        BP Key: 2620121   Status: AVAILABLE  Compressed: NO  Tag: TAG20261006T010707

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

  Control File Included: Ckp SCN: 127546316468   Ckp time: 06-OCT-26


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2620160 Full    57.58M     DISK        00:00:01     06-OCT-26

        BP Key: 2620162   Status: AVAILABLE  Compressed: NO  Tag: TAG20261006T020005

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

  Control File Included: Ckp SCN: 127546339103   Ckp time: 06-OCT-26


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2620187 Full    57.58M     DISK        00:00:01     06-OCT-26

        BP Key: 2620189   Status: AVAILABLE  Compressed: NO  Tag: TAG20261006T040007

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

  Control File Included: Ckp SCN: 127546446113   Ckp time: 06-OCT-26


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2620222 Full    57.58M     DISK        00:00:01     06-OCT-26

        BP Key: 2620225   Status: AVAILABLE  Compressed: NO  Tag: TAG20261006T060021

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

  Control File Included: Ckp SCN: 127546791093   Ckp time: 06-OCT-26


BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

2620273 Full    57.58M     DISK        00:00:01     06-OCT-26

        BP Key: 2620278   Status: AVAILABLE  Compressed: NO  Tag: TAG20261006T090052

        Piece Name: /usr/opt/app/dbdump/hot_backup/FSPROD/FSPROD_AutoCTL_c-2773054092-20261006-04.bak

  Control File Included: Ckp SCN: 127547497714   Ckp time: 06-OCT-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');

}


Comments

Post a Comment

Popular posts from this blog

Postgres: To list table owners

SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename; ---- SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname <> tableowner AND  schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename;
Read more

PeopleSoft: Clean Up PUM

  Manual Cleanup steps for WINDOWS Before carrying out the advanced steps in this section: Run the command:  psft-dpk-setup.bat --cleanup. If you deployed the environment using the use_alternate_puppet_install option, use this command:   psft-dpk-setup.bat --cleanup --use_alternate_puppet_install If the script displays a FAILED message, run it again. If it succeeds, check the BASE_DIR folders to be sure everything has been deleted. If the BASE_DIR folders are not clear, or if a subsequent deployment is not successful, carry out the steps below. For the  ADVANCED CLEAN UP PROCESS  on Microsoft Windows, please see the following steps. NOTE: These should be performed by someone familiar with modifying the Microsoft Windows registry. Depending upon where the cleanup process failed, some of the items mentioned in these steps may have already been removed. The user should remove whatever remains in this order: Start the Microsoft Windows Services utilit...
Read more

Postgres: To check the locale / Character set settings

  To check the locale settings in PostgreSQL, you can use the following SQL query: SHOW lc_collate; SHOW lc_ctype; SHOW lc_messages; SHOW lc_monetary; SHOW lc_numeric; SHOW lc_time; Explanation: lc_collate : Defines the collation order (sorting rules) for strings. lc_ctype : Specifies the character classification (e.g., upper/lower case). lc_messages : Determines the language for system messages. lc_monetary : Sets the locale for monetary formatting. lc_numeric : Configures the locale for numeric formatting. lc_time : Specifies the locale for date and time formatting. You can run these commands in your PostgreSQL client (e.g., psql ) to view the current locale settings. If you need to change them, you can configure them in the postgresql.conf file or during database initialization.
Read more