如上操作后，rman backup database报错如下：
RMAN-06056: could not access datafile 26
处理故障产生过程和处理办法：
1.模拟创建文件后删除offline drop
2.rm删除文件
3.delete删除字典记录file$
4.尝试rman备份，果然预期报错
5.把rm的文件创建回去alter database create datafile 26 as ‘/u01/app/oracle/oradata/ORCL/jyc/users10.dbf’;
6.测试rman备份正常。
rac测试正常
[oracle@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DGLISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.dgorcl.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.dw.db
1 ONLINE ONLINE rac1 Open,HOME=/oracle/ap
p/oracle/product/19c
/dbhome_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/oracle/ap
p/oracle/product/19c
/dbhome_1,STABLE
ora.dw.hisdb.svc
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
ora.integrated_office.db
1 OFFLINE OFFLINE STABLE
ora.orcl.db
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
[oracle@rac1 ~]$ echo $ORACLE_SID
dw1
[oracle@rac1 ~]$ ps -ef|grep ora_smon
oracle 8855 1 0 15:21 ? 00:00:00 ora_smon_dw1
oracle 11884 3128 0 15:22 pts/0 00:00:00 grep --color=auto ora_smon
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 15:22:24 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DBCENTER READ WRITE NO
4 A12345678901234567890123456789 MOUNTED
0
5 CDRPLATFORM READ WRITE NO
6 CDRADAPTER MOUNTED
7 A12345678901234567890123456789 MOUNTED
01
8 A12345678901234567890123456789 MOUNTED
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
012345678901234567890123456789
0124
9 A12345678901234567890123456789 MOUNTED
012345678901234567890123456789
0123
10 A MOUNTED
SQL> alter session set container=DBCENTER;
Session altered.
SQL> select file_id,file_name,ONLINE_STATUS from dba_data_files;
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
10
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/system.649.1056480121
SYSTEM
11
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/sysaux.650.1056480121
ONLINE
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
12
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undotbs1.644.1056480121
ONLINE
13
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undo_2.661.1056480135
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
ONLINE
14
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.652.1056480135
ONLINE
51
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.860.1120400973
ONLINE
52
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.861.1120400977
ONLINE
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
50
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/dbcenter.706.1056569261
ONLINE
60
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/test.865.1120403261
ONLINE
FILE_ID
----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
9 rows selected.
SQL> select tablespace_name,file_id,file_name,ONLINE_STATUS from dba_data_files;
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
SYSTEM 10
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/system.649.1056480121
SYSTEM
SYSAUX 11
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/sysaux.650.1056480121
ONLINE
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
UNDOTBS1 12
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undotbs1.644.1056480121
ONLINE
UNDO_2 13
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undo_2.661.1056480135
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
ONLINE
USERS 14
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.652.1056480135
ONLINE
USERS 51
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.860.1120400973
ONLINE
USERS 52
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.861.1120400977
ONLINE
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
DBCENTER 50
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/dbcenter.706.1056569261
ONLINE
TEST 60
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/test.865.1120403261
ONLINE
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
9 rows selected.
SQL> alter tablespace users add datafile 'DATA' size 1M;
Tablespace altered.
SQL> select tablespace_name,file_id,file_name,ONLINE_STATUS from dba_data_files where tablespace_name='USERS';
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
USERS 14
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.652.1056480135
ONLINE
USERS 51
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.860.1120400973
ONLINE
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
USERS 52
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.861.1120400977
ONLINE
USERS 68
/oracle/app/oracle/product/19c/dbhome_1/dbs/DATA
TABLESPACE_NAME FILE_ID
------------------------------ ----------
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
ONLINE
SQL> select file_name,ONLINE_STATUS from dba_data_files where FILE_ID=68;
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
/oracle/app/oracle/product/19c/dbhome_1/dbs/DATA
ONLINE
SQL> alter database datafile '/oracle/app/oracle/product/19c/dbhome_1/dbs/DATA' OFFLINE DROP;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA
Oldest online log sequence 129
Next log sequence to archive 130
Current log sequence 130
SQL> select file_name,ONLINE_STATUS from dba_data_files where FILE_ID=68;
FILE_NAME
--------------------------------------------------------------------------------
ONLINE_
-------
/oracle/app/oracle/product/19c/dbhome_1/dbs/DATA
RECOVER
SQL> select file#,status from v$datafile where file#=68;
FILE# STATUS
---------- -------
68 RECOVER
SQL> !rm /oracle/app/oracle/product/19c/dbhome_1/dbs/DATA
SQL> !ls -l /oracle/app/oracle/product/19c/dbhome_1/dbs/DATA
ls: cannot access /oracle/app/oracle/product/19c/dbhome_1/dbs/DATA: No such file or directory
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:26:41 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DW (DBID=3474552567)
RMAN> backup database;
Starting backup at 2024-06-13 15:26:46
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=233 instance=dw1 device type=DISK
RMAN-06169: could not read file header for datafile 68 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/13/2024 15:26:48
RMAN-06056: could not access datafile 68
RMAN> exit
Recovery Manager complete.
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 15:26:55 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 DBCENTER READ WRITE NO
4 A12345678901234567890123456789 MOUNTED
0
5 CDRPLATFORM READ WRITE NO
6 CDRADAPTER MOUNTED
7 A12345678901234567890123456789 MOUNTED
01
8 A12345678901234567890123456789 MOUNTED
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
012345678901234567890123456789
0124
9 A12345678901234567890123456789 MOUNTED
012345678901234567890123456789
0123
10 A MOUNTED
SQL> alter session set container=DBCENTER;
Session altered.
SQL> select file#,status from v$datafile where file#=68;
FILE# STATUS
---------- -------
68 RECOVER
SQL> delete from file$ where file#=68;
1 row deleted.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:28:17 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DW (DBID=3474552567)
RMAN> backup database;
Starting backup at 2024-06-13 15:28:25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=224 instance=dw1 device type=DISK
RMAN-06169: could not read file header for datafile 68 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/13/2024 15:28:26
RMAN-06056: could not access datafile 68
RMAN> exit
Recovery Manager complete.
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 15:28:30 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL> alter session set container=DBCENTER;
Session altered.
SQL> alter database create datafile 68 as '+DATA';
Database altered.
SQL> select file#,status from v$datafile where file#=68;
FILE# STATUS
---------- -------
68 RECOVER
SQL> select file#,status,name from v$datafile where file#=68;
FILE# STATUS
---------- -------
NAME
--------------------------------------------------------------------------------
68 RECOVER
+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.942.1171553363
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:29:47 2024
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DW (DBID=3474552567)
RMAN> backup database;
Starting backup at 2024-06-13 15:29:51
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=233 instance=dw1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/DW/DATAFILE/system.648.1056479069
input datafile file number=00004 name=+DATA/DW/DATAFILE/undotbs1.643.1056479109
input datafile file number=00003 name=+DATA/DW/DATAFILE/sysaux.668.1056479095
input datafile file number=00009 name=+DATA/DW/DATAFILE/undotbs2.667.1056479729
input datafile file number=00057 name=+DATA/DW/DATAFILE/test.862.1120403003
input datafile file number=00007 name=+DATA/DW/DATAFILE/users.657.1056479111
input datafile file number=00059 name=+DATA/DW/DATAFILE/test.864.1120403025
input datafile file number=00058 name=+DATA/DW/DATAFILE/test.863.1120403023
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:29:52
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:30:07
piece handle=/oracle/app/oracle/product/19c/dbhome_1/dbs/3n2t8v3g_1_1 tag=TAG20240613T152952 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/sysaux.650.1056480121
input datafile file number=00010 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/system.649.1056480121
input datafile file number=00012 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undotbs1.644.1056480121
input datafile file number=00013 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/undo_2.661.1056480135
input datafile file number=00068 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.942.1171553363
input datafile file number=00052 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.861.1120400977
input datafile file number=00051 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.860.1120400973
input datafile file number=00014 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/users.652.1056480135
input datafile file number=00050 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/dbcenter.706.1056569261
input datafile file number=00060 name=+DATA/DW/B40FCB825F88345DE053B634A8C0D6E5/DATAFILE/test.865.1120403261
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:30:08
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:30:15
piece handle=/oracle/app/oracle/product/19c/dbhome_1/dbs/3o2t8v3v_1_1 tag=TAG20240613T152952 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00016 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/sysaux.656.1056493151
input datafile file number=00015 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/system.645.1056493151
input datafile file number=00017 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/undotbs1.646.1056493151
input datafile file number=00018 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/undo_2.660.1056493151
input datafile file number=00019 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/users.662.1056493151
input datafile file number=00061 name=+DATA/DW/B412D1E327904CCBE053B534A8C003EB/DATAFILE/test.866.1120403309
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:30:15
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:30:22
piece handle=/oracle/app/oracle/product/19c/dbhome_1/dbs/3p2t8v47_1_1 tag=TAG20240613T152952 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00036 name=+DATA/DW/B412E5F265BD55CAE053B534A8C0CB7D/DATAFILE/sysaux.692.1056493625
input datafile file number=00035 name=+DATA/DW/B412E5F265BD55CAE053B534A8C0CB7D/DATAFILE/system.691.1056493625
input datafile file number=00037 name=+DATA/DW/B412E5F265BD55CAE053B534A8C0CB7D/DATAFILE/undotbs1.689.1056493625
input datafile file number=00038 name=+DATA/DW/B412E5F265BD55CAE053B534A8C0CB7D/DATAFILE/undo_2.690.1056493625
input datafile file number=00039 name=+DATA/DW/B412E5F265BD55CAE053B534A8C0CB7D/DATAFILE/users.688.1056493625
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:30:22
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:30:29
piece handle=/oracle/app/oracle/product/19c/dbhome_1/dbs/3q2t8v4e_1_1 tag=TAG20240613T152952 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00041 name=+DATA/DW/B412E5F265BF55CAE053B534A8C0CB7D/DATAFILE/sysaux.698.1056493701
input datafile file number=00040 name=+DATA/DW/B412E5F265BF55CAE053B534A8C0CB7D/DATAFILE/system.697.1056493701
input datafile file number=00042 name=+DATA/DW/B412E5F265BF55CAE053B534A8C0CB7D/DATAFILE/undotbs1.695.1056493701
input datafile file number=00043 name=+DATA/DW/B412E5F265BF55CAE053B534A8C0CB7D/DATAFILE/undo_2.696.1056493701
input datafile file number=00044 name=+DATA/DW/B412E5F265BF55CAE053B534A8C0CB7D/DATAFILE/users.694.1056493701
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:30:29
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:30:32
piece handle=/oracle/app/oracle/product/19c/dbhome_1/dbs/3r2t8v4l_1_1 tag=TAG20240613T152952 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00046 name=+DATA/DW/B412E5F265C155CAE053B534A8C0CB7D/DATAFILE/sysaux.704.1056493713
input datafile file number=00045 name=+DATA/DW/B412E5F265C155CAE053B534A8C0CB7D/DATAFILE/system.703.1056493713
input datafile file number=00047 name=+DATA/DW/B412E5F265C155CAE053B534A8C0CB7D/DATAFILE/undotbs1.701.1056493713
input datafile file number=00048 name=+DATA/DW/B412E5F265C155CAE053B534A8C0CB7D/DATAFILE/undo_2.702.1056493713
input datafile file number=00049 name=+DATA/DW/B412E5F265C155CAE053B534A8C0CB7D/DATAFILE/users.700.1056493713
单实例测试正常：
SQL> set time on
14:51:56 SQL> alter tablespace users add datafile '/u01/app/oracle/oradata/ORCL/jyc/users10.dbf' size 2M;
Tablespace altered.
14:52:15 SQL> desc dba_data_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
LOST_WRITE_PROTECT VARCHAR2(7)
14:52:49 SQL> select file_id from dba_data_files where TABLESPACE_NAME='USERS' and file_name='/u01/app/oracle/oradata/ORCL/jyc/users10.dbf';
FILE_ID
----------
26
14:53:05 SQL> select file_id,status from dba_data_files;
FILE_ID STATUS
---------- ------------------
1 AVAILABLE
3 AVAILABLE
4 AVAILABLE
7 AVAILABLE
26 AVAILABLE
14:53:21 SQL> alter database datafile '/u01/app/oracle/oradata/ORCL/jyc/users10.dbf' offline drop;
Database altered.
14:53:42 SQL> select file_id,status from dba_data_files;
FILE_ID STATUS
---------- ------------------
1 AVAILABLE
3 AVAILABLE
4 AVAILABLE
7 AVAILABLE
26 AVAILABLE
14:53:46 SQL> select file_id,status,ONLINE_STATUS from dba_data_files;
FILE_ID STATUS ONLINE_STATUS
---------- ------------------ --------------
1 AVAILABLE SYSTEM
3 AVAILABLE ONLINE
4 AVAILABLE ONLINE
7 AVAILABLE ONLINE
26 AVAILABLE RECOVER
14:54:02 SQL> delete from file$ where file#=26;
1 row deleted.
14:54:41 SQL> commit;
Commit complete.
14:54:43 SQL> select file_id,status,ONLINE_STATUS from dba_data_files;
FILE_ID STATUS ONLINE_STATUS
---------- ------------------ --------------
7 AVAILABLE ONLINE
4 AVAILABLE ONLINE
1 AVAILABLE SYSTEM
3 AVAILABLE ONLINE
14:54:46 SQL> desc v$datafile;
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE# NUMBER
CREATION_CHANGE# NUMBER
CREATION_TIME DATE
TS# NUMBER
RFILE# NUMBER
STATUS VARCHAR2(7)
ENABLED VARCHAR2(10)
CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME DATE
UNRECOVERABLE_CHANGE# NUMBER
UNRECOVERABLE_TIME DATE
LAST_CHANGE# NUMBER
LAST_TIME DATE
OFFLINE_CHANGE# NUMBER
ONLINE_CHANGE# NUMBER
ONLINE_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
CREATE_BYTES NUMBER
BLOCK_SIZE NUMBER
NAME VARCHAR2(513)
PLUGGED_IN NUMBER
BLOCK1_OFFSET NUMBER
AUX_NAME VARCHAR2(513)
FIRST_NONLOGGED_SCN NUMBER
FIRST_NONLOGGED_TIME DATE
FOREIGN_DBID NUMBER
FOREIGN_CREATION_CHANGE# NUMBER
FOREIGN_CREATION_TIME DATE
PLUGGED_READONLY VARCHAR2(3)
PLUGIN_CHANGE# NUMBER
PLUGIN_RESETLOGS_CHANGE# NUMBER
PLUGIN_RESETLOGS_TIME DATE
CON_ID NUMBER
14:54:56 SQL> select file# from v$datafile where file#=26;
FILE#
----------
26
14:55:21 SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 OEM READ WRITE NO
4 JYC READ WRITE NO
14:55:28 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
14:56:10 SQL> startup
ORACLE instance started.
Total System Global Area 5368705768 bytes
Fixed Size 9147112 bytes
Variable Size 1694498816 bytes
Database Buffers 3640655872 bytes
Redo Buffers 24403968 bytes
Database mounted.
Database opened.
14:56:25 SQL> select file# from v$datafile where file#=26;
FILE#
----------
26
14:56:29 SQL> select file_id,status,ONLINE_STATUS from dba_data_files;
FILE_ID STATUS ONLINE_STATUS
---------- ------------------ --------------
7 AVAILABLE ONLINE
4 AVAILABLE ONLINE
1 AVAILABLE SYSTEM
3 AVAILABLE ONLINE
14:56:35 SQL> select file#,status from v$datafile where file#=26;
FILE# STATUS
---------- --------------
26 RECOVER
14:57:11 SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 14:57:25 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> backup database;
Starting backup at 2024-06-13 14:57:30
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=628 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/oem/mgmt.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/oem/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/oem/undotbs01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_ecm_depot1.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/oem/sysaux01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_deepdive.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/oem/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 14:57:31
channel ORA_DISK_1: finished piece 1 at 2024-06-13 14:57:56
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/0r2t8t6r_1_1 tag=TAG20240613T145731 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
input datafile file number=00026 name=/u01/app/oracle/oradata/ORCL/jyc/users10.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 14:57:56
channel ORA_DISK_1: finished piece 1 at 2024-06-13 14:58:11
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/0s2t8t7k_1_1 tag=TAG20240613T145731 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=/u01/app/oracle/oradata/ORCL/jyc/undotbs01.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/ORCL/jyc/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORCL/jyc/system01.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/ORCL/jyc/users01.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/ORCL/jyc/ogg.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/ORCL/jyc/users02.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/ORCL/jyc/users03.dbf
input datafile file number=00023 name=/u01/app/oracle/oradata/ORCL/jyc/users04.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/ORCL/jyc/users05.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/ORCL/jyc/users06.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 14:58:11
channel ORA_DISK_1: finished piece 1 at 2024-06-13 14:58:14
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/0t2t8t83_1_1 tag=TAG20240613T145731 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 14:58:14
channel ORA_DISK_1: finished piece 1 at 2024-06-13 14:58:17
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/0u2t8t86_1_1 tag=TAG20240613T145731 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2024-06-13 14:58:17
Starting Control File and SPFILE Autobackup at 2024-06-13 14:58:17
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/c-1580897135-20240613-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2024-06-13 14:58:18
RMAN> exit
Recovery Manager complete.
[oracle@oem ~]$ rm /u01/app/oracle/oradata/ORCL/jyc/users10.dbf
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 14:58:30 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> backup database;
Starting backup at 2024-06-13 14:58:39
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
RMAN-06169: could not read file header for datafile 26 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/13/2024 14:58:39
RMAN-06056: could not access datafile 26
RMAN> exit
Recovery Manager complete.
[oracle@oem ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 14:58:50 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select file#,name,status from v$datafile where file#=26;
FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
--------------
26
/u01/app/oracle/oradata/ORCL/jyc/users10.dbf
RECOVER
SQL> alter database create datafile 26 as '/u01/app/oracle/oradata/ORCL/jyc/users10.dbf';
Database altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:00:32 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> exit
Recovery Manager complete.
ls [oracle@oem ~]$ ls -l /u01/app/oracle/oradata/ORCL/jyc/users10.dbf
-rw-r----- 1 oracle oinstall 2105344 Jun 13 15:00 /u01/app/oracle/oradata/ORCL/jyc/users10.dbf
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:00:51 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> backup database;
Starting backup at 2024-06-13 15:01:18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=943 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/oem/mgmt.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/oem/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/oem/undotbs01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_ecm_depot1.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/oem/sysaux01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_deepdive.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/oem/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:01:18
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:01:33
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/102t8tdu_1_1 tag=TAG20240613T150118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
input datafile file number=00026 name=/u01/app/oracle/oradata/ORCL/jyc/users10.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:01:33
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:01:40
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/112t8ted_1_1 tag=TAG20240613T150118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=/u01/app/oracle/oradata/ORCL/jyc/undotbs01.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/ORCL/jyc/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORCL/jyc/system01.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/ORCL/jyc/users01.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/ORCL/jyc/ogg.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/ORCL/jyc/users02.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/ORCL/jyc/users03.dbf
input datafile file number=00023 name=/u01/app/oracle/oradata/ORCL/jyc/users04.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/ORCL/jyc/users05.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/ORCL/jyc/users06.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:01:40
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:01:43
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/122t8tek_1_1 tag=TAG20240613T150118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:01:43
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:01:46
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/132t8ten_1_1 tag=TAG20240613T150118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2024-06-13 15:01:46
Starting Control File and SPFILE Autobackup at 2024-06-13 15:01:46
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/c-1580897135-20240613-01 comment=NONE
Finished Control File and SPFILE Autobackup at 2024-06-13 15:01:48
RMAN> select file#,name,status from v$datafile where file#=26;
FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
-------
26
/u01/app/oracle/oradata/ORCL/jyc/users10.dbf
RECOVER
RMAN> exit
Recovery Manager complete.
[oracle@oem ~]$ rm /u01/app/oracle/oradata/ORCL/jyc/users10.dbf
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:02:50 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> backup database;
Starting backup at 2024-06-13 15:03:02
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
RMAN-06169: could not read file header for datafile 26 error reason 4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/13/2024 15:03:02
RMAN-06056: could not access datafile 26
RMAN> exit
Recovery Manager complete.
[oracle@oem ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 15:03:11 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter database create datafile 26 as '/u01/app/oracle/oradata/ORCL/jyc/users-bad.dbf';
Database altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oem ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 13 15:03:32 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select file#,name,status from v$datafile where file#=26;
FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS
--------------
26
/u01/app/oracle/oradata/ORCL/jyc/users-bad.dbf
RECOVER
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oem ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Jun 13 15:03:41 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1580897135)
RMAN> backup database;
Starting backup at 2024-06-13 15:03:51
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=933 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/oem/mgmt.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/oem/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/oem/undotbs01.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_ecm_depot1.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/oem/sysaux01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/ORCL/oem/mgmt_deepdive.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/oem/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:03:51
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:04:06
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/152t8tin_1_1 tag=TAG20240613T150351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
input datafile file number=00026 name=/u01/app/oracle/oradata/ORCL/jyc/users-bad.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:04:07
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:04:14
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/162t8tj6_1_1 tag=TAG20240613T150351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00018 name=/u01/app/oracle/oradata/ORCL/jyc/undotbs01.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/ORCL/jyc/sysaux01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORCL/jyc/system01.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/ORCL/jyc/users01.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/ORCL/jyc/ogg.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/ORCL/jyc/users02.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/ORCL/jyc/users03.dbf
input datafile file number=00023 name=/u01/app/oracle/oradata/ORCL/jyc/users04.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/ORCL/jyc/users05.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/ORCL/jyc/users06.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:04:14
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:04:17
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/172t8tje_1_1 tag=TAG20240613T150351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2024-06-13 15:04:17
channel ORA_DISK_1: finished piece 1 at 2024-06-13 15:04:20
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/182t8tjh_1_1 tag=TAG20240613T150351 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2024-06-13 15:04:20
Starting Control File and SPFILE Autobackup at 2024-06-13 15:04:20
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/c-1580897135-20240613-02 comment=NONE
Finished Control File and SPFILE Autobackup at 2024-06-13 15:04:21
RMAN>
最后修改时间：2024-06-13 15:41:58
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
