RMAN - Restore to new host operating system using CDB standby database using rman backup on 12.2.0.1.0 database

 RMAN -   Restore to new host operating system using CDB standby database  using rman backup on 12.2.0.1.0 database  

Scenario: We have 2 node CDB RAC 12.2.0.1.0 verion having non rac single physical standby database. We take rman backup from standby database. 

2 node rac instance : rac1, rac2

Physical standby : racdr 

Using rman backup we restore into new host with same name and figure out steps and challanges. 

We take rman backup

• Take rman backup from standby database and transfer to new host machine 
• Create pfile and mentioned  and create directory mentioned in pfile
• Start database in no-mount stage using pfile
• Connect rman console and restore control from standby backup
• Open database in mount stage ( database in physical standby mode)
• Catalog the backup from location 
• Restore and recover database 
• Clear redolog file and add new redologfile
• Failover standby database to primary database
• Remove undo tablespace and redo  thread #2 
• Remove temporary  tablespace and create new temporary tablespace, make it default tablespace. 

• Start database in nomount stage on new hosts  ( new pfile already created before startup)

[oracle@oem dbs]$ . oraenv

ORACLE_SID = [oemrep] ? racdr

ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.2.0/dbhome_1

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1862270976 bytes

Fixed Size                  8794024 bytes

Variable Size             687865944 bytes

Database Buffers         1157627904 bytes

Redo Buffers                7983104 bytes

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

• Recover controlfile using rman backup taken from standby database 

[oracle@oem dbs]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Wed Dec 29 13:36:48 2021

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

connected to target database: RAC (not mounted)

RMAN> restore controlfile from '/u01/rman_srv4/control_RAC_20211217.bak';

Starting restore at 29-DEC-2021 13:37:01

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=537 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=/u01/app/oracle/oradata/rac/control01.ctl

output file name=/u01/app/oracle/fast_recovery_area/rac/control02.ctl

Finished restore at 29-DEC-2021 13:37:03

• Open database in mount stage 

RMAN> alter database mount;

Statement processed

released channel: ORA_DISK_1

• Catalog rman backup from standby database 

RMAN> catalog start with '/u01/rman_srv4';

searching for all files that match the pattern /u01/rman_srv4

List of Files Unknown to the Database

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

File Name: /u01/rman_srv4/Backup_RAC_DB_0t0go0cb_29_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1f0gvcji_47_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_0u0go0cb_30_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0s0go0cb_28_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_110go0dp_33_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0v0go0do_31_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1k0gvck4_52_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_0r0go0br_27_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1m0gvcl7_54_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1e0gvcif_46_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_100go0do_32_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1h0gvck1_49_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1o0gvcma_56_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_120go0e8_34_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1l0gvck4_53_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1i0gvck1_50_1_20211217

File Name: /u01/rman_srv4/standbycontrol_RAC_1r0gvcn6_1_1.ctl

File Name: /u01/rman_srv4/Backup_RAC_DB_0q0go0bc_26_1_20211214

File Name: /u01/rman_srv4/control_RAC_20211217.bak

File Name: /u01/rman_srv4/Backup_RAC_DB_0p0go0bc_25_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0o0go0bc_24_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1p0gvcmb_57_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1g0gvcjq_48_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_130go0en_35_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1d0gvcif_45_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_140go0en_36_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1j0gvck2_51_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1n0gvcl7_55_1_20211217

Do you really want to catalog the above files (enter YES or NO)? YEs

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /u01/rman_srv4/Backup_RAC_DB_0t0go0cb_29_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1f0gvcji_47_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_0u0go0cb_30_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0s0go0cb_28_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_110go0dp_33_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0v0go0do_31_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1k0gvck4_52_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_0r0go0br_27_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1m0gvcl7_54_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1e0gvcif_46_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_100go0do_32_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1h0gvck1_49_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1o0gvcma_56_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_120go0e8_34_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1l0gvck4_53_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1i0gvck1_50_1_20211217

File Name: /u01/rman_srv4/standbycontrol_RAC_1r0gvcn6_1_1.ctl

File Name: /u01/rman_srv4/Backup_RAC_DB_0q0go0bc_26_1_20211214

File Name: /u01/rman_srv4/control_RAC_20211217.bak

File Name: /u01/rman_srv4/Backup_RAC_DB_0p0go0bc_25_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_0o0go0bc_24_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1p0gvcmb_57_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1g0gvcjq_48_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_130go0en_35_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1d0gvcif_45_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_140go0en_36_1_20211214

File Name: /u01/rman_srv4/Backup_RAC_DB_1j0gvck2_51_1_20211217

File Name: /u01/rman_srv4/Backup_RAC_DB_1n0gvcl7_55_1_20211217

• Restore database 

RMAN> restore database;

Starting restore at 29-DEC-2021 15:31:05

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=549 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undo_2.319.1091217683

channel ORA_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/RACDR/D0706A7D1C5F1532E0534738A8C0B3F6/datafile/o1_mf_soetbs_jvk2n7gk_.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1k0gvck4_52_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1k0gvck4_52_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1k0gvck4_52_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:46

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/racdr/datafile/system.257.1088276431

channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/racdr/datafile/undotbs1.259.1088276501

channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/racdr/datafile/users.260.1088276503

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1l0gvck4_53_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1l0gvck4_53_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1l0gvck4_53_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/racdr/datafile/sysaux.258.1088276477

channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/racdr/datafile/undotbs2.272.1088276835

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1m0gvcl7_54_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1m0gvcl7_54_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1m0gvcl7_54_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/system.280.1088277275

channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/sysaux.281.1088277275

channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undotbs1.279.1088277275

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1n0gvcl7_55_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1n0gvcl7_55_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1n0gvcl7_55_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/system.269.1088276619

channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/undotbs1.270.1088276619

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1p0gvcmb_57_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1p0gvcmb_57_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1p0gvcmb_57_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/sysaux.268.1088276619

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1o0gvcma_56_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1o0gvcma_56_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1o0gvcma_56_1_20211217 tag=TAG20211217T154259

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

Finished restore at 29-DEC-2021 15:33:37

• Recover database 

RMAN> recover database;

Starting recover at 29-DEC-2021 15:33:56

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:00

channel ORA_DISK_1: starting archived log restore to default destination

channel ORA_DISK_1: restoring archived log

archived log thread=1 sequence=89

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/rmanbkp/Backup_RAC_DB_1h0gvck1_49_1_20211217

channel ORA_DISK_1: errors found reading piece handle=/u01/app/oracle/rmanbkp/Backup_RAC_DB_1h0gvck1_49_1_20211217

channel ORA_DISK_1: failover to piece handle=/u01/rman_srv4/Backup_RAC_DB_1h0gvck1_49_1_20211217 tag=TAG20211217T154207

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

channel default: deleting archived log(s)

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/o1_mf_1_89_jwrdngkf_.arc RECID=131 STAMP=1092584039

media recovery complete, elapsed time: 00:00:00

Finished recover at 29-DEC-2021 15:34:01

RMAN>

• Recover further archivelog. Copied from DR and recovery of archivelog to new hosts

[root@oem sf_software_26_sept_2021]# cp *.arc /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29

[oracle@oem 2021_12_29]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Wed Dec 29 16:08:23 2021

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

connected to target database: RAC (DBID=2676258589, not open)

RMAN> recover database;

Starting recover at 29-DEC-2021 16:08:29

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

starting media recovery

archived log for thread 1 with sequence 89 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_89_1088276576.arc

archived log for thread 1 with sequence 90 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_90_1088276576.arc

archived log for thread 1 with sequence 91 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_91_1088276576.arc

archived log for thread 1 with sequence 92 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_92_1088276576.arc

archived log for thread 2 with sequence 69 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_69_1088276576.arc

archived log for thread 2 with sequence 70 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_70_1088276576.arc

archived log for thread 2 with sequence 71 is already on disk as file /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_71_1088276576.arc

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_69_1088276576.arc thread=2 sequence=69

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_89_1088276576.arc thread=1 sequence=89

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_90_1088276576.arc thread=1 sequence=90

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_91_1088276576.arc thread=1 sequence=91

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_70_1088276576.arc thread=2 sequence=70

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_1_92_1088276576.arc thread=1 sequence=92

archived log file name=/u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/arch_2_71_1088276576.arc thread=2 sequence=71

media recovery complete, elapsed time: 00:00:03

Finished recover at 29-DEC-2021 16:08:33

RMAN>

• We have done restoration using rman backup from physical standby database so we are unable to open database in resetlog options. 

RMAN> alter database open resetlog;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of sql statement command at 12/29/2021 16:08:55

ORA-02288: invalid OPEN mode

RMAN> exit

• First Failover from physical standby database to primary database to current new host database   (But during conversion we find standby redo logfile not created on redo logfile location we cleared it first and add new redo logfile  then perform failover ).  

Recovery Manager complete.

[oracle@oem 2021_12_29]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 29 16:37:57 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       MOUNTED

         3 RACPDB                         MOUNTED

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

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

RAC       MOUNTED              PHYSICAL STANDBY

SQL> select name from v$datafile;

NAME

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

/u01/app/oracle/oradata/racdr/datafile/system.257.1088276431

/u01/app/oracle/oradata/racdr/datafile/sysaux.258.1088276477

/u01/app/oracle/oradata/racdr/datafile/undotbs1.259.1088276501

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/system.2

69.1088276619

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/sysaux.2

68.1088276619

/u01/app/oracle/oradata/racdr/datafile/users.260.1088276503

/u01/app/oracle/oradata/racdr/4700a987085b3dfae05387e5e50a8c7b/datafile/undotbs1

NAME

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

.270.1088276619

/u01/app/oracle/oradata/racdr/datafile/undotbs2.272.1088276835

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/system.2

80.1088277275

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/sysaux.2

81.1088277275

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undotbs1

.279.1088277275

NAME

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

/u01/app/oracle/oradata/racdr/d0706a7d1c5f1532e0534738a8c0b3f6/datafile/undo_2.3

19.1091217683

/u01/app/oracle/oradata/RACDR/D0706A7D1C5F1532E0534738A8C0B3F6/datafile/o1_mf_so

etbs_jvk2n7gk_.dbf

13 rows selected.

SQL> select name from v$tempfile;

NAME

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

/u01/app/oracle/oradata/racdr/tempfile/temp.267.1088276611

+DATA/RAC/D07045B084567D8BE0534738A8C057CB/TEMPFILE/temp.271.1088276639

SQL> select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/racdr/onlinelog/group_2.264.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_2.266.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_1.263.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_1.265.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_3.273.1088277009

/u01/app/oracle/oradata/racdr/onlinelog/group_3.274.1088277017

/u01/app/oracle/oradata/racdr/onlinelog/group_4.275.1088277023

/u01/app/oracle/oradata/racdr/onlinelog/group_4.276.1088277033

/u01/app/oracle/oradata/racdr/onlinelog/redo05.log

/u01/app/oracle/oradata/racdr/onlinelog/redo06.log

/u01/app/oracle/oradata/racdr/onlinelog/redo07.log

11 rows selected.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

NOT ALLOWED

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

*

ERROR at line 1:

ORA-16136: Managed Standby Recovery not active

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

*

ERROR at line 1:

ORA-16139: media recovery required

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-00313: open failed for members of log group 5 of thread 1

ORA-00312: online log 5 thread 1:

'/u01/app/oracle/oradata/racdr/onlinelog/redo05.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

SQL> select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/racdr/onlinelog/group_2.264.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_2.266.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_1.263.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_1.265.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_3.273.1088277009

/u01/app/oracle/oradata/racdr/onlinelog/group_3.274.1088277017

/u01/app/oracle/oradata/racdr/onlinelog/group_4.275.1088277023

/u01/app/oracle/oradata/racdr/onlinelog/group_4.276.1088277033

/u01/app/oracle/oradata/racdr/onlinelog/redo05.log

/u01/app/oracle/oradata/racdr/onlinelog/redo06.log

/u01/app/oracle/oradata/racdr/onlinelog/redo07.log

11 rows selected.

SQL> select bytes from v$log;

     BYTES

----------

 209715200

 209715200

 209715200

 209715200

SQL> select GROUP#,THREAD#,STATUS from v$log;

    GROUP#    THREAD# STATUS

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

         1          1 UNUSED

         2          1 UNUSED

         3          2 UNUSED

         4          2 UNUSED

SQL> alter database add logfile group 5 ('/u01/app/oracle/oradata/racdr/onlinelog/redo05.log') size 200m;

alter database add logfile group 5 ('/u01/app/oracle/oradata/racdr/onlinelog/redo05.log') size 200m

*

ERROR at line 1:

ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is

automatic.

SQL> sho parameter ORA-01275: Operation ADD LOGFILE is not allowed if standby file management is

automatic.

SQL> SP2-0042: unknown command "automatic." - rest of line ignored.

SQL>  sho parameter standby

NAME                                 TYPE        VALUE

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

enabled_PDBs_on_standby              string      *

standby_archive_dest                 string      ?#/dbs/arch

standby_db_preserve_states           string      NONE

standby_file_management              string      AUTO

SQL> alter system set standby_file_management='MANUAL';

System altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 8 '/u01/app/oracle/oradata/racdr/onlinelog/redo08.log' size 200m;

Database altered.

SQL> ALTER DATABASE ADD STANDBY LOGFILE group 9 '/u01/app/oracle/oradata/racdr/onlinelog/redo09.log' size 200m;

Database altered.

SQL>  ALTER DATABASE ADD STANDBY LOGFILE group 10 '/u01/app/oracle/oradata/racdr/onlinelog/redo10.log' size 200m;

Database altered.

SQL> select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/racdr/onlinelog/group_2.264.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_2.266.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_1.263.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_1.265.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_3.273.1088277009

/u01/app/oracle/oradata/racdr/onlinelog/group_3.274.1088277017

/u01/app/oracle/oradata/racdr/onlinelog/group_4.275.1088277023

/u01/app/oracle/oradata/racdr/onlinelog/group_4.276.1088277033

/u01/app/oracle/oradata/racdr/onlinelog/redo05.log

/u01/app/oracle/oradata/racdr/onlinelog/redo06.log

/u01/app/oracle/oradata/racdr/onlinelog/redo07.log

MEMBER

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

/u01/app/oracle/oradata/racdr/onlinelog/redo08.log

/u01/app/oracle/oradata/racdr/onlinelog/redo09.log

/u01/app/oracle/oradata/racdr/onlinelog/redo10.log

14 rows selected.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-00313: open failed for members of log group 6 of thread 2

ORA-00312: online log 6 thread 2:

'/u01/app/oracle/oradata/racdr/onlinelog/redo06.log'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 7

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 6;

Database altered.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 7;

Database altered.

SQL> alter database drop logfile group 5;

Database altered.

SQL> alter database drop logfile group 6;

Database altered.

SQL> alter database drop logfile group 7;

Database altered.

SQL> select member from v$logfile;

MEMBER

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

/u01/app/oracle/oradata/racdr/onlinelog/group_2.264.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_2.266.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_1.263.1088276577

/u01/app/oracle/oradata/racdr/onlinelog/group_1.265.1088276589

/u01/app/oracle/oradata/racdr/onlinelog/group_3.273.1088277009

/u01/app/oracle/oradata/racdr/onlinelog/group_3.274.1088277017

/u01/app/oracle/oradata/racdr/onlinelog/group_4.275.1088277023

/u01/app/oracle/oradata/racdr/onlinelog/group_4.276.1088277033

/u01/app/oracle/oradata/racdr/onlinelog/redo08.log

/u01/app/oracle/oradata/racdr/onlinelog/redo09.log

/u01/app/oracle/oradata/racdr/onlinelog/redo10.log

11 rows selected.

• Perform failover after clearing old redolog and adding new redolog file. 8,9,10 and we drop 7,8,9  redolog later. 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

Database altered.

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;

Database altered.

SQL> select name,open_mode ,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

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

RAC       MOUNTED              PRIMARY

• Open database in read write mode 

SQL> alter database open;

Database altered.

SQL> select name,open_mode ,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE

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

RAC       READ WRITE           PRIMARY

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 RACPDB                         MOUNTED

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 RACPDB                         READ WRITE NO

SQL>

• New host redo logfile location 

[root@oem onlinelog]# pwd

/u01/app/oracle/oradata/racdr/onlinelog

[root@oem onlinelog]# ll

total 2662472

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:54 group_1.263.1088276577

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:54 group_1.265.1088276589

-rw-r----- 1 oracle oinstall 209715712 Dec 29 18:04 group_2.264.1088276577

-rw-r----- 1 oracle oinstall 209715712 Dec 29 18:04 group_2.266.1088276589

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:54 group_3.273.1088277009

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:54 group_3.274.1088277017

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:55 group_4.275.1088277023

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:55 group_4.276.1088277033

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:52 redo06.log

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:53 redo07.log

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:34 redo08.log

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:35 redo09.log

-rw-r----- 1 oracle oinstall 209715712 Dec 29 17:35 redo10.log

[root@oem onlinelog]#

SQL> alter system set standby_file_management='AUTO';

System altered.

SQL> sho parameter standby

NAME                                 TYPE        VALUE

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

enabled_PDBs_on_standby              string      *

standby_archive_dest                 string      ?#/dbs/arch

standby_db_preserve_states           string      NONE

standby_file_management              string      AUTO

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL>

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME     CON_ID

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

         1          1          5  209715200        512          2 NO  CURRENT                4648936 29-DEC-21   1.8447E+19                    0

         2          1          4  209715200        512          2 YES INACTIVE               4648932 29-DEC-21      4648936 29-DEC-21          0

         3          2          1  209715200        512          2 YES INACTIVE               4647695 29-DEC-21      4647698 29-DEC-21          0

         4          2          2  209715200        512          2 YES INACTIVE               4647698 29-DEC-21      4647844 29-DEC-21          0

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                                                 IS_     CON_ID

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

         2         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_2.264.1088276577         NO           0

         2         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_2.266.1088276589         NO           0

         1         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_1.263.1088276577         NO           0

         1         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_1.265.1088276589         NO           0

         3         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_3.273.1088277009         NO           0

         3         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_3.274.1088277017         NO           0

         4         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_4.275.1088277023         NO           0

         4         ONLINE  /u01/app/oracle/oradata/racdr/onlinelog/group_4.276.1088277033         NO           0

         5         STANDBY /u01/app/oracle/fast_recovery_area/RAC/archivelog/2021_12_29/o1_mf_2_0 YES          0

                           _jwrnvch0_.arc

9 rows selected.

SQL>

• Check and disable the closed state thread#2  and clear unarchived logfile 3 and 4 

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED

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

         1 OPEN   PUBLIC

         2 CLOSED PUBLIC

SQL>  select group# from v$log where THREAD#=2;

    GROUP#

----------

         3

         4

SQL> alter database disable thread 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL>  alter database clear unarchived logfile group 4;

Database altered.

SQL>  select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED

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

         1 OPEN   PUBLIC

         2 CLOSED DISABLED

SQL> sho parameter undo;

NAME                                 TYPE        VALUE

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

temp_undo_enabled                    boolean     FALSE

undo_management                      string      AUTO

undo_retention                       integer     900

undo_tablespace                      string      UNDOTBS1

• Remove undo tablespace UNDOTBS2

SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME

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

UNDOTBS1

UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

• Drop temporary tablespace and add new temporary tablespace temp1 and make as default tablespace 

SQL> select name from v$tempfile;

NAME

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

/u01/app/oracle/oradata/racdr/tempfile/temp.267.1088276611

+DATA/RAC/D07045B084567D8BE0534738A8C057CB/TEMPFILE/temp.271.1088276639

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME

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

TEMP

SQL> create temporary tablespace TEMP1 tempfile '/u01/app/oracle/oradata/racdr/tempfile/temp001.dbf' size 50m;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL> drop tablespace TEMP including contents and datafiles;

Tablespace dropped.

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME

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

TEMP1

SQL>

NOTE : --- increase pga_target , sga , temp file , undo file if required, match with production requirement.

RMAN - Full Backup on asm disk group and script to copy backup from asm disk group to local disk

RMAN - Full Backup on asm disk group  and script to copy  backup from asm disk group to local disk

• Login asmcmd console and create directory fro backup on shared storage 
• Add controlfile snapshot location on ASM disk group.
• Create full rman backup script mentioning asm backup location and Connect rman or shedule script in corntab for backup 
• Check backup status on disks
• Script to copy rman backup to local disk from asm diskgroup 

• Login and create backup directory on asm disk group 

 grid@srv1:/home/oracle> . oraenv

ORACLE_SID = [rac1] ? +ASM1

The Oracle base has been changed from /u01/app/oracle to /u01/app/grid

grid@srv1:/home/oracle> asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512   4096  1048576     24573    20095                0           20095              0             Y  CRS/

MOUNTED  EXTERN  N         512   4096  1048576     15359    13098                0           13098              0             N  DATA/

MOUNTED  EXTERN  N         512   4096  1048576     15359    14617                0           14617              0             N  FRA/

ASMCMD> mkdir rmanbkp

ASMCMD> pwd

+FRA/rmanbkp

ASMCMD> mkdir rmnan_snapshot

ASMCMD> ls

RAC/

rmanbkp/

rmnan_snapshot/

ASMCMD> rm -f rmnan_snapshot/

ASMCMD> mkdir rman_snapshot

ASMCMD> ls

RAC/

rman_snapshot/

rmanbkp/

ASMCMD> cd rman_snapshot/

ASMCMD> pwd

+FRA/rman_snapshot

ASMCMD> ls

snapcf_rac1.f

• Add controlfile snapshot location on ASM disk group.

oracle@srv1:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Dec 8 13:38:11 2021

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

connected to target database: RAC (DBID=2666656136)

RMAN> show all ;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name RAC are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/snapcf_rac1.f'; # default

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

new RMAN configuration parameters are successfully stored

RMAN>  show all;

RMAN configuration parameters for database with db_unique_name RAC are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/rman_snapshot/snapcf_rac1.f';

RMAN>

• Add backup location on full rman backup script

run

{

allocate channel c1 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c3 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

#backup full database format '+FRA/rmanbkp/%d_%U.bckp' plus archivelog;

copy current controlfile to '+FRA/rmanbkp/control_%d_%T.bak';

backup current controlfile for standby format '+FRA/rmanbkp/standbycontrol_%d_%U.ctl';

release channel c1;

release channel c2;

release channel c3;

}

• Login into rman console and run rman backup command 

RMAN> run

{

allocate channel c1 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c2 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

allocate channel c3 device type disk format '+FRA/rmanbkp/Backup_%d_DB_%u_%s_%p_%T';

crosscheck backup;

crosscheck archivelog all;

report obsolete;

delete noprompt obsolete;

sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

#backup full database format '+FRA/rmanbkp/%d_%U.bckp' plus archivelog;

copy current controlfile to '+FRA/rmanbkp/control_%d_%T.bak';

backup current controlfile for standby format '+FRA/rmanbkp/standbycontrol_%d_%U.ctl';

release channel c1;

release channel c2;

release channel c3;

}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>

allocated channel: c1

channel c1: SID=55 instance=rac1 device type=DISK

allocated channel: c2

channel c2: SID=72 instance=rac1 device type=DISK

allocated channel: c3

channel c3: SID=1 instance=rac1 device type=DISK

specification does not match any backup in the repository

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_1_seq_7.262.1078674321 RECID=2 STAMP=1078674321

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_1_seq_8.263.1078674333 RECID=3 STAMP=1078674333

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_1_seq_9.264.1078675051 RECID=4 STAMP=1078675051

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_1_seq_10.265.1078675053 RECID=5 STAMP=1078675052

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_1_seq_11.268.1078688249 RECID=8 STAMP=1078688248

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_26/thread_1_seq_12.269.1078917195 RECID=9 STAMP=1078917194

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_26/thread_1_seq_13.270.1078917195 RECID=10 STAMP=1078917194

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_26/thread_1_seq_14.271.1078917197 RECID=11 STAMP=1078917196

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_15.273.1079090839 RECID=13 STAMP=1079090839

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_16.274.1079095565 RECID=14 STAMP=1079095565

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_17.277.1079110283 RECID=17 STAMP=1079110284

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_18.278.1079110285 RECID=18 STAMP=1079110284

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_19.279.1079110287 RECID=19 STAMP=1079110286

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_20.280.1079112333 RECID=20 STAMP=1079112333

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_21.281.1079112335 RECID=21 STAMP=1079112334

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_22.283.1079113853 RECID=23 STAMP=1079113852

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_23.284.1079113853 RECID=24 STAMP=1079113853

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_1_seq_24.288.1079116217 RECID=28 STAMP=1079116216

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_25.289.1082547331 RECID=29 STAMP=1082547331

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_26.292.1082550533 RECID=32 STAMP=1082550533

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_27.295.1082550703 RECID=35 STAMP=1082550703

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_28.297.1082551223 RECID=37 STAMP=1082551222

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_29.299.1082566131 RECID=39 STAMP=1082566130

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_1_seq_30.300.1082566131 RECID=40 STAMP=1082566131

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_14/thread_1_seq_31.305.1083238257 RECID=45 STAMP=1083238257

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_32.306.1083413523 RECID=46 STAMP=1083413523

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_33.309.1083416351 RECID=49 STAMP=1083416351

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_34.310.1083416351 RECID=50 STAMP=1083416351

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_35.311.1083417811 RECID=51 STAMP=1083417811

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_36.312.1083417813 RECID=52 STAMP=1083417812

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_1_seq_37.314.1083418143 RECID=54 STAMP=1083418143

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_38.315.1083503419 RECID=55 STAMP=1083503419

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_39.320.1083503425 RECID=60 STAMP=1083503424

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_40.321.1083505803 RECID=61 STAMP=1083505803

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_41.322.1083506295 RECID=62 STAMP=1083506295

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_42.323.1083506455 RECID=63 STAMP=1083506454

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_43.328.1083506461 RECID=68 STAMP=1083506460

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_44.329.1083506577 RECID=69 STAMP=1083506576

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_1_seq_45.330.1083506577 RECID=70 STAMP=1083506577

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_22/thread_1_seq_46.332.1083940403 RECID=72 STAMP=1083940402

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_22/thread_1_seq_47.334.1083940403 RECID=74 STAMP=1083940404

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_1_seq_48.339.1084386101 RECID=79 STAMP=1084386101

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_1_seq_49.340.1084386121 RECID=80 STAMP=1084386121

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_07/thread_1_seq_50.341.1085330155 RECID=81 STAMP=1085330155

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_07/thread_1_seq_51.342.1085330181 RECID=82 STAMP=1085330180

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_08/thread_1_seq_52.343.1085404173 RECID=83 STAMP=1085404173

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_08/thread_1_seq_53.344.1085413929 RECID=84 STAMP=1085413929

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_1_seq_54.347.1086529789 RECID=87 STAMP=1086529790

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_1_seq_55.348.1086529791 RECID=88 STAMP=1086529790

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_1_seq_56.353.1086529815 RECID=93 STAMP=1086529815

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_1_seq_57.354.1086529835 RECID=94 STAMP=1086529835

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_28/thread_1_seq_58.355.1087135159 RECID=95 STAMP=1087135158

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_10/thread_1_seq_59.356.1088276599 RECID=96 STAMP=1088276598

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_10/thread_1_seq_60.357.1088279215 RECID=97 STAMP=1088279215

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_61.358.1089204019 RECID=98 STAMP=1089204018

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_62.359.1089204019 RECID=99 STAMP=1089204019

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_63.360.1089204021 RECID=100 STAMP=1089204020

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_64.361.1089204021 RECID=101 STAMP=1089204020

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_65.363.1089220877 RECID=103 STAMP=1089220878

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_66.365.1089220879 RECID=105 STAMP=1089220878

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_1_seq_67.367.1089228519 RECID=107 STAMP=1089228519

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_12_08/thread_1_seq_68.369.1090757115 RECID=108 STAMP=1090757115

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_2_seq_1.261.1078674311 RECID=1 STAMP=1078674310

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_2_seq_2.266.1078676779 RECID=6 STAMP=1078676779

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_23/thread_2_seq_3.267.1078676781 RECID=7 STAMP=1078676780

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_4.272.1079090839 RECID=12 STAMP=1079090838

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_5.275.1079095569 RECID=15 STAMP=1079095568

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_6.276.1079095569 RECID=16 STAMP=1079095568

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_7.282.1079112335 RECID=22 STAMP=1079112334

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_8.285.1079113855 RECID=25 STAMP=1079113855

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_9.286.1079115391 RECID=26 STAMP=1079115390

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_07_28/thread_2_seq_10.287.1079115391 RECID=27 STAMP=1079115391

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_11.290.1082547335 RECID=30 STAMP=1082547334

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_12.291.1082547335 RECID=31 STAMP=1082547334

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_13.293.1082550701 RECID=33 STAMP=1082550702

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_14.294.1082550703 RECID=34 STAMP=1082550702

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_15.296.1082551221 RECID=36 STAMP=1082551221

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_06/thread_2_seq_16.298.1082551223 RECID=38 STAMP=1082551222

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_14/thread_2_seq_17.301.1083238249 RECID=41 STAMP=1083238249

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_14/thread_2_seq_18.302.1083238249 RECID=42 STAMP=1083238249

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_14/thread_2_seq_19.303.1083238255 RECID=43 STAMP=1083238254

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_14/thread_2_seq_20.304.1083238255 RECID=44 STAMP=1083238255

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_2_seq_21.307.1083413525 RECID=47 STAMP=1083413525

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_2_seq_22.308.1083413525 RECID=48 STAMP=1083413525

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_16/thread_2_seq_23.313.1083417813 RECID=53 STAMP=1083417813

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_24.316.1083503419 RECID=56 STAMP=1083503419

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_25.317.1083503419 RECID=57 STAMP=1083503419

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_26.318.1083503421 RECID=58 STAMP=1083503421

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_27.319.1083503421 RECID=59 STAMP=1083503421

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_28.324.1083506455 RECID=64 STAMP=1083506455

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_29.325.1083506455 RECID=65 STAMP=1083506455

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_30.326.1083506457 RECID=66 STAMP=1083506457

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_17/thread_2_seq_31.327.1083506457 RECID=67 STAMP=1083506457

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_22/thread_2_seq_32.331.1083939803 RECID=71 STAMP=1083939803

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_22/thread_2_seq_33.333.1083940403 RECID=73 STAMP=1083940403

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_2_seq_34.335.1084386097 RECID=75 STAMP=1084386096

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_2_seq_35.336.1084386097 RECID=76 STAMP=1084386096

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_2_seq_36.337.1084386099 RECID=77 STAMP=1084386098

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_09_27/thread_2_seq_37.338.1084386099 RECID=78 STAMP=1084386099

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_08/thread_2_seq_38.345.1085413931 RECID=85 STAMP=1085413931

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_08/thread_2_seq_39.346.1085413931 RECID=86 STAMP=1085413931

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_2_seq_40.349.1086529791 RECID=89 STAMP=1086529790

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_2_seq_41.350.1086529791 RECID=90 STAMP=1086529790

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_2_seq_42.351.1086529793 RECID=91 STAMP=1086529793

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_10_21/thread_2_seq_43.352.1086529793 RECID=92 STAMP=1086529793

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_2_seq_44.362.1089204023 RECID=102 STAMP=1089204022

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_2_seq_45.364.1089220879 RECID=104 STAMP=1089220878

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_11_21/thread_2_seq_46.366.1089225091 RECID=106 STAMP=1089225092

validation succeeded for archived log

archived log file name=+FRA/RAC/ARCHIVELOG/2021_12_08/thread_2_seq_47.368.1090757115 RECID=109 STAMP=1090757115

Crosschecked 109 objects

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

no obsolete backups found

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

no obsolete backups found

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

Starting backup at 08-DEC-21

current log archived

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=7 RECID=2 STAMP=1078674321

input archived log thread=2 sequence=1 RECID=1 STAMP=1078674310

input archived log thread=1 sequence=8 RECID=3 STAMP=1078674333

input archived log thread=1 sequence=9 RECID=4 STAMP=1078675051

input archived log thread=2 sequence=2 RECID=6 STAMP=1078676779

input archived log thread=1 sequence=10 RECID=5 STAMP=1078675052

input archived log thread=1 sequence=11 RECID=8 STAMP=1078688248

input archived log thread=2 sequence=3 RECID=7 STAMP=1078676780

input archived log thread=1 sequence=12 RECID=9 STAMP=1078917194

input archived log thread=1 sequence=13 RECID=10 STAMP=1078917194

input archived log thread=2 sequence=4 RECID=12 STAMP=1079090838

input archived log thread=1 sequence=14 RECID=11 STAMP=1078917196

input archived log thread=1 sequence=15 RECID=13 STAMP=1079090839

input archived log thread=1 sequence=16 RECID=14 STAMP=1079095565

input archived log thread=2 sequence=5 RECID=15 STAMP=1079095568

input archived log thread=2 sequence=6 RECID=16 STAMP=1079095568

input archived log thread=1 sequence=17 RECID=17 STAMP=1079110284

input archived log thread=1 sequence=18 RECID=18 STAMP=1079110284

input archived log thread=2 sequence=7 RECID=22 STAMP=1079112334

input archived log thread=1 sequence=19 RECID=19 STAMP=1079110286

input archived log thread=1 sequence=20 RECID=20 STAMP=1079112333

input archived log thread=1 sequence=21 RECID=21 STAMP=1079112334

input archived log thread=2 sequence=8 RECID=25 STAMP=1079113855

input archived log thread=1 sequence=22 RECID=23 STAMP=1079113852

input archived log thread=1 sequence=23 RECID=24 STAMP=1079113853

input archived log thread=2 sequence=9 RECID=26 STAMP=1079115390

input archived log thread=1 sequence=24 RECID=28 STAMP=1079116216

channel c1: starting piece 1 at 08-DEC-21

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=2 sequence=10 RECID=27 STAMP=1079115391

input archived log thread=2 sequence=11 RECID=30 STAMP=1082547334

input archived log thread=1 sequence=25 RECID=29 STAMP=1082547331

input archived log thread=2 sequence=12 RECID=31 STAMP=1082547334

input archived log thread=1 sequence=26 RECID=32 STAMP=1082550533

input archived log thread=1 sequence=27 RECID=35 STAMP=1082550703

input archived log thread=2 sequence=13 RECID=33 STAMP=1082550702

input archived log thread=2 sequence=14 RECID=34 STAMP=1082550702

input archived log thread=1 sequence=28 RECID=37 STAMP=1082551222

input archived log thread=2 sequence=15 RECID=36 STAMP=1082551221

input archived log thread=2 sequence=16 RECID=38 STAMP=1082551222

input archived log thread=1 sequence=29 RECID=39 STAMP=1082566130

input archived log thread=2 sequence=17 RECID=41 STAMP=1083238249

input archived log thread=1 sequence=30 RECID=40 STAMP=1082566131

input archived log thread=2 sequence=18 RECID=42 STAMP=1083238249

input archived log thread=1 sequence=31 RECID=45 STAMP=1083238257

input archived log thread=2 sequence=19 RECID=43 STAMP=1083238254

input archived log thread=2 sequence=20 RECID=44 STAMP=1083238255

input archived log thread=1 sequence=32 RECID=46 STAMP=1083413523

input archived log thread=2 sequence=21 RECID=47 STAMP=1083413525

input archived log thread=2 sequence=22 RECID=48 STAMP=1083413525

input archived log thread=1 sequence=33 RECID=49 STAMP=1083416351

input archived log thread=2 sequence=23 RECID=53 STAMP=1083417813

input archived log thread=1 sequence=34 RECID=50 STAMP=1083416351

input archived log thread=1 sequence=35 RECID=51 STAMP=1083417811

input archived log thread=1 sequence=36 RECID=52 STAMP=1083417812

input archived log thread=2 sequence=24 RECID=56 STAMP=1083503419

input archived log thread=1 sequence=37 RECID=54 STAMP=1083418143

input archived log thread=1 sequence=38 RECID=55 STAMP=1083503419

input archived log thread=2 sequence=25 RECID=57 STAMP=1083503419

input archived log thread=1 sequence=39 RECID=60 STAMP=1083503424

input archived log thread=2 sequence=26 RECID=58 STAMP=1083503421

input archived log thread=2 sequence=27 RECID=59 STAMP=1083503421

input archived log thread=1 sequence=40 RECID=61 STAMP=1083505803

input archived log thread=1 sequence=41 RECID=62 STAMP=1083506295

input archived log thread=2 sequence=28 RECID=64 STAMP=1083506455

input archived log thread=1 sequence=42 RECID=63 STAMP=1083506454

input archived log thread=2 sequence=29 RECID=65 STAMP=1083506455

channel c2: starting piece 1 at 08-DEC-21

channel c3: starting compressed archived log backup set

channel c3: specifying archived log(s) in backup set

input archived log thread=1 sequence=43 RECID=68 STAMP=1083506460

input archived log thread=2 sequence=30 RECID=66 STAMP=1083506457

input archived log thread=2 sequence=31 RECID=67 STAMP=1083506457

input archived log thread=1 sequence=44 RECID=69 STAMP=1083506576

input archived log thread=2 sequence=32 RECID=71 STAMP=1083939803

input archived log thread=1 sequence=45 RECID=70 STAMP=1083506577

input archived log thread=2 sequence=33 RECID=73 STAMP=1083940403

input archived log thread=1 sequence=46 RECID=72 STAMP=1083940402

input archived log thread=1 sequence=47 RECID=74 STAMP=1083940404

input archived log thread=2 sequence=34 RECID=75 STAMP=1084386096

input archived log thread=2 sequence=35 RECID=76 STAMP=1084386096

input archived log thread=1 sequence=48 RECID=79 STAMP=1084386101

input archived log thread=2 sequence=36 RECID=77 STAMP=1084386098

input archived log thread=2 sequence=37 RECID=78 STAMP=1084386099

input archived log thread=1 sequence=49 RECID=80 STAMP=1084386121

input archived log thread=1 sequence=50 RECID=81 STAMP=1085330155

input archived log thread=1 sequence=51 RECID=82 STAMP=1085330180

input archived log thread=1 sequence=52 RECID=83 STAMP=1085404173

input archived log thread=1 sequence=53 RECID=84 STAMP=1085413929

input archived log thread=2 sequence=38 RECID=85 STAMP=1085413931

input archived log thread=2 sequence=39 RECID=86 STAMP=1085413931

input archived log thread=1 sequence=54 RECID=87 STAMP=1086529790

input archived log thread=2 sequence=40 RECID=89 STAMP=1086529790

input archived log thread=1 sequence=55 RECID=88 STAMP=1086529790

input archived log thread=2 sequence=41 RECID=90 STAMP=1086529790

input archived log thread=1 sequence=56 RECID=93 STAMP=1086529815

input archived log thread=2 sequence=42 RECID=91 STAMP=1086529793

input archived log thread=2 sequence=43 RECID=92 STAMP=1086529793

input archived log thread=1 sequence=57 RECID=94 STAMP=1086529835

input archived log thread=1 sequence=58 RECID=95 STAMP=1087135158

input archived log thread=1 sequence=59 RECID=96 STAMP=1088276598

input archived log thread=1 sequence=60 RECID=97 STAMP=1088279215

input archived log thread=1 sequence=61 RECID=98 STAMP=1089204018

input archived log thread=1 sequence=62 RECID=99 STAMP=1089204019

input archived log thread=2 sequence=44 RECID=102 STAMP=1089204022

input archived log thread=1 sequence=63 RECID=100 STAMP=1089204020

input archived log thread=1 sequence=64 RECID=101 STAMP=1089204020

input archived log thread=2 sequence=45 RECID=104 STAMP=1089220878

channel c3: starting piece 1 at 08-DEC-21

channel c1: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_010g7e6d_1_1_20211208 tag=TAG20211208T134236 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:08

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=65 RECID=103 STAMP=1089220878

input archived log thread=1 sequence=66 RECID=105 STAMP=1089220878

input archived log thread=2 sequence=46 RECID=106 STAMP=1089225092

input archived log thread=2 sequence=47 RECID=109 STAMP=1090757115

input archived log thread=1 sequence=67 RECID=107 STAMP=1089228519

input archived log thread=1 sequence=68 RECID=108 STAMP=1090757115

input archived log thread=2 sequence=48 RECID=111 STAMP=1090762950

input archived log thread=1 sequence=69 RECID=110 STAMP=1090762949

input archived log thread=1 sequence=70 RECID=112 STAMP=1090762956

input archived log thread=2 sequence=49 RECID=113 STAMP=1090762956

channel c1: starting piece 1 at 08-DEC-21

channel c2: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_020g7e6d_2_1_20211208 tag=TAG20211208T134236 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:07

channel c3: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_030g7e6e_3_1_20211208 tag=TAG20211208T134236 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:07

channel c1: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_040g7e6l_4_1_20211208 tag=TAG20211208T134236 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:03

Finished backup at 08-DEC-21

Starting backup at 08-DEC-21

channel c1: starting compressed full datafile backup set

channel c1: specifying datafile(s) in backup set

input datafile file number=00001 name=+DATA/RAC/DATAFILE/system.258.1078674039

channel c1: starting piece 1 at 08-DEC-21

channel c2: starting compressed full datafile backup set

channel c2: specifying datafile(s) in backup set

input datafile file number=00003 name=+DATA/RAC/DATAFILE/sysaux.257.1078674013

input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1078674073

channel c2: starting piece 1 at 08-DEC-21

channel c3: starting compressed full datafile backup set

channel c3: specifying datafile(s) in backup set

input datafile file number=00004 name=+DATA/RAC/DATAFILE/undotbs1.260.1078674075

input datafile file number=00005 name=+DATA/RAC/DATAFILE/undotbs2.265.1078674231

channel c3: starting piece 1 at 08-DEC-21

channel c3: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_070g7e6p_7_1_20211208 tag=TAG20211208T134249 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:01

channel c3: starting compressed full datafile backup set

channel c3: specifying datafile(s) in backup set

including current control file in backup set

channel c3: starting piece 1 at 08-DEC-21

channel c3: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_080g7e6q_8_1_20211208 tag=TAG20211208T134249 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:01

channel c3: starting compressed full datafile backup set

channel c3: specifying datafile(s) in backup set

including current SPFILE in backup set

channel c3: starting piece 1 at 08-DEC-21

channel c3: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_090g7e6t_9_1_20211208 tag=TAG20211208T134249 comment=NONE

channel c3: backup set complete, elapsed time: 00:00:01

channel c1: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_050g7e6p_5_1_20211208 tag=TAG20211208T134249 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:29

channel c2: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_060g7e6p_6_1_20211208 tag=TAG20211208T134249 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:29

Finished backup at 08-DEC-21

Starting backup at 08-DEC-21

current log archived

channel c1: starting compressed archived log backup set

channel c1: specifying archived log(s) in backup set

input archived log thread=1 sequence=71 RECID=114 STAMP=1090762999

channel c1: starting piece 1 at 08-DEC-21

channel c2: starting compressed archived log backup set

channel c2: specifying archived log(s) in backup set

input archived log thread=2 sequence=50 RECID=115 STAMP=1090762999

channel c2: starting piece 1 at 08-DEC-21

channel c1: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_0a0g7e7p_10_1_20211208 tag=TAG20211208T134321 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

channel c2: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/backup_rac_db_0b0g7e7p_11_1_20211208 tag=TAG20211208T134321 comment=NONE

channel c2: backup set complete, elapsed time: 00:00:01

Finished backup at 08-DEC-21

Starting backup at 08-DEC-21

channel c1: starting datafile copy

copying current control file

output file name=+FRA/rmanbkp/control_rac_20211208.bak tag=TAG20211208T134323 RECID=1 STAMP=1090763004

channel c1: datafile copy complete, elapsed time: 00:00:01

Finished backup at 08-DEC-21

Starting backup at 08-DEC-21

channel c1: starting full datafile backup set

channel c1: specifying datafile(s) in backup set

including standby control file in backup set

channel c1: starting piece 1 at 08-DEC-21

channel c1: finished piece 1 at 08-DEC-21

piece handle=+FRA/rmanbkp/standbycontrol_rac_0d0g7e7t_1_1.ctl tag=TAG20211208T134325 comment=NONE

channel c1: backup set complete, elapsed time: 00:00:01

Finished backup at 08-DEC-21

released channel: c1

released channel: c2

released channel: c3

RMAN>

• Copy Rman backup form asm backup location to local disk  (schedule script using grid user)

grid@srv1:/u01/asm_rman_cp> cat asm_smrpodbrman_backup.sh

#!/bin/bash

#

# This script copies files from FRA on ASM to local disk

#

export ORACLE_SID=+ASM1

export ORACLE_HOME=/u01/app/12.1.0/grid  ##{Grid OH}

export PATH=$ORACLE_HOME/perl/bin:$PATH

ASMLS=/u01/asm_rman_cp/asm_rman.txt ##{ASM files list}

FRA=+FRA/rmanbkp ##{source location of files}

LOCALBACKUPDIR=/u01/asm_rman_cp  ##{destination filesystem}

LOG=/u01/asm_rman_cp/asm_grid_smrpod.txt ##{log file}

#

# Get the list of files

#

$ORACLE_HOME/bin/asmcmd > $ASMLS <<EOF

ls $FRA

exit

EOF

#

# Clean the list by removing "ASMCMD>"

#

sed -i 's/ASMCMD> //g' $ASMLS

##cat $ASMLS

echo `date` > $LOG

#

# Copy files one by one

#

for FILENAME in `cat $ASMLS`

do

if [[ ! -f $LOCALBACKUPDIR/${FILENAME} ]]

then

$ORACLE_HOME/bin/asmcmd >> $LOG <<EOF

cp $FRA/$FILENAME $LOCALBACKUPDIR

EOF

fi

done

echo `date` >> $LOG

• Check the rman backup files on local disk location 

grid@srv1:/u01/asm_rman_cp> ll

total 462760

-rw-r--r-- 1 grid oinstall      1988 Dec  8 14:19 asm_grid_smrpod.txt

-rw-r--r-- 1 grid oinstall       459 Dec  8 14:19 asm_rman.txt

-rwxrwxr-x 1 grid oinstall       841 Dec  8 14:19 asm_smrpodbrman_backup.sh

-rw-r----- 1 grid oinstall  40596992 Dec  8 14:19 backup_rac_db_010g7e6d_1_1_20211208

-rw-r----- 1 grid oinstall  25184768 Dec  8 14:19 backup_rac_db_020g7e6d_2_1_20211208

-rw-r----- 1 grid oinstall  19389952 Dec  8 14:19 backup_rac_db_030g7e6e_3_1_20211208

-rw-r----- 1 grid oinstall  13932032 Dec  8 14:19 backup_rac_db_040g7e6l_4_1_20211208

-rw-r----- 1 grid oinstall 214990848 Dec  8 14:19 backup_rac_db_050g7e6p_5_1_20211208

-rw-r----- 1 grid oinstall 118374400 Dec  8 14:19 backup_rac_db_060g7e6p_6_1_20211208

-rw-r----- 1 grid oinstall   1720320 Dec  8 14:19 backup_rac_db_070g7e6p_7_1_20211208

-rw-r----- 1 grid oinstall   1130496 Dec  8 14:19 backup_rac_db_080g7e6q_8_1_20211208

-rw-r----- 1 grid oinstall     98304 Dec  8 14:19 backup_rac_db_090g7e6t_9_1_20211208

-rw-r----- 1 grid oinstall      3584 Dec  8 14:19 backup_rac_db_0a0g7e7p_10_1_20211208

-rw-r----- 1 grid oinstall      3072 Dec  8 14:19 backup_rac_db_0b0g7e7p_11_1_20211208

-rw-r----- 1 grid oinstall  19185664 Dec  8 14:19 control_rac_20211208.bak

-rw-r----- 1 grid oinstall  19234816 Dec  8 14:19 standbycontrol_rac_0d0g7e7t_1_1.ctl

grid@srv1:/u01/asm_rman_cp>

RMAN : Restore old rman backup using PITR timestamp recovery

RMAN : Restore  rman backup using PITR timestamp recovery 

Scenario: Recently we got request from application team as there teamcenter plm app got corrupted  about revert database to particular time. As it was test development database for them and strictly told by them to not to take backup due to space crunch storage issue.  But luckily we took rman backup 15 days back for our own purpose  and we recover database to certain point of time using 15 days back rman backup.  

 

• Start database in mount stage as controlfile recovery not required 

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 2936012800 bytes

Fixed Size                  2928728 bytes

Variable Size            1711280040 bytes

Database Buffers         1207959552 bytes

Redo Buffers               13844480 bytes

Database mounted.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

• Connect to the rman console and set time for PITR 

oracle@SGDCPLM12:~> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Dec 6 13:07:24 2021

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

connected to target database: TC12CATI (DBID=3808414881, not open)

RMAN> run

2> {

3> allocate channel dev1 type disk;

4> set until time "to_date('2021-12-03:22:00:00', 'yyyy-mm-dd:hh24:mi:ss')";

5> restore database;

6> recover database;

7> }

using target database control file instead of recovery catalog

allocated channel: dev1

channel dev1: SID=9586 device type=DISK

executing command: SET until clause

Starting restore at 06-DEC-21

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00004 to /u01/oracle_datafile/idata01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0p0e7g3o_25_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0p0e7g3o_25_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:08:15

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00002 to /home/oracle/app/oracle/oradata/TC12CATIAENV/sysaux01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0q0e7gf5_26_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0q0e7gf5_26_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:25

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00003 to /home/oracle/app/oracle/oradata/TC12CATIAENV/undotbs01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0r0e7gfu_27_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0r0e7gfu_27_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:03

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00001 to /home/oracle/app/oracle/oradata/TC12CATIAENV/system01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0s0e7gfv_28_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0s0e7gfv_28_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:15

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00005 to /home/oracle/app/oracle/oradata/TC12CATIAENV/ilog01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0t0e7gge_29_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0t0e7gge_29_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:07

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00006 to /home/oracle/app/oracle/oradata/TC12CATIAENV/indx01.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0u0e7ggh_30_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0u0e7ggh_30_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:01

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00007 to /home/oracle/app/oracle/product/12.1.0/dbhome_1/tcmanager.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_0v0e7ggi_31_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_0v0e7ggi_31_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:01

channel dev1: starting datafile backup set restore

channel dev1: specifying datafile(s) to restore from backup set

channel dev1: restoring datafile 00008 to /home/oracle/app/oracle/product/12.1.0/dbhome_1/tccatenvmanager.dbf

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_100e7ggj_32_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_100e7ggj_32_1_20211115 tag=FULL_BACKUP_DAILY

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:01

Finished restore at 06-DEC-21

Starting recover at 06-DEC-21

starting media recovery

archived log for thread 1 with sequence 188 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_188_js5lm5o2_.arc

archived log for thread 1 with sequence 189 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_189_js5pks7f_.arc

archived log for thread 1 with sequence 190 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_190_js76cxkp_.arc

archived log for thread 1 with sequence 191 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_191_js86z24b_.arc

archived log for thread 1 with sequence 192 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_192_js8ktooq_.arc

archived log for thread 1 with sequence 193 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_193_js9tr2p8_.arc

archived log for thread 1 with sequence 194 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_194_jsbvc5n5_.arc

archived log for thread 1 with sequence 195 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_195_jsd5v7g9_.arc

archived log for thread 1 with sequence 196 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_196_jsfhq802_.arc

archived log for thread 1 with sequence 197 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_197_jsfmw9l9_.arc

archived log for thread 1 with sequence 198 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_198_jsj430p1_.arc

archived log for thread 1 with sequence 199 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_199_jsj8b06m_.arc

archived log for thread 1 with sequence 200 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_200_jsk07gsy_.arc

archived log for thread 1 with sequence 201 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_201_jslbmpc3_.arc

archived log for thread 1 with sequence 202 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_202_jslwqx1f_.arc

archived log for thread 1 with sequence 203 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_203_jsmrfv4m_.arc

archived log for thread 1 with sequence 204 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_204_jsnn83qn_.arc

archived log for thread 1 with sequence 205 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_205_jsofcs3t_.arc

archived log for thread 1 with sequence 206 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_206_jspmjxwq_.arc

archived log for thread 1 with sequence 207 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_207_jsr174xx_.arc

archived log for thread 1 with sequence 208 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_208_jsr5nggy_.arc

archived log for thread 1 with sequence 209 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_209_jsso1d0z_.arc

archived log for thread 1 with sequence 210 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_210_jstomc70_.arc

archived log for thread 1 with sequence 211 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_211_jsv3npx6_.arc

archived log for thread 1 with sequence 212 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_212_jsw9fk3r_.arc

archived log for thread 1 with sequence 213 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_213_jsxb08wr_.arc

archived log for thread 1 with sequence 214 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_214_jsxgjttm_.arc

archived log for thread 1 with sequence 215 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_215_jszmw7l6_.arc

archived log for thread 1 with sequence 216 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_216_jszyfbpw_.arc

archived log for thread 1 with sequence 217 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_217_jt11gp4l_.arc

archived log for thread 1 with sequence 218 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_218_jt2lprkl_.arc

archived log for thread 1 with sequence 219 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_219_jt2lrnos_.arc

archived log for thread 1 with sequence 220 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_220_jt3gtx9h_.arc

archived log for thread 1 with sequence 221 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_221_jt3xzosc_.arc

archived log for thread 1 with sequence 222 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_222_jt57p1fb_.arc

archived log for thread 1 with sequence 223 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_223_jt5g4xdg_.arc

archived log for thread 1 with sequence 224 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_224_jt6fsmld_.arc

archived log for thread 1 with sequence 225 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_225_jt7fg8q5_.arc

archived log for thread 1 with sequence 226 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_226_jt809m3y_.arc

archived log for thread 1 with sequence 227 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_227_jt9dqm0k_.arc

archived log for thread 1 with sequence 228 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_228_jtbhvl2t_.arc

archived log for thread 1 with sequence 229 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_229_jtbnqv1h_.arc

archived log for thread 1 with sequence 230 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_230_jtcmymkl_.arc

archived log for thread 1 with sequence 231 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_231_jtdrt30b_.arc

archived log for thread 1 with sequence 232 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_232_jtf48vgw_.arc

archived log for thread 1 with sequence 233 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_233_jtg3029v_.arc

archived log for thread 1 with sequence 234 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_234_jthg2k86_.arc

archived log for thread 1 with sequence 235 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_235_jthxmhpq_.arc

archived log for thread 1 with sequence 236 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_236_jtkfbpk3_.arc

archived log for thread 1 with sequence 237 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_237_jtldzq8x_.arc

archived log for thread 1 with sequence 238 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_238_jtll0mcs_.arc

archived log for thread 1 with sequence 239 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_239_jtn4mmhq_.arc

archived log for thread 1 with sequence 240 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_240_jto1cvbw_.arc

channel dev1: starting archived log restore to default destination

channel dev1: restoring archived log

archived log thread=1 sequence=187

channel dev1: reading from backup piece /home/oracle/rmanbkp/Backup_TC12CATI_DB_130e7ggo_35_1_20211115

channel dev1: piece handle=/home/oracle/rmanbkp/Backup_TC12CATI_DB_130e7ggo_35_1_20211115 tag=TAG20211115T074944

channel dev1: restored backup piece 1

channel dev1: restore complete, elapsed time: 00:00:55

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_06/o1_mf_1_187_jtvzw15r_.arc thread=1 sequence=187

channel default: deleting archived log(s)

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_06/o1_mf_1_187_jtvzw15r_.arc RECID=184 STAMP=1090588689

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_188_js5lm5o2_.arc thread=1 sequence=188

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_15/o1_mf_1_189_js5pks7f_.arc thread=1 sequence=189

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_190_js76cxkp_.arc thread=1 sequence=190

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_16/o1_mf_1_191_js86z24b_.arc thread=1 sequence=191

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_192_js8ktooq_.arc thread=1 sequence=192

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_193_js9tr2p8_.arc thread=1 sequence=193

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_17/o1_mf_1_194_jsbvc5n5_.arc thread=1 sequence=194

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_195_jsd5v7g9_.arc thread=1 sequence=195

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_196_jsfhq802_.arc thread=1 sequence=196

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_18/o1_mf_1_197_jsfmw9l9_.arc thread=1 sequence=197

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_198_jsj430p1_.arc thread=1 sequence=198

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_19/o1_mf_1_199_jsj8b06m_.arc thread=1 sequence=199

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_200_jsk07gsy_.arc thread=1 sequence=200

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_201_jslbmpc3_.arc thread=1 sequence=201

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_20/o1_mf_1_202_jslwqx1f_.arc thread=1 sequence=202

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_203_jsmrfv4m_.arc thread=1 sequence=203

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_204_jsnn83qn_.arc thread=1 sequence=204

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_21/o1_mf_1_205_jsofcs3t_.arc thread=1 sequence=205

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_206_jspmjxwq_.arc thread=1 sequence=206

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_207_jsr174xx_.arc thread=1 sequence=207

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_22/o1_mf_1_208_jsr5nggy_.arc thread=1 sequence=208

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_209_jsso1d0z_.arc thread=1 sequence=209

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_23/o1_mf_1_210_jstomc70_.arc thread=1 sequence=210

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_211_jsv3npx6_.arc thread=1 sequence=211

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_212_jsw9fk3r_.arc thread=1 sequence=212

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_213_jsxb08wr_.arc thread=1 sequence=213

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_24/o1_mf_1_214_jsxgjttm_.arc thread=1 sequence=214

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_215_jszmw7l6_.arc thread=1 sequence=215

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_25/o1_mf_1_216_jszyfbpw_.arc thread=1 sequence=216

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_217_jt11gp4l_.arc thread=1 sequence=217

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_218_jt2lprkl_.arc thread=1 sequence=218

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_26/o1_mf_1_219_jt2lrnos_.arc thread=1 sequence=219

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_220_jt3gtx9h_.arc thread=1 sequence=220

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_221_jt3xzosc_.arc thread=1 sequence=221

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_27/o1_mf_1_222_jt57p1fb_.arc thread=1 sequence=222

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_223_jt5g4xdg_.arc thread=1 sequence=223

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_224_jt6fsmld_.arc thread=1 sequence=224

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_225_jt7fg8q5_.arc thread=1 sequence=225

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_28/o1_mf_1_226_jt809m3y_.arc thread=1 sequence=226

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_227_jt9dqm0k_.arc thread=1 sequence=227

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_228_jtbhvl2t_.arc thread=1 sequence=228

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_29/o1_mf_1_229_jtbnqv1h_.arc thread=1 sequence=229

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_230_jtcmymkl_.arc thread=1 sequence=230

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_231_jtdrt30b_.arc thread=1 sequence=231

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_11_30/o1_mf_1_232_jtf48vgw_.arc thread=1 sequence=232

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_233_jtg3029v_.arc thread=1 sequence=233

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_234_jthg2k86_.arc thread=1 sequence=234

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_01/o1_mf_1_235_jthxmhpq_.arc thread=1 sequence=235

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_236_jtkfbpk3_.arc thread=1 sequence=236

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_237_jtldzq8x_.arc thread=1 sequence=237

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_02/o1_mf_1_238_jtll0mcs_.arc thread=1 sequence=238

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_239_jtn4mmhq_.arc thread=1 sequence=239

archived log file name=/home/oracle/app/oracle/flash_recovery_area/TC12CATIAENV/archivelog/2021_12_03/o1_mf_1_240_jto1cvbw_.arc thread=1 sequence=240

media recovery complete, elapsed time: 00:03:03

Finished recover at 06-DEC-21

released channel: dev1

RMAN>

• Open database in resetlogs option and take the fresh RMAN backup 

RMAN> alter database open resetlogs;

Statement processed