catalog recovery area后回到incarnation任一时刻

1. controlfile 一定要足够早，那就是list incarnation 只有两个的时候

2. catalog recovery area 后默认最新的incarnation，需要结合 SCN号切换incarnation.

3. set until scn  7620291; 一定要比list incarnation 中的值大于1，否则就是早一个的incarnation

------SQL

startup nomount force;
####restore controlfile from autobackup;
restore controlfile from '+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907';
alter database mount;
list incarnation;
catalog recovery area; 
--- YES
list incarnation;
restore database;
list incarnation;

catalog recover area;

reset database to incarnation 8;

  run{
set until time "(to_date('06/16/2024 11:50:00', 'mm/dd/yyyy hh24:mi:ss'))";
 recover database;
 }
 
 
 
reset database to incarnation 9;

 run{
 set until scn  7620291;
  restore database;
  recover database;
  }

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

list incarnation;
catalog recovery area; 
--- YES
list incarnation;

  

RMAN> startup nomount force;

####restore controlfile from autobackup;
restore controlfile from '+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907';
alter database mount;
Oracle instance started

Total System Global Area    2382361320 bytes

Fixed Size                     9167592 bytes
Variable Size                822083584 bytes
Database Buffers            1543503872 bytes
Redo Buffers                   7606272 bytes

RMAN> 2> 
Starting restore at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=789 instance=cdb3 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output file name=+DATA/CDB/CONTROLFILE/current.303.1148478735
output file name=+DATA/CDB/CONTROLFILE/current.289.1148478735
Finished restore at 16-JUN-24

RMAN> 
released channel: ORA_DISK_1
Statement processed

RMAN> 

RMAN> 

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       CURRENT 1920977    26-SEP-23

RMAN> reset database to incarnation 2;

Starting implicit crosscheck backup at 16-JUN-24
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-JUN-24

Starting implicit crosscheck copy at 16-JUN-24
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JUN-24

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +DATA1/CDB/DATAFILE/system.312.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs1.276.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs2.300.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs3.299.1171725751
File Name: +DATA1/CDB/DATAFILE/users.293.1171725751
File Name: +DATA1/CDB/CONTROLFILE/current.333.1171762815
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764787.275.1171721587
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171765303.307.1171722103
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766300.273.1171723101
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766850.268.1171723651
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171769396.261.1171726197
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799693.271.1171756493
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800718.265.1171757519
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171763088.277.1171763089
File Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.284.1171756485
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.302.1171756479
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.301.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.291.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.272.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_126.281.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_87.296.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_88.289.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_69.288.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_68.259.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.270.1171725689
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.266.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.310.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.320.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.267.1171763083

database reset to incarnation 2

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       CURRENT 1920977    26-SEP-23
6       6       CDB      2265125454       ORPHAN  7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
4       4       CDB      2265125454       ORPHAN  7326802    16-JUN-24
3       3       CDB      2265125454       ORPHAN  7329707    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24
  
RMAN>   run{
  set until scn 7326604;
  restore database;
  recover database;
  }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1

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 +DATA/CDB/DATAFILE/system.275.1148478571
channel ORA_DISK_1: restoring datafile 00003 to +DATA/CDB/DATAFILE/sysaux.263.1148478647
channel ORA_DISK_1: restoring datafile 00004 to +DATA/CDB/DATAFILE/undotbs1.264.1148478683
channel ORA_DISK_1: restoring datafile 00007 to +DATA/CDB/DATAFILE/users.269.1148478683
channel ORA_DISK_1: restoring datafile 00009 to +DATA/CDB/DATAFILE/undotbs2.268.1148480549
channel ORA_DISK_1: restoring datafile 00010 to +DATA/CDB/DATAFILE/undotbs3.262.1148480551
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00011 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
channel ORA_DISK_1: restoring datafile 00012 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
channel ORA_DISK_1: restoring datafile 00013 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
channel ORA_DISK_1: restoring datafile 00014 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
channel ORA_DISK_1: restoring datafile 00015 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
channel ORA_DISK_1: restoring datafile 00016 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899
channel ORA_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
channel ORA_DISK_1: restoring datafile 00006 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
channel ORA_DISK_1: restoring datafile 00008 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
channel ORA_DISK_1: piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 16-JUN-24

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 122 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905
archived log for thread 1 with sequence 123 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
archived log for thread 1 with sequence 124 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905 thread=1 sequence=122
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971 thread=1 sequence=123
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975 thread=1 sequence=124
media recovery complete, elapsed time: 00:00:01
Finished recover at 16-JUN-24

RMAN> report schema;

RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name CDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1160     SYSTEM               ***     +DATA/CDB/DATAFILE/system.285.1171764345
3    890      SYSAUX               ***     +DATA/CDB/DATAFILE/sysaux.291.1171764345
4    615      UNDOTBS1             ***     +DATA/CDB/DATAFILE/undotbs1.265.1171764345
5    510      PDB$SEED:SYSTEM      ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.269.1171764355
6    480      PDB$SEED:SYSAUX      ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.264.1171764355
7    5        USERS                ***     +DATA/CDB/DATAFILE/users.272.1171764345
8    215      PDB$SEED:UNDOTBS1    ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.263.1171764355
9    250      UNDOTBS2             ***     +DATA/CDB/DATAFILE/undotbs2.292.1171764345
10   25       UNDOTBS3             ***     +DATA/CDB/DATAFILE/undotbs3.271.1171764345
11   510      PDB:SYSTEM           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.293.1171764351
12   490      PDB:SYSAUX           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.286.1171764351
13   215      PDB:UNDOTBS1         ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.267.1171764351
14   215      PDB:UNDO_3           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.262.1171764351
15   215      PDB:UNDO_4           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.268.1171764351
16   5        PDB:USERS            ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.275.1171764351

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    272      TEMP                 32767       +DATA/CDB/TEMPFILE/temp.273.1148478745
2    36       PDB$SEED:TEMP        32767       +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.265.1148480293
3    98       PDB:TEMP             32767       +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.286.1148481715

RMAN> alter database open resetlogs;

Statement processed

RMAN> exit

Recovery Manager complete.
[oracle@rac3 ~]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jun 16 02:06:34 2024
Version 19.20.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE YES
SQL> alter session set container=pdb;

-----

RMAN>  list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       PARENT  1920977    26-SEP-23
6       6       CDB      2265125454       ORPHAN  7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
10      10      CDB      2265125454       ORPHAN  7326605    16-JUN-24
11      11      CDB      2265125454       ORPHAN  7326605    16-JUN-24
4       4       CDB      2265125454       PARENT  7326802    16-JUN-24
3       3       CDB      2265125454       PARENT  7329707    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
13      13      CDB      2265125454       CURRENT 7329708    16-JUN-24
12      12      CDB      2265125454       ORPHAN  7329708    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24

RMAN>  run{
2>   set until scn 7326604;
3>   restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 05:05:21
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN> reset database to incarnation  5;

database reset to incarnation 5

RMAN>   run{
2>   set until scn 7326604;
3>   restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 05:06:22
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN>   run{
2>   set until scn 7326605;
3>   restore database;
4>   recover database;
5>   }

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 122 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905
archived log for thread 1 with sequence 123 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905 thread=1 sequence=122
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971 thread=1 sequence=123
unable to find archived log
archived log thread=1 sequence=1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 05:07:02
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1 and starting SCN of 7326604

SQL> show pdbs;    

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB                            READ WRITE YES
SQL> select  count(*) from abc;
select  count(*) from abc
                      *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> 

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

RMAN> 
released channel: ORA_DISK_1
Statement processed

RMAN> run{
2>   set until scn 7326604;
3>   restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
Starting implicit crosscheck backup at 16-JUN-24
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-JUN-24

Starting implicit crosscheck copy at 16-JUN-24
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JUN-24

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +DATA1/CDB/DATAFILE/system.312.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs1.276.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs2.300.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs3.299.1171725751
File Name: +DATA1/CDB/DATAFILE/users.293.1171725751
File Name: +DATA1/CDB/CONTROLFILE/current.333.1171762815
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764787.275.1171721587
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171765303.307.1171722103
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766300.273.1171723101
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766850.268.1171723651
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171769396.261.1171726197
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799693.271.1171756493
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800718.265.1171757519
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171763088.277.1171763089
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764388.336.1171764389
File Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.284.1171756485
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.302.1171756479
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.301.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.291.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.272.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_126.281.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_87.296.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_88.289.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_69.288.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_68.259.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.270.1171725689
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.266.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.310.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.320.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.267.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.264.1171764381
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.335.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.274.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.311.1171764385
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.337.1171764415
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.339.1171764439
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_4.340.1171764459

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 02:11:25
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN>  reset database to incarnation 2;

database reset to incarnation 2

RMAN>  run{
2>   set until scn 7326604;
3>   restore database;
4>   recover database;
5>   }

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

RMAN> list inarcation;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, guid, incarnation, like, proxy, preplugin, recoverable, restore, script, tag"
RMAN-01008: the bad identifier was: inarcation
RMAN-01007: at line 1 column 6 file: standard input

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       PARENT  1920977    26-SEP-23
6       6       CDB      2265125454       ORPHAN  7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
11      11      CDB      2265125454       CURRENT 7326605    16-JUN-24
10      10      CDB      2265125454       ORPHAN  7326605    16-JUN-24
4       4       CDB      2265125454       ORPHAN  7326802    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
3       3       CDB      2265125454       ORPHAN  7329707    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24

RMAN> reset database to incarnation 8;

database reset to incarnation 8

RMAN>   run{
2> set until scn 7512942;
3> restore database;
4>  recover database;
5>  }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 02:16:18
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN>   run{
2> set until scn 7512944;  ---------------------
3> restore database;
4>  recover database;
5>  }

RMAN> reset database to incarnation 6;

database reset to incarnation 8

RMAN>   run{
 set until scn 7326534;
 restore database;
  recover database;
  }

database reset to incarnation 6

RMAN> run{
2>  set until scn 7326534;
3>  restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=38 instance=cdb3 device type=DISK

skipping datafile 5; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.275.1171765007
skipping datafile 6; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.350.1171765007
skipping datafile 8; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.269.1171765007
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 +DATA/CDB/DATAFILE/system.293.1171764993
channel ORA_DISK_1: restoring datafile 00003 to +DATA/CDB/DATAFILE/sysaux.286.1171764993
channel ORA_DISK_1: restoring datafile 00004 to +DATA/CDB/DATAFILE/undotbs1.267.1171764993
channel ORA_DISK_1: restoring datafile 00007 to +DATA/CDB/DATAFILE/users.268.1171764993
channel ORA_DISK_1: restoring datafile 00009 to +DATA/CDB/DATAFILE/undotbs2.262.1171764993
channel ORA_DISK_1: restoring datafile 00010 to +DATA/CDB/DATAFILE/undotbs3.285.1171764993
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 16-JUN-24

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 02:18:14
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
 if needed start until change 7326534 using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19912: cannot recover to target incarnation 6

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

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

RMAN> startup nomount force;

####restore controlfile from autobackup;
restore controlfile from '+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907';
alter database mount;
list incarnation;
catalog recover area;
list incarnation;
Oracle instance started

Total System Global Area    2382361320 bytes

Fixed Size                     9167592 bytes
Variable Size                822083584 bytes
Database Buffers            1543503872 bytes
Redo Buffers                   7606272 bytes

RMAN> 2> 
Starting restore at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 instance=cdb3 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output file name=+DATA/CDB/CONTROLFILE/current.303.1148478735
output file name=+DATA/CDB/CONTROLFILE/current.289.1148478735
Finished restore at 16-JUN-24

RMAN> 
released channel: ORA_DISK_1
Statement processed

RMAN> 

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       CURRENT 1920977    26-SEP-23

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "recover": expecting one of: "archivelog, backuppiece, backup, controlfilecopy, datafilecopy, db_recovery_file_dest, device, preplugin, recovery, start"
RMAN-01007: at line 1 column 9 file: standard input

RMAN> 

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       CURRENT 1920977    26-SEP-23

RMAN> 

RMAN> 

RMAN> 

RMAN> catalog recovery area;

Starting implicit crosscheck backup at 16-JUN-24
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-JUN-24

Starting implicit crosscheck copy at 16-JUN-24
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JUN-24

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +DATA1/CDB/DATAFILE/system.312.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs1.276.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs2.300.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs3.299.1171725751
File Name: +DATA1/CDB/DATAFILE/users.293.1171725751
File Name: +DATA1/CDB/CONTROLFILE/current.333.1171762815
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764787.275.1171721587
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171765303.307.1171722103
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766300.273.1171723101
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766850.268.1171723651
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171769396.261.1171726197
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799693.271.1171756493
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800718.265.1171757519
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171763088.277.1171763089
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764388.336.1171764389
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764772.344.1171764773
File Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.284.1171756485
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.302.1171756479
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.301.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.291.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.272.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_126.281.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_87.296.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_88.289.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_69.288.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_68.259.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.270.1171725689
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.266.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.310.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.320.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.267.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.264.1171764381
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.335.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.274.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.311.1171764385
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.337.1171764415
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.339.1171764439
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_4.340.1171764459
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.334.1171764765
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.323.1171764767
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.341.1171764767
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.338.1171764771
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.345.1171764791
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.347.1171764815

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: +DATA1/CDB/ONLINELOG/group_1.286.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_2.285.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_3.282.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_4.279.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_5.269.1171725767
File Name: +DATA1/CDB/ONLINELOG/group_6.263.1171725767
File Name: +DATA1/CDB/ONLINELOG/group_1.326.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_2.327.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_3.328.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_4.329.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_5.330.1171758461
File Name: +DATA1/CDB/ONLINELOG/group_6.331.1171758461
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771

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

List of Cataloged Files
=======================
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771

List of Files Which Were Not Cataloged
=======================================
File Name: +DATA1/CDB/ONLINELOG/group_1.286.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_2.285.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_3.282.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_4.279.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_5.269.1171725767
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_6.263.1171725767
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_1.326.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_2.327.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_3.328.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_4.329.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_5.330.1171758461
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_6.331.1171758461
  RMAN-07529: Reason: catalog is not supported for this file type

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       PARENT  1920977    26-SEP-23
6       6       CDB      2265125454       ORPHAN  7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
11      11      CDB      2265125454       CURRENT 7326605    16-JUN-24
10      10      CDB      2265125454       ORPHAN  7326605    16-JUN-24
4       4       CDB      2265125454       ORPHAN  7326802    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
3       3       CDB      2265125454       ORPHAN  7329707    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24

RMAN> reset database to incarnation 6;

 run{
database reset to incarnation 6
 set until scn 7326536;

RMAN> 
RMAN> 2> 3>  restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1

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 +DATA/CDB/DATAFILE/system.275.1148478571
channel ORA_DISK_1: restoring datafile 00003 to +DATA/CDB/DATAFILE/sysaux.263.1148478647
channel ORA_DISK_1: restoring datafile 00004 to +DATA/CDB/DATAFILE/undotbs1.264.1148478683
channel ORA_DISK_1: restoring datafile 00007 to +DATA/CDB/DATAFILE/users.269.1148478683
channel ORA_DISK_1: restoring datafile 00009 to +DATA/CDB/DATAFILE/undotbs2.268.1148480549
channel ORA_DISK_1: restoring datafile 00010 to +DATA/CDB/DATAFILE/undotbs3.262.1148480551
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.314.1171720897 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00011 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
channel ORA_DISK_1: restoring datafile 00012 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
channel ORA_DISK_1: restoring datafile 00013 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
channel ORA_DISK_1: restoring datafile 00014 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
channel ORA_DISK_1: restoring datafile 00015 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
channel ORA_DISK_1: restoring datafile 00016 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899
channel ORA_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
channel ORA_DISK_1: restoring datafile 00006 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
channel ORA_DISK_1: restoring datafile 00008 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
channel ORA_DISK_1: piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 16-JUN-24

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 02:21:40
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
 if needed start until change 7326536 using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19912: cannot recover to target incarnation 6

RMAN> report schema;   

RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name CDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1160     SYSTEM               ***     +DATA/CDB/DATAFILE/system.269.1171765277
3    890      SYSAUX               ***     +DATA/CDB/DATAFILE/sysaux.350.1171765277
4    615      UNDOTBS1             ***     +DATA/CDB/DATAFILE/undotbs1.275.1171765277
5    510      PDB$SEED:SYSTEM      ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.267.1171765291
6    480      PDB$SEED:SYSAUX      ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.286.1171765291
7    5        USERS                ***     +DATA/CDB/DATAFILE/users.291.1171765277
8    215      PDB$SEED:UNDOTBS1    ***     +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171765291
9    250      UNDOTBS2             ***     +DATA/CDB/DATAFILE/undotbs2.288.1171765277
10   25       UNDOTBS3             ***     +DATA/CDB/DATAFILE/undotbs3.272.1171765277
11   510      PDB:SYSTEM           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.271.1171765285
12   490      PDB:SYSAUX           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.292.1171765285
13   215      PDB:UNDOTBS1         ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.265.1171765285
14   215      PDB:UNDO_3           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.268.1171765285
15   215      PDB:UNDO_4           ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1171765285
16   5        PDB:USERS            ***     +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.262.1171765285

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    272      TEMP                 32767       +DATA/CDB/TEMPFILE/temp.273.1148478745
2    36       PDB$SEED:TEMP        32767       +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.265.1148480293
3    98       PDB:TEMP             32767       +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.286.1148481715

RMAN> reset database to incarnation 6;

database reset to incarnation 6

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       PARENT  1920977    26-SEP-23
6       6       CDB      2265125454       CURRENT 7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
11      11      CDB      2265125454       ORPHAN  7326605    16-JUN-24
10      10      CDB      2265125454       ORPHAN  7326605    16-JUN-24
4       4       CDB      2265125454       ORPHAN  7326802    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
3       3       CDB      2265125454       ORPHAN  7329707    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24

RMAN>  run{
2>  set until scn 7326532;
3>  ###restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting recover at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 02:23:30
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN>  run{
2>  set until scn 7326632;
3>  ###restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 02:23:56
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
 if needed start until change 7326632 using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19912: cannot recover to target incarnation 6

RMAN> reset database to incarnation 3;

 
database reset to incarnation 3

RMAN> 
RMAN> 
RMAN>  run{
2>   set until scn  7329707;
3> restore database;
4>    recover database;
5>    }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 04:58:31
RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN> reset database to incarnation 3;

 
 run{
  set until scn  7329708;
restore database;
   recover database;
   }

executing command: SET until clause

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 122 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905
archived log for thread 1 with sequence 123 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
archived log for thread 1 with sequence 124 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
archived log for thread 1 with sequence 125 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
archived log for thread 1 with sequence 126 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
archived log for thread 1 with sequence 127 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
archived log for thread 1 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905 thread=1 sequence=122
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971 thread=1 sequence=123
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975 thread=1 sequence=124
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977 thread=1 sequence=125
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981 thread=1 sequence=126
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577 thread=1 sequence=127
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095 thread=1 sequence=1
unable to find archived log
archived log thread=1 sequence=1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 02:24:27
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1 and starting SCN of 7329707

RMAN> alter database open resetlogs;

Statement processed

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> exit

Recovery Manager complete.
[oracle@rac3 ~]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jun 16 02:25:05 2024
Version 19.20.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL>  alter session set container=PDB;

 select  count(*) from abc;
 

  COUNT(*)
----------
     73082

SQL>

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

RMAN> 

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       CURRENT 1920977    26-SEP-23

RMAN> 
Starting implicit crosscheck backup at 16-JUN-24
allocated channel: ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck backup at 16-JUN-24

Starting implicit crosscheck copy at 16-JUN-24
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JUN-24

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +DATA1/CDB/DATAFILE/system.312.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs1.276.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs2.300.1171725751
File Name: +DATA1/CDB/DATAFILE/undotbs3.299.1171725751
File Name: +DATA1/CDB/DATAFILE/users.293.1171725751
File Name: +DATA1/CDB/CONTROLFILE/current.333.1171762815
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764106.297.1171720907
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764787.275.1171721587
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171765303.307.1171722103
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766300.273.1171723101
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171766850.268.1171723651
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171769396.261.1171726197
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799693.271.1171756493
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800718.265.1171757519
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171763088.277.1171763089
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764388.336.1171764389
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171764772.344.1171764773
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171765491.351.1171765491
File Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.284.1171756485
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.302.1171756479
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.301.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.291.1171756481
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
File Name: +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup_0.272.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_126.281.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_87.296.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_2_seq_88.289.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_69.288.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_68.259.1171721577
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.270.1171725689
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.266.1171757513
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.310.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.320.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.267.1171763083
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.264.1171764381
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.335.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.274.1171764383
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.311.1171764385
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.337.1171764415
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.339.1171764439
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_4.340.1171764459
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.334.1171764765
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.323.1171764767
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.341.1171764767
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.338.1171764771
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.345.1171764791
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.347.1171764815
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.349.1171765485
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.348.1171765485
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.346.1171765485
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.350.1171765487
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.353.1171765511
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.354.1171765535
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_4.355.1171765557
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_5.357.1171771223

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: +DATA1/CDB/ONLINELOG/group_1.286.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_2.285.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_3.282.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_4.279.1171725765
File Name: +DATA1/CDB/ONLINELOG/group_5.269.1171725767
File Name: +DATA1/CDB/ONLINELOG/group_6.263.1171725767
File Name: +DATA1/CDB/ONLINELOG/group_1.326.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_2.327.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_3.328.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_4.329.1171758459
File Name: +DATA1/CDB/ONLINELOG/group_5.330.1171758461
File Name: +DATA1/CDB/ONLINELOG/group_6.331.1171758461
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771

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

List of Cataloged Files
=======================
File Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/TEMPFILE/temp.262.1171725771

List of Files Which Were Not Cataloged
=======================================
File Name: +DATA1/CDB/ONLINELOG/group_1.286.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_2.285.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_3.282.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_4.279.1171725765
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_5.269.1171725767
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_6.263.1171725767
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_1.326.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_2.327.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_3.328.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_4.329.1171758459
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_5.330.1171758461
  RMAN-07529: Reason: catalog is not supported for this file type
File Name: +DATA1/CDB/ONLINELOG/group_6.331.1171758461
  RMAN-07529: Reason: catalog is not supported for this file type

RMAN> list recovery area;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "recovery": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, guid, incarnation, like, proxy, preplugin, recoverable, restore, script, tag"
RMAN-01007: at line 1 column 6 file: standard input

RMAN> list recovery area all;  

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "recovery": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, guid, incarnation, like, proxy, preplugin, recoverable, restore, script, tag"
RMAN-01007: at line 1 column 6 file: standard input

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       CDB      2265125454       PARENT  1          17-APR-19
2       2       CDB      2265125454       PARENT  1920977    26-SEP-23
6       6       CDB      2265125454       ORPHAN  7326532    16-JUN-24
5       5       CDB      2265125454       ORPHAN  7326604    16-JUN-24
11      11      CDB      2265125454       ORPHAN  7326605    16-JUN-24
10      10      CDB      2265125454       ORPHAN  7326605    16-JUN-24
4       4       CDB      2265125454       PARENT  7326802    16-JUN-24
7       7       CDB      2265125454       ORPHAN  7329707    16-JUN-24
3       3       CDB      2265125454       PARENT  7329707    16-JUN-24
12      12      CDB      2265125454       CURRENT 7329708    16-JUN-24
8       8       CDB      2265125454       ORPHAN  7512942    16-JUN-24
9       9       CDB      2265125454       ORPHAN  7620289    16-JUN-24

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> reset database to incarnation 9;

 run{
database reset to incarnation 9

 set until scn  7620291;
RMAN> 
RMAN> 2> 3>  ###restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting recover at 16-JUN-24
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 04:54:27
RMAN-06094: datafile 1 must be restored

RMAN> reset database to incarnation 9;

 run{
database reset to incarnation 9
 set until scn  7620291;

RMAN> 
RMAN> 2> 3>   restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1

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 00011 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
channel ORA_DISK_1: restoring datafile 00012 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
channel ORA_DISK_1: restoring datafile 00013 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
channel ORA_DISK_1: restoring datafile 00014 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
channel ORA_DISK_1: restoring datafile 00015 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
channel ORA_DISK_1: restoring datafile 00016 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899
channel ORA_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 +DATA/CDB/DATAFILE/system.275.1148478571
channel ORA_DISK_1: restoring datafile 00003 to +DATA/CDB/DATAFILE/sysaux.263.1148478647
channel ORA_DISK_1: restoring datafile 00004 to +DATA/CDB/DATAFILE/undotbs1.264.1148478683
channel ORA_DISK_1: restoring datafile 00007 to +DATA/CDB/DATAFILE/users.269.1148478683
channel ORA_DISK_1: restoring datafile 00009 to +DATA/CDB/DATAFILE/undotbs2.268.1148480549
channel ORA_DISK_1: restoring datafile 00010 to +DATA/CDB/DATAFILE/undotbs3.262.1148480551
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 04:54:43
ORA-19870: error while restoring backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup "DATA" space exhausted

RMAN> 

RMAN> 

RMAN> 

RMAN> 

RMAN> reset database to incarnation 9;

 run{
database reset to incarnation 9

 set until scn  7620291;
RMAN> 
RMAN> 2> 3>   restore database;
4>   recover database;
5>   }

executing command: SET until clause

Starting restore at 16-JUN-24
using channel ORA_DISK_1

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 00011 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.284.1171774479
channel ORA_DISK_1: restoring datafile 00012 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.347.1171774479
channel ORA_DISK_1: restoring datafile 00013 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.346.1171774479
channel ORA_DISK_1: restoring datafile 00014 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.359.1171774479
channel ORA_DISK_1: restoring datafile 00015 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.360.1171774479
channel ORA_DISK_1: restoring datafile 00016 to +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.363.1171774479
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899
channel ORA_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.313.1171720899 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 +DATA/CDB/DATAFILE/system.275.1148478571
channel ORA_DISK_1: restoring datafile 00003 to +DATA/CDB/DATAFILE/sysaux.263.1148478647
channel ORA_DISK_1: restoring datafile 00004 to +DATA/CDB/DATAFILE/undotbs1.264.1148478683
channel ORA_DISK_1: restoring datafile 00007 to +DATA/CDB/DATAFILE/users.269.1148478683
channel ORA_DISK_1: restoring datafile 00009 to +DATA/CDB/DATAFILE/undotbs2.268.1148480549
channel ORA_DISK_1: restoring datafile 00010 to +DATA/CDB/DATAFILE/undotbs3.262.1148480551
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483
channel ORA_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.290.1171756483 tag=FULLDBBACKUP
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 00005 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
channel ORA_DISK_1: restoring datafile 00006 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
channel ORA_DISK_1: restoring datafile 00008 to +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489
channel ORA_DISK_1: piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup_0.283.1171756489 tag=FULLDBBACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 16-JUN-24

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 122 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905
archived log for thread 1 with sequence 123 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971
archived log for thread 1 with sequence 124 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975
archived log for thread 1 with sequence 125 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977
archived log for thread 1 with sequence 126 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981
archived log for thread 1 with sequence 127 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577
archived log for thread 1 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095
archived log for thread 1 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
archived log for thread 1 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
archived log for thread 1 with sequence 4 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
archived log for thread 1 with sequence 5 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
archived log for thread 1 with sequence 6 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
archived log for thread 1 with sequence 7 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
archived log for thread 1 with sequence 8 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
archived log for thread 1 with sequence 9 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
archived log for thread 1 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
archived log for thread 1 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
archived log for thread 1 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
archived log for thread 1 with sequence 4 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
archived log for thread 1 with sequence 5 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_122.305.1171720905 thread=1 sequence=122
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_123.295.1171720971 thread=1 sequence=123
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_124.294.1171720975 thread=1 sequence=124
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_125.292.1171720977 thread=1 sequence=125
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_126.287.1171720981 thread=1 sequence=126
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_127.280.1171721577 thread=1 sequence=127
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.306.1171722095 thread=1 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.270.1171725689 thread=1 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 17 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.267.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 17
Executing: alter database datafile 17 offline
Segmentation fault
[oracle@rac3 ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jun 16 04:55:30 2024
Version 19.20.0.0.0

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

connected to target database: CDB (DBID=2265125454, not open)

RMAN> reset database to incarnation 9;

using target database control file instead of recovery catalog
 run{
 set until scn  7620291;
  restore database;
  recover database;
  }database reset to incarnation 9

RMAN> 
RMAN> 2> 3> 4> 5> 

executing command: SET until clause

Starting restore at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 instance=cdb3 device type=DISK

skipping datafile 1; already restored to file +DATA/CDB/DATAFILE/system.359.1171774501
skipping datafile 3; already restored to file +DATA/CDB/DATAFILE/sysaux.346.1171774501
skipping datafile 4; already restored to file +DATA/CDB/DATAFILE/undotbs1.347.1171774501
skipping datafile 7; already restored to file +DATA/CDB/DATAFILE/users.285.1171774501
skipping datafile 9; already restored to file +DATA/CDB/DATAFILE/undotbs2.284.1171774501
skipping datafile 10; already restored to file +DATA/CDB/DATAFILE/undotbs3.262.1171774501
skipping datafile 5; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.268.1171774515
skipping datafile 6; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.265.1171774515
skipping datafile 8; already restored to file +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.292.1171774515
restore not done; all files read only, offline, excluded, or already restored
Finished restore at 16-JUN-24

Starting recover at 16-JUN-24
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131
archived log for thread 1 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155
archived log for thread 1 with sequence 4 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179
archived log for thread 1 with sequence 5 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203
archived log for thread 1 with sequence 6 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789
archived log for thread 1 with sequence 7 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479
archived log for thread 1 with sequence 8 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493
archived log for thread 1 with sequence 9 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513
archived log for thread 1 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189
archived log for thread 1 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317
archived log for thread 1 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317
archived log for thread 1 with sequence 4 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319
archived log for thread 1 with sequence 5 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 17 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.267.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 17
Executing: alter database datafile 17 offline
Plugin datafile 18 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.286.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 18
Executing: alter database datafile 18 offline
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 19 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 19
Executing: alter database datafile 19 offline
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 20 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.272.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 20
Executing: alter database datafile 20 offline
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 21 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.271.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 21
Executing: alter database datafile 21 offline
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
Plugin datafile 22 (+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.292.1171725759) cannot be created during recovery and will be offlined.
PDB PDB created during recovery, offlining file 22
Executing: alter database datafile 22 offline
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_2.325.1171746131 thread=1 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_3.318.1171746155 thread=1 sequence=3
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_4.317.1171746179 thread=1 sequence=4
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_5.257.1171746203 thread=1 sequence=5
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_6.304.1171746789 thread=1 sequence=6
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_7.303.1171756479 thread=1 sequence=7
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_8.278.1171756493 thread=1 sequence=8
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_9.319.1171757513 thread=1 sequence=9
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_1.309.1171758189 thread=1 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_2.322.1171759317 thread=1 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_3.324.1171759317 thread=1 sequence=3
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_4.308.1171759319 thread=1 sequence=4
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.321.1171759321 thread=3 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_1_seq_5.260.1171759319 thread=1 sequence=5
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.332.1171762795 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.256.1171763083 thread=3 sequence=3
unable to find archived log
archived log thread=3 sequence=1
Segmentation fault
[oracle@rac3 ~]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jun 16 04:55:50 2024
Version 19.20.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
SQL>