catalog recovery area后回到incarnation任一时刻

最新推荐文章于 2024-06-20 13:14:51 发布

jnrjian

最新推荐文章于 2024-06-20 13:14:51 发布

阅读量935

点赞数 6

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/jnrjian/article/details/139722867

版权

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> list incarnation;

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

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

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

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

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

RMAN>
released channel: ORA_DISK_1
Statement processed

RMAN>

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>

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

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

RMAN> alter database open resetlogs;

Statement processed

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

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>

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

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

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

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

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

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>

jnrjian

关注

6
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
catalog recovery area后回到incarnation任一时刻

一定要比list incarnation 中的值大于1，否则就是早一个的incarnation。2. catalog recovery area 后默认最新的incarnation，需要结合 SCN号切换incarnation.1. controlfile 一定要足够早，那就是list incarnation 只有两个的时候。
复制链接

扫一扫