backup format '/home/oracle/bak/archlog_%T_%s_%U' archivelog all delete all input;
export ORACLE_SID=pdb
startup nomount pfile='/tmp/1.txt'
restore controlfile from '/home/oracle/bak/c.bak';
alter database mount;
##########
ile Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** +DATA/PDB19C/DATAFILE/system.1062.1212164913
3 950 SYSAUX *** +DATA/PDB19C/DATAFILE/sysaux.1061.1212164939
4 745 UNDOTBS1 *** +DATA/PDB19C/DATAFILE/undotbs1.1060.1212164963
5 480 PDB$SEED:SYSTEM *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.472.1212168195
6 440 PDB$SEED:SYSAUX *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.474.1212168195
7 5 USERS *** +DATA/PDB19C/DATAFILE/users.1059.1212164965
8 240 PDB$SEED:UNDOTBS1 *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.337.1212168195
9 75 UNDOTBS2 *** +DATA/PDB19C/DATAFILE/undotbs2.334.1212168617
10 480 PDB01:SYSTEM *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/system.301.1212171415
11 460 PDB01:SYSAUX *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/sysaux.303.1212171415
12 240 PDB01:UNDOTBS1 *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/undotbs1.307.1212171413
13 240 PDB01:UNDO_2 *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/undo_2.293.1212171635
14 20 PDB01:USERS *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/users.312.1212171505
15 100 USERS *** +DATA/PDB19C/DATAFILE/users.617.1215857907 <<< 全备之后新添加数据文件。
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 231 TEMP 32767 +DATA/PDB19C/TEMPFILE/temp.1055.1212165181
2 201 PDB$SEED:TEMP 32767 +DATA/PDB19C/3F10E6C0271129FAE0630A39A8C03EC2/TEMPFILE/temp.336.1212168219
3 201 PDB01:TEMP 32767 +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/TEMPFILE/temp.281.121217142
#原位置： +DATA
#新目录位置： /home/oracle/orapdb
run
{
set newname for database to '/home/oracle/orapdb/%U.f';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_2.1056.1212165089' to '/home/oracle/orapdb/redo1.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_1.1057.1212165089' to '/home/oracle/orapdb/redo2.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_3.333.1212171145' to '/home/oracle/orapdb/redo3.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_4.305.1212171147' to '/home/oracle/orapdb/redo4.log';
set until scn 3081122;
restore database;
switch datafile all;
}
RMAN> run
2> {
3> set newname for database to '/home/oracle/orapdb/%U.f';
4> alter database rename file '+DATA/PDB19C/ONLINELOG/group_2.1056.1212165089' to '/home/oracle/orapdb/redo1.log';
5> alter database rename file '+DATA/PDB19C/ONLINELOG/group_1.1057.1212165089' to '/home/oracle/orapdb/redo2.log';
6> alter database rename file '+DATA/PDB19C/ONLINELOG/group_3.333.1212171145' to '/home/oracle/orapdb/redo3.log';
7> alter database rename file '+DATA/PDB19C/ONLINELOG/group_4.305.1212171147' to '/home/oracle/orapdb/redo4.log';
8> set until scn 3081122;
9> restore database;
10> switch datafile all;
11> }
executing command: SET NEWNAME
Statement processed
Statement processed
Statement processed
Statement processed
executing command: SET until clause
Starting restore at 30-OCT-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=208 device type=DISK
creating datafile file number=15 name=/home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f <<<< 会新创建新添加数据文件。
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 /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
channel ORA_DISK_1: restoring datafile 00007 to /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
channel ORA_DISK_1: restoring datafile 00009 to /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/db-0247h14s_2_1_1.bak
channel ORA_DISK_1: piece handle=/home/oracle/bak/db-0247h14s_2_1_1.bak tag=TAG20251030T101659
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 00010 to /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
channel ORA_DISK_1: restoring datafile 00011 to /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
channel ORA_DISK_1: restoring datafile 00012 to /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
channel ORA_DISK_1: restoring datafile 00013 to /home/oracle/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
channel ORA_DISK_1: restoring datafile 00014 to /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/db-0347h15b_3_1_1.bak
channel ORA_DISK_1: piece handle=/home/oracle/bak/db-0347h15b_3_1_1.bak tag=TAG20251030T101659
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 /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
channel ORA_DISK_1: restoring datafile 00006 to /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
channel ORA_DISK_1: restoring datafile 00008 to /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/db-0447h15i_4_1_1.bak
channel ORA_DISK_1: piece handle=/home/oracle/bak/db-0447h15i_4_1_1.bak tag=TAG20251030T101659
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 30-OCT-25
datafile 1 switched to datafile copy
input datafile copy RECID=18 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
datafile 3 switched to datafile copy
input datafile copy RECID=19 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
datafile 4 switched to datafile copy
input datafile copy RECID=20 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
datafile 5 switched to datafile copy
input datafile copy RECID=21 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
datafile 6 switched to datafile copy
input datafile copy RECID=22 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
datafile 7 switched to datafile copy
input datafile copy RECID=23 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
datafile 8 switched to datafile copy
input datafile copy RECID=24 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
datafile 9 switched to datafile copy
input datafile copy RECID=25 STAMP=1215860567 file name=/home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
datafile 10 switched to datafile copy
input datafile copy RECID=26 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
datafile 11 switched to datafile copy
input datafile copy RECID=27 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
datafile 12 switched to datafile copy
input datafile copy RECID=28 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
datafile 13 switched to datafile copy
input datafile copy RECID=29 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
datafile 14 switched to datafile copy
input datafile copy RECID=30 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
datafile 15 switched to datafile copy
input datafile copy RECID=31 STAMP=1215860568 file name=/home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
RMAN> report schema;
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 231 TEMP 32767 +DATA/PDB19C/TEMPFILE/temp.1055.1212165181
2 201 PDB$SEED:TEMP 32767 +DATA/PDB19C/3F10E6C0271129FAE0630A39A8C03EC2/TEMPFILE/temp.336.1212168219
3 201 PDB01:TEMP 32767 +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/TEMPFILE/temp.281.1212171423
RMAN>
run{
set until scn 3081122;
recover database;
}
RMAN> run{
2> set until scn 3081122;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 30-OCT-25
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=15
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=16
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=17
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/archlog_20251030_6_0647h19u_6_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bak/archlog_20251030_6_0647h19u_6_1_1 tag=TAG20251030T101942
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/orapdb/arc2_15_1212165089.dbf thread=2 sequence=15
archived log file name=/home/oracle/orapdb/arc2_16_1212165089.dbf thread=2 sequence=16
archived log file name=/home/oracle/orapdb/arc2_17_1212165089.dbf thread=2 sequence=17
media recovery complete, elapsed time: 00:00:01
Finished recover at 30-OCT-25
RMAN> alter database open resetlogs;
Statement processed
####################
在新建数据库文件，控制文件是老的：
alter tablesapce users add datafile '+data' size 50M;
'/u01/app/oracle/product/19.0.0/db_1/dbs/c-2949910430-20251030-02'
export ORACLE_SID=pdb
startup nomount pfile='/tmp/1.txt'
restore controlfile from '/u01/app/oracle/product/19.0.0/db_1/dbs/c-2949910430-20251030-00';
alter database mount;
report schema;
RMAN> catalog start with '/home/oracle/bak/';
run{
set until scn 3081122;
recover database;
}
RMAN> run{
2> set until scn 3081122;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 30-OCT-25
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=15
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=16
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=17
channel ORA_DISK_1: reading from backup piece /home/oracle/bak/archlog_20251030_6_0647h19u_6_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bak/archlog_20251030_6_0647h19u_6_1_1 tag=TAG20251030T101942
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/orapdb/arc2_15_1212165089.dbf thread=2 sequence=15
archived log file name=/home/oracle/orapdb/arc2_16_1212165089.dbf thread=2 sequence=16
creating datafile file number=15 name=+DATA/PDB19C/DATAFILE/users.617.1215857907 <<<< 错误的位置被创建了。
archived log file name=/home/oracle/orapdb/arc2_16_1212165089.dbf thread=2 sequence=16
archived log file name=/home/oracle/orapdb/arc2_17_1212165089.dbf thread=2 sequence=17
media recovery complete, elapsed time: 00:00:01
Finished recover at 30-OCT-25
RMAN> report schema;
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** +DATA/PDB19C/DATAFILE/users.617.1215857907 <<< 文件恢复到了错误的位置。
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 231 TEMP 32767 +DATA/PDB19C/TEMPFILE/temp.1055.1212165181
2 201 PDB$SEED:TEMP 32767 +DATA/PDB19C/3F10E6C0271129FAE0630A39A8C03EC2/TEMPFILE/temp.336.1212168219
3 201 PDB01:TEMP 32767 +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/TEMPFILE/temp.281.1212171423
RMAN>
手工修复：
ALTER DATABASE CREATE DATAFILE '+DATA/PDB19C/DATAFILE/users.617.1215857907' as '/home/oracle/orapdb/users02.dbf' ;
RMAN> report schema;
using target database control file instead of recovery catalog
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /home/oracle/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /home/oracle/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /home/oracle/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /home/oracle/orapdb/users02.dbf
##############
backup database format '/home/oracle/bak2/db_%U.bak';
/u01/app/oracle/product/19.0.0/db_1/dbs/c-2949910430-20251030-05
backup format '/home/oracle/bak2/archlog_%T_%s_%U' archivelog all delete all input;
/u01/app/oracle/product/19.0.0/db_1/dbs/c-2949910430-20251030-07
export ORACLE_HOME=/u01/app/oracle/product/19nonrac/
export PATH=${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch:${PATH}
export ORACLE_SID=pdb
startup nomount pfile='/tmp/1.txt'
restore controlfile from '/home/oracle/bak2/c-2949910430-20251030-05';
alter database mount;
report schema;
crsosscheck backup;
delete expired;
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** +DATA/PDB19C/DATAFILE/system.1062.1212164913
3 950 SYSAUX *** +DATA/PDB19C/DATAFILE/sysaux.1061.1212164939
4 745 UNDOTBS1 *** +DATA/PDB19C/DATAFILE/undotbs1.1060.1212164963
5 480 PDB$SEED:SYSTEM *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.472.1212168195
6 440 PDB$SEED:SYSAUX *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.474.1212168195
7 5 USERS *** +DATA/PDB19C/DATAFILE/users.1059.1212164965
8 240 PDB$SEED:UNDOTBS1 *** +DATA/PDB19C/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.337.1212168195
9 75 UNDOTBS2 *** +DATA/PDB19C/DATAFILE/undotbs2.334.1212168617
10 480 PDB01:SYSTEM *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/system.301.1212171415
11 460 PDB01:SYSAUX *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/sysaux.303.1212171415
12 240 PDB01:UNDOTBS1 *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/undotbs1.307.1212171413
13 240 PDB01:UNDO_2 *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/undo_2.293.1212171635
14 20 PDB01:USERS *** +DATA/PDB19C/3F11A6CF625DCC1FE0630A39A8C0D9AE/DATAFILE/users.312.1212171505
15 100 USERS *** +DATA/PDB19C/DATAFILE/users.617.1215866209
alter database rename file '+DATA/PDB19C/ONLINELOG/group_2.333.1215866253' to '/home/oracle/orapdb/redo1.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_1.305.1215866251' to '/home/oracle/orapdb/redo2.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_3.1057.1215866253' to '/home/oracle/orapdb/redo3.log';
alter database rename file '+DATA/PDB19C/ONLINELOG/group_4.1056.1215866253' to '/home/oracle/orapdb/redo4.log';
run
{
set newname for database to '/u01/orapdb/%U.f';
restore database;
switch datafile all;
}
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /u01/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
RMAN> catalog start with '/home/oracle/bak2/';
run{
set until scn 3083753;
recover database;
}
RMAN> run{
2> set until scn 3083753;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 2025-10-30 14:20:14
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=1
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=2
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=3
channel ORA_DISK_1: reading from backup piece /home/oracle/bak2/archlog_20251030_19_0j47h9vq_19_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bak2/archlog_20251030_19_0j47h9vq_19_1_1 tag=TAG20251030T124750
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/orapdb/arc2_1_1215866251.dbf thread=2 sequence=1
archived log file name=/home/oracle/orapdb/arc2_2_1215866251.dbf thread=2 sequence=2
creating datafile file number=16 name=+DATA/PDB19C/DATAFILE/t1.575.1215866441
archived log file name=/home/oracle/orapdb/arc2_2_1215866251.dbf thread=2 sequence=2
archived log file name=/home/oracle/orapdb/arc2_3_1215866251.dbf thread=2 sequence=3
media recovery complete, elapsed time: 00:00:01
Finished recover at 2025-10-30 14:20:17
RMAN> report schema;
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /u01/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
16 100 T1 *** /home/oracle/orapdb/PDB19C/datafile/o1_mf_t1_nj60x0jx_.dbf <<<<文件位置错误了 OMF：*.db_create_file_dest='/home/oracle/orapdb'
Media Recovery Log /home/oracle/orapdb/arc2_2_1215866251.dbf
File #16 added to control file as 'UNNAMED00016'. Originally created as:
'+DATA/PDB19C/DATAFILE/t1.575.1215866441'
Errors with log /home/oracle/orapdb/arc2_2_1215866251.dbf
2025-10-30T14:20:16.459457+08:00
Errors in file /u01/app/oracle/diag/rdbms/pdb19c/pdb/trace/pdb_mz00_15624.trc:
ORA-01110: data file 1: '/u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f'
Recovery interrupted!
Recovery stopped due to failure in applying recovery marker (opcode 17.30).
Datafiles are recovered to a consistent state at change 3082994 but controlfile could be ahead of datafiles.
2025-10-30T14:20:16.519603+08:00
Media Recovery failed with error 1244
ORA-283 signalled during: alter database recover logfile '/home/oracle/orapdb/arc2_2_1215866251.dbf'...
WARNING: Clusterware not configured
WARNING: Clusterware not configured
2025-10-30T14:20:16.843325+08:00
Errors in file /u01/app/oracle/diag/rdbms/pdb19c/pdb/trace/pdb_mz00_15624.trc:
ORA-01110: data file 16: '/home/oracle/orapdb/PDB19C/datafile/o1_mf_t1_nj60x0jx_.dbf'
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list 16
Completed: alter database recover datafile list 16
alter database recover datafile list
1 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15
Completed: alter database recover datafile list
1 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15
alter database recover
if needed start until change 3083753 using backup controlfile
Media Recovery Start
2025-10-30T14:20:16.863075+08:00
Serial Media Recovery started
max_pdb is 3
ORA-279 signalled during: alter database recover
if needed start until change 3083753 using backup controlfile
...
alter database recover logfile '/home/oracle/orapdb/arc2_2_1215866251.dbf'
2025-10-30T14:20:16.924387+08:00
Media Recovery Log /home/oracle/orapdb/arc2_2_1215866251.dbf
Checker run found 1 new persistent data failures
ORA-279 signalled during: alter database recover logfile '/home/oracle/orapdb/arc2_2_1215866251.dbf'...
alter database recover logfile '/home/oracle/orapdb/arc2_3_1215866251.dbf'
2025-10-30T14:20:17.085635+08:00
Media Recovery Log /home/oracle/orapdb/arc2_3_1215866251.dbf
2025-10-30T14:20:17.110142+08:00
Incomplete Recovery applied until change 3083753 time 10/30/2025 12:47:50
################
关闭OMF:
RMAN> catalog start with '/home/oracle/bak2/';
run{
set until scn 3083753;
recover database;
}
RMAN> run{
2> set until scn 3083753;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 2025-10-30 14:32:18
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=1
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=2
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=3
channel ORA_DISK_1: reading from backup piece /home/oracle/bak2/archlog_20251030_19_0j47h9vq_19_1_1
channel ORA_DISK_1: piece handle=/home/oracle/bak2/archlog_20251030_19_0j47h9vq_19_1_1 tag=TAG20251030T124750
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/orapdb/arc2_1_1215866251.dbf thread=2 sequence=1
archived log file name=/home/oracle/orapdb/arc2_2_1215866251.dbf thread=2 sequence=2
creating datafile file number=16 name=+DATA/PDB19C/DATAFILE/t1.575.1215866441
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/30/2025 14:32:19
RMAN-20505: create datafile during recovery
ORA-01119: error in creating database file '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15374: invalid cluster configuration
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/home/oracle/orapdb/arc2_2_1215866251.dbf'
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 16: '+DATA/PDB19C/DATAFILE/t1.575.1215866441'
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /u01/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
16 0 T1 *** /u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00016
需要手工处理：
手工修复：
ALTER DATABASE CREATE DATAFILE '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/UNNAMED00016' as '/u01/orapdb/t01.dbf' ;
RMAN> report schema;
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name PDB19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1450 SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-1.f
3 950 SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-3.f
4 745 UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-4.f
5 480 PDB$SEED:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-5.f
6 440 PDB$SEED:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-6.f
7 5 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-7.f
8 240 PDB$SEED:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-8.f
9 75 UNDOTBS2 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS2_FNO-9.f
10 480 PDB01:SYSTEM *** /u01/orapdb/data_D-PDB19C_TS-SYSTEM_FNO-10.f
11 460 PDB01:SYSAUX *** /u01/orapdb/data_D-PDB19C_TS-SYSAUX_FNO-11.f
12 240 PDB01:UNDOTBS1 *** /u01/orapdb/data_D-PDB19C_TS-UNDOTBS1_FNO-12.f
13 240 PDB01:UNDO_2 *** /u01/orapdb/data_D-PDB19C_TS-UNDO_2_FNO-13.f
14 20 PDB01:USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-14.f
15 100 USERS *** /u01/orapdb/data_D-PDB19C_TS-USERS_FNO-15.f
16 100 T1 *** /u01/orapdb/t01.dbf <<<< 手工处理。
继续恢复：
RMAN> run{
2> set until scn 3083753;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 2025-10-30 14:34:29
using channel ORA_DISK_1
starting media recovery
archived log for thread 2 with sequence 2 is already on disk as file /home/oracle/orapdb/arc2_2_1215866251.dbf
archived log for thread 2 with sequence 3 is already on disk as file /home/oracle/orapdb/arc2_3_1215866251.dbf
archived log file name=/home/oracle/orapdb/arc2_2_1215866251.dbf thread=2 sequence=2
archived log file name=/home/oracle/orapdb/arc2_3_1215866251.dbf thread=2 sequence=3
media recovery complete, elapsed time: 00:00:01
Finished recover at 2025-10-30 14:34:30
RMAN>
测试版本：
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 30 14:35:09 2025
Version 19.22.0.0.0
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
