RMAN-06023 FRA 和DATA永远不要放在一起

jnrjian

于 2024-06-16 01:56:29 发布

阅读量832

点赞数 15

文章标签：数据库

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

版权

由于FRA 和DATA放在一起，BACKUPSET PDB里面是和datafile放在一起的，再一串数据的目录里，正常会认为这个目录包含的是datafile.

ASMCMD> ls +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.322.1171708345
ASMCMD-8002: entry '0633F844101D69CBE0636401A8C09D55' does not exist in directory '+DATA1/CDB/'
ASMCMD> cd +DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.320.1171708339^C
ASMCMD> ls +DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.320.1171708339
nnndf0_tag20240615t223219_0.320.1171708339

RMAN> restore controlfile from autobackup;

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

recovery area destination: +DATA1
database name (or database unique name) used for search: CDB
channel ORA_DISK_1: AUTOBACKUP +DATA1/CDB/AUTOBACKUP/2024_06_15/s_1171751549.325.1171708349 found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20240616
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20240615
channel ORA_DISK_1: restoring control file from AUTOBACKUP +DATA1/CDB/AUTOBACKUP/2024_06_15/s_1171751549.325.1171708349
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
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> alter database mount;

released channel: ORA_DISK_1
Statement processed

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

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 1.70G DISK 00:00:03 31-DEC-23
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20231231T024616
Piece Name: +DATA1/CDB/BACKUPSET/2023_12_31/nnndf0_tag20231231t024616_0.260.1156945577
List of Datafiles in backup set 10
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/system.275.1148478571
3 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/sysaux.263.1148478647
4 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/undotbs1.264.1148478683
7 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/users.269.1148478683
9 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/undotbs2.268.1148480549
10 Full 7015141 31-DEC-23 NO +DATA/CDB/DATAFILE/undotbs3.262.1148480551

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 1.02G DISK 00:00:02 31-DEC-23
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20231231T024616
Piece Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2023_12_31/nnndf0_tag20231231t024616_0.308.1156945585
List of Datafiles in backup set 11
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
11 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
12 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
13 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
14 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
15 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
16 Full 7015148 31-DEC-23 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 1019.80M DISK 00:00:01 31-DEC-23
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20231231T024616
Piece Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2023_12_31/nnndf0_tag20231231t024616_0.309.1156945587
List of Datafiles in backup set 12
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
6 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
8 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13 Full 19.17M DISK 00:00:00 31-DEC-23
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20231231T024630
Piece Name: +DATA1/CDB/AUTOBACKUP/2023_12_31/s_1156992390.310.1156945591
SPFILE Included: Modification time: 31-DEC-23
SPFILE db_unique_name: CDB
Control File Included: Ckp SCN: 7016673 Ckp time: 31-DEC-23

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 554.24M DISK 00:00:01 15-JUN-24
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: FULL DB BACKUP
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_15/annnf0_full db backup_0.319.1171708337

List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 99 5636553 27-SEP-23 5770215 30-DEC-23

3 69 7317565 15-JUN-24 7317710 15-JUN-24

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15 Full 1.70G DISK 00:00:02 15-JUN-24
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20240615T223219
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.320.1171708339
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/system.275.1148478571
3 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/sysaux.263.1148478647
4 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/undotbs1.264.1148478683
7 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/users.269.1148478683
9 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/undotbs2.268.1148480549
10 Full 7325671 15-JUN-24 NO +DATA/CDB/DATAFILE/undotbs3.262.1148480551

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16 Full 1.02G DISK 00:00:02 15-JUN-24
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20240615T223219
Piece Name: +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.321.1171708343
List of Datafiles in backup set 16
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
11 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
12 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
13 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
14 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
15 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
16 Full 7325710 15-JUN-24 NO +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 1019.80M DISK 00:00:02 15-JUN-24
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20240615T223219
Piece Name: +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t223219_0.322.1171708345
List of Datafiles in backup set 17
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
5 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
6 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
8 Full 5317292 27-SEP-23 NO +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18 36.00K DISK 00:00:00 15-JUN-24
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: FULL DB BACKUP
Piece Name: +DATA1/CDB/BACKUPSET/2024_06_15/annnf0_full db backup_0.324.1171708349

List of Archived Logs in backup set 18
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 118 7325651 15-JUN-24 7325718 15-JUN-24

RMAN> restore database;

Starting restore at 16-JUN-24
Starting implicit crosscheck backup at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=790 device type=DISK
Crosschecked 9 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/ARCHIVELOG/2024_06_15/thread_1_seq_119.341.1171708599
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_120.342.1171708963
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_121.307.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_120.306.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_2_seq_87.296.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_2_seq_88.289.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_3_seq_69.288.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_3_seq_68.259.1171709231
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_1.344.1171709653
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_1.336.1171710315
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_1.337.1171710355
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_1.332.1171711317
File Name: +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_1.330.1171713437
File Name: +DATA1/CDB/AUTOBACKUP/2024_06_15/s_1171751549.325.1171708349

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 01:46:38
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore

-----------所有PDB的文件和备份都没有了

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 0 SYSTEM *** +DATA/CDB/DATAFILE/system.275.1148478571
3 0 SYSAUX *** +DATA/CDB/DATAFILE/sysaux.263.1148478647
4 0 UNDOTBS1 *** +DATA/CDB/DATAFILE/undotbs1.264.1148478683
5 0 PDB$SEED:SYSTEM *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.272.1148480251
6 0 PDB$SEED:SYSAUX *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.271.1148480251
7 0 USERS *** +DATA/CDB/DATAFILE/users.269.1148478683
8 0 PDB$SEED:UNDOTBS1 *** +DATA/CDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.267.1148480251
9 0 UNDOTBS2 *** +DATA/CDB/DATAFILE/undotbs2.268.1148480549
10 0 UNDOTBS3 *** +DATA/CDB/DATAFILE/undotbs3.262.1148480551
11 0 PDB:SYSTEM *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.292.1148481713
12 0 PDB:SYSAUX *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.288.1148481713
13 0 PDB:UNDOTBS1 *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.293.1148481713
14 0 PDB:UNDO_3 *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.291.1148481745
15 0 PDB:UNDO_4 *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.285.1148481747
16 0 PDB:USERS *** +DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.284.1148481749

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> catalog recovery area;