ORA-01113异常处理_一键刷新Oracle数据文件scn

来源：这里教程网时间：2026-03-03 16:08:13 作者：

### 1. 异常介绍
```sql
ORA-01113: file 28 needs media recovery
ORA-01110: data file 28: '/<path>/<filename>.dbf'
在Oracle数据库启动过程中如果遇到ORA-01113/ORA-01110报错，造成数据库无法正常启动，日志文件可用时使用日志文件进行正常恢复，当日志文件损坏或所需日志被删除无法通过常规手段恢复时，通常使用bbed工具刷新数据文件头scn，使所有数据文件scn一致，成功启动数据库，使用bbed工具修复存在以下问题，
1、需要bbed工具非常熟悉
2、需要对Oracle数据块结构非常熟悉
3、需要对字节序熟悉
4、需要非常细心，逐字节逐文件修改，耗时且容易出错，
基于以上原因，本文使用工具一键刷新Oracle数据文件scn，操作过程如下所示，
```
### 2. 异常演示
```sql
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size		    2252704 bytes
Variable Size		  385876064 bytes
Database Buffers	  805306368 bytes
Redo Buffers		    9121792 bytes
Database mounted.
SQL> 
SQL> 
SQL> set linesize 200 pagesize 200
col ERROR for a10
col NAME for a30
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select CHECKPOINT_CHANGE# from v$database;
select FILE#,CHECKPOINT_CHANGE#,CHECKPOINT_TIME from v$datafile;
select FILE#,name,STATUSSQL> SQL> SQL> 
Session altered.
SQL> ,TS#,RFILE#,RESETLOGS_CHANGE#,RESETLOGS_TIME,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,CHECKPOINT_COUNT,status,ERROR,RECOVER,FUZZY from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
	   2977967
SQL> 
     FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME
---------- ------------------ -------------------
	 1	      2977967 2020-04-05 07:36:00
	 2	      2977967 2020-04-05 07:36:00
	 3	      2977967 2020-04-05 07:36:00
	 4	      2977967 2020-04-05 07:36:00
	 5	      2977967 2020-04-05 07:36:00
	 6	      2977967 2020-04-05 07:36:00
	 7	      2977967 2020-04-05 07:36:00
	 8	      2977967 2020-04-05 07:36:00
	 9	      2977967 2020-04-05 07:36:00
	10	      2977967 2020-04-05 07:36:00
	11	      2977967 2020-04-05 07:36:00
	12	      2977967 2020-04-05 07:36:00
	13	      2977967 2020-04-05 07:36:00
	14	      2977967 2020-04-05 07:36:00
14 rows selected.
SQL> 
     FILE# NAME 			  STATUS	 TS#	 RFILE# RESETLOGS_CHANGE# RESETLOGS_TIME      CHECKPOINT_CHANGE# CHECKPOINT_TIME     CHECKPOINT_COUNT STATUS  ERROR	 REC FUZ
---------- ------------------------------ ------- ---------- ---------- ----------------- ------------------- ------------------ ------------------- ---------------- ------- ---------- --- ---
	 1 /oradata/epmsn/system01.dbf	  ONLINE	   0	      1 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  421 ONLINE		 NO  YES
	 2 /oradata/epmsn/sysaux01.dbf	  ONLINE	   1	      2 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  421 ONLINE		 NO  YES
	 3 /oradata/epmsn/undotbs01.dbf   ONLINE	   2	      3 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  342 ONLINE		 NO  YES
	 4 /oradata/epmsn/users01.dbf	  ONLINE	   4	      4 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  420 ONLINE		 NO  YES
	 5 /oradata/epmsn/test1.dbf	  ONLINE	   6	      5 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  202 ONLINE		 NO  YES
	 6 /oradata/epmsn/test2_1.dbf	  ONLINE	   7	      6 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		  155 ONLINE		 YES YES
	 7 /oradata/epmsn/test3_1.dbf	  ONLINE	   8	      7 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		   23 ONLINE		 YES YES
	 8 /oradata/epmsn/test4_1.dbf	  ONLINE	   9	      8 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		   23 ONLINE		 YES YES
	 9 /oradata/epmsn/test5_1.dbf	  ONLINE	  10	      9 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	10 /oradata/epmsn/test6_1.dbf	  ONLINE	  11	     10 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	11 /oradata/epmsn/test7_1.dbf	  ONLINE	  12	     11 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	12 /oradata/epmsn/test8_1.dbf	  ONLINE	  13	     12 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
	13 /oradata/epmsn/test9_1.dbf	  ONLINE	  14	     13 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
	14 /oradata/epmsn/test10_1.dbf	  ONLINE	  15	     14 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
14 rows selected.
SQL> select group#,thread#,sequence#,first_change#,next_change# from v$log;
    GROUP#    THREAD#  SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
---------- ---------- ---------- ------------- ------------
	 1	    1	      25       2977961	    2977964
	 3	    1	      27       2977967	 2.8147E+14
	 2	    1	      26       2977964	    2977967
SQL> archive log list;
Database log mode	       No Archive Mode
Automatic archival	       Disabled
Archive destination	       /arch1/
Oldest online log sequence     25
Current log sequence	       27
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@sourcedb backup]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 5 07:40:15 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: EPMSN (DBID=2733498539, not open)
RMAN> recover datafile 6;
Starting recover at 05-APR-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
starting media recovery
archived log for thread 1 with sequence 25 is already on disk as file /oradata/epmsn/redo01.log
archived log for thread 1 with sequence 26 is already on disk as file /oradata/epmsn/redo02.log
archived log for thread 1 with sequence 27 is already on disk as file /oradata/epmsn/redo03.log
RMAN-08187: WARNING: media recovery until SCN 2898651 complete
Finished recover at 05-APR-20
RMAN> exit

Recovery Manager complete.
[oracle@sourcedb backup]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 5 07:40:36 2020
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set linesize 200 pagesize 200
col ERROR for a10
col NAME for a30
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select CHECKPOINT_CHANGE# from v$database;
select FILE#,CHECKPOINT_CHANGE#,CHECKPOINT_TIME from v$datafile;
select FILE#,name,STATUSSQL> SQL> SQL> 
Session altered.
SQL> 
CHECKPOINT_CHANGE#
------------------
	   2977967
SQL> ,TS#,RFILE#,RESETLOGS_CHANGE#,RESETLOGS_TIME,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,CHECKPOINT_COUNT,status,ERROR,RECOVER,FUZZY from v$datafile_header;
     FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME
---------- ------------------ -------------------
	 1	      2977967 2020-04-05 07:36:00
	 2	      2977967 2020-04-05 07:36:00
	 3	      2977967 2020-04-05 07:36:00
	 4	      2977967 2020-04-05 07:36:00
	 5	      2977967 2020-04-05 07:36:00
	 6	      2977967 2020-04-05 07:36:00
	 7	      2977967 2020-04-05 07:36:00
	 8	      2977967 2020-04-05 07:36:00
	 9	      2977967 2020-04-05 07:36:00
	10	      2977967 2020-04-05 07:36:00
	11	      2977967 2020-04-05 07:36:00
	12	      2977967 2020-04-05 07:36:00
	13	      2977967 2020-04-05 07:36:00
	14	      2977967 2020-04-05 07:36:00
14 rows selected.
SQL> 
     FILE# NAME 			  STATUS	 TS#	 RFILE# RESETLOGS_CHANGE# RESETLOGS_TIME      CHECKPOINT_CHANGE# CHECKPOINT_TIME     CHECKPOINT_COUNT STATUS  ERROR	 REC FUZ
---------- ------------------------------ ------- ---------- ---------- ----------------- ------------------- ------------------ ------------------- ---------------- ------- ---------- --- ---
	 1 /oradata/epmsn/system01.dbf	  ONLINE	   0	      1 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  421 ONLINE		 NO  YES
	 2 /oradata/epmsn/sysaux01.dbf	  ONLINE	   1	      2 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  421 ONLINE		 NO  YES
	 3 /oradata/epmsn/undotbs01.dbf   ONLINE	   2	      3 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  342 ONLINE		 NO  YES
	 4 /oradata/epmsn/users01.dbf	  ONLINE	   4	      4 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  420 ONLINE		 NO  YES
	 5 /oradata/epmsn/test1.dbf	  ONLINE	   6	      5 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  202 ONLINE		 NO  YES
	 6 /oradata/epmsn/test2_1.dbf	  ONLINE	   7	      6 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		  155 ONLINE		 YES YES
	 7 /oradata/epmsn/test3_1.dbf	  ONLINE	   8	      7 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		   23 ONLINE		 YES YES
	 8 /oradata/epmsn/test4_1.dbf	  ONLINE	   9	      8 	  2878267 2020-04-05 07:29:12		 2898651 2020-04-05 07:34:39		   23 ONLINE		 YES YES
	 9 /oradata/epmsn/test5_1.dbf	  ONLINE	  10	      9 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	10 /oradata/epmsn/test6_1.dbf	  ONLINE	  11	     10 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	11 /oradata/epmsn/test7_1.dbf	  ONLINE	  12	     11 	  2878267 2020-04-05 07:29:12		 2918657 2020-04-05 07:35:03		   26 ONLINE		 YES YES
	12 /oradata/epmsn/test8_1.dbf	  ONLINE	  13	     12 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
	13 /oradata/epmsn/test9_1.dbf	  ONLINE	  14	     13 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
	14 /oradata/epmsn/test10_1.dbf	  ONLINE	  15	     14 	  2878267 2020-04-05 07:29:12		 2938030 2020-04-05 07:35:27		   29 ONLINE		 YES YES
14 rows selected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/oradata/epmsn/test2_1.dbf'

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@sourcedb backup]$
```

### 3. 刷新单个数据文件scn 
```sql
[oracle@sourcedb xdul]$ ./xdul
xdul: Data Unload for Oracle version 1.1.1
Copyright(c) 2020 orastar.All rights reserved.
Wechat: xidoublestr
Email: 634025070@qq.com
loading default config.......
load config file 'config.txt' successful
loading default control file ......

ts#	fn	rfn	bsize	blocks	filename                  	kscnbas_484	kcvcptim_496	kcvfhrlc_112	kscnbas_116
---- ---- ---- ----- -------- -------------------------------------------- -------- -------- -------- --------
0	1	1	8192	97280	/oradata/epmsn/system01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
1	2	2	8192	90880	/oradata/epmsn/sysaux01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
2	3	3	8192	8960	/oradata/epmsn/undotbs01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
4	4	4	8192	640	/oradata/epmsn/users01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
6	5	5	8192	12800	/oradata/epmsn/test1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
7	6	6	8192	6400	/oradata/epmsn/test2_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
8	7	7	8192	6400	/oradata/epmsn/test3_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
9	8	8	8192	6400	/oradata/epmsn/test4_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
10	9	9	8192	6400	/oradata/epmsn/test5_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
11	10	10	8192	6400	/oradata/epmsn/test6_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
12	11	11	8192	6400	/oradata/epmsn/test7_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
13	12	12	8192	6400	/oradata/epmsn/test8_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
14	13	13	8192	6400	/oradata/epmsn/test9_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
15	14	14	8192	6400	/oradata/epmsn/test10_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
load control file 'control.txt' successful
XDUL>XDUL>
XDUL>
XDUL>
XDUL>pdfh
ts#	fn	rfn	bsize	blocks	filename                  	kscnbas_484	kcvcptim_496	kcvfhrlc_112	kscnbas_116
---- ---- ---- ----- -------- -------------------------------------------- -------- -------- -------- --------
0	1	1	8192	97280	/oradata/epmsn/system01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
1	2	2	8192	90880	/oradata/epmsn/sysaux01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
2	3	3	8192	8960	/oradata/epmsn/undotbs01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
4	4	4	8192	640	/oradata/epmsn/users01.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
6	5	5	8192	12800	/oradata/epmsn/test1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
7	6	6	8192	6400	/oradata/epmsn/test2_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
8	7	7	8192	6400	/oradata/epmsn/test3_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
9	8	8	8192	6400	/oradata/epmsn/test4_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
10	9	9	8192	6400	/oradata/epmsn/test5_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
11	10	10	8192	6400	/oradata/epmsn/test6_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
12	11	11	8192	6400	/oradata/epmsn/test7_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
13	12	12	8192	6400	/oradata/epmsn/test8_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
14	13	13	8192	6400	/oradata/epmsn/test9_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
15	14	14	8192	6400	/oradata/epmsn/test10_1.dbf      	2d70af      	3dce0c60      	3dce0ac8      	2beb3b
XDUL>exit
[oracle@sourcedb xdul]$ 
```
### 5. 恢复结果
```sql
[oracle@sourcedb xdul]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 5 07:43:09 2020
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size		    2252704 bytes
Variable Size		  385876064 bytes
Database Buffers	  805306368 bytes
Redo Buffers		    9121792 bytes
Database mounted.
SQL> set linesize 200 pagesize 200
col ERROR for a10
col NAME for a30
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select CHECKPOINT_CHANGE# from v$database;
select FILE#,CHECKPOINT_CHANGE#,CHECKPOINT_TIME from v$datafile;
select FILE#,name,STATUSSQL> SQL> SQL> 
Session altered.
SQL> ,TS#,RFILE#,RESETLOGS_CHANGE#,RESETLOGS_TIME,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,CHECKPOINT_COUNT,status,ERROR,RECOVER,FUZZY from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
	   2977967
SQL> 
     FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME
---------- ------------------ -------------------
	 1	      2977967 2020-04-05 07:36:00
	 2	      2977967 2020-04-05 07:36:00
	 3	      2977967 2020-04-05 07:36:00
	 4	      2977967 2020-04-05 07:36:00
	 5	      2977967 2020-04-05 07:36:00
	 6	      2977967 2020-04-05 07:36:00
	 7	      2977967 2020-04-05 07:36:00
	 8	      2977967 2020-04-05 07:36:00
	 9	      2977967 2020-04-05 07:36:00
	10	      2977967 2020-04-05 07:36:00
	11	      2977967 2020-04-05 07:36:00
	12	      2977967 2020-04-05 07:36:00
	13	      2977967 2020-04-05 07:36:00
	14	      2977967 2020-04-05 07:36:00
14 rows selected.
SQL> 
     FILE# NAME 			  STATUS	 TS#	 RFILE# RESETLOGS_CHANGE# RESETLOGS_TIME      CHECKPOINT_CHANGE# CHECKPOINT_TIME     CHECKPOINT_COUNT STATUS  ERROR	 REC FUZ
---------- ------------------------------ ------- ---------- ---------- ----------------- ------------------- ------------------ ------------------- ---------------- ------- ---------- --- ---
	 1 /oradata/epmsn/system01.dbf	  ONLINE	   0	      1 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  422 ONLINE		 NO  YES
	 2 /oradata/epmsn/sysaux01.dbf	  ONLINE	   1	      2 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  422 ONLINE		 NO  YES
	 3 /oradata/epmsn/undotbs01.dbf   ONLINE	   2	      3 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  343 ONLINE		 NO  YES
	 4 /oradata/epmsn/users01.dbf	  ONLINE	   4	      4 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  421 ONLINE		 NO  YES
	 5 /oradata/epmsn/test1.dbf	  ONLINE	   6	      5 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  203 ONLINE		 NO  YES
	 6 /oradata/epmsn/test2_1.dbf	  ONLINE	   7	      6 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		  155 ONLINE		 YES YES
	 7 /oradata/epmsn/test3_1.dbf	  ONLINE	   8	      7 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   23 ONLINE		 YES YES
	 8 /oradata/epmsn/test4_1.dbf	  ONLINE	   9	      8 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   23 ONLINE		 YES YES
	 9 /oradata/epmsn/test5_1.dbf	  ONLINE	  10	      9 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   26 ONLINE		 YES YES
	10 /oradata/epmsn/test6_1.dbf	  ONLINE	  11	     10 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   26 ONLINE		 YES YES
	11 /oradata/epmsn/test7_1.dbf	  ONLINE	  12	     11 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   26 ONLINE		 YES YES
	12 /oradata/epmsn/test8_1.dbf	  ONLINE	  13	     12 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   29 ONLINE		 YES YES
	13 /oradata/epmsn/test9_1.dbf	  ONLINE	  14	     13 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   29 ONLINE		 YES YES
	14 /oradata/epmsn/test10_1.dbf	  ONLINE	  15	     14 	  2878267 2020-04-05 07:29:12		 2977967 2020-04-05 07:36:00		   29 ONLINE		 YES YES
14 rows selected.
SQL> recover database;
Media recovery complete.
SQL> set linesize 200 pagesize 200
col ERROR for a10
col NAME for a30
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select CHECKPOINT_CHANGE# from v$database;
select FILE#,CHECKPOINT_CHANGE#,CHECKPOINT_TIME from v$datafile;
select FILE#,name,STATUSSQL> SQL> SQL> 
Session altered.
SQL> 
CHECKPOINT_CHANGE#
------------------
	   2977967
SQL> ,TS#,RFILE#,RESETLOGS_CHANGE#,RESETLOGS_TIME,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,CHECKPOINT_COUNT,status,ERROR,RECOVER,FUZZY from v$datafile_header;
     FILE# CHECKPOINT_CHANGE# CHECKPOINT_TIME
---------- ------------------ -------------------
	 1	      2997968 2020-04-05 07:36:00
	 2	      2997968 2020-04-05 07:36:00
	 3	      2997968 2020-04-05 07:36:00
	 4	      2997968 2020-04-05 07:36:00
	 5	      2997968 2020-04-05 07:36:00
	 6	      2997968 2020-04-05 07:36:00
	 7	      2997968 2020-04-05 07:36:00
	 8	      2997968 2020-04-05 07:36:00
	 9	      2997968 2020-04-05 07:36:00
	10	      2997968 2020-04-05 07:36:00
	11	      2997968 2020-04-05 07:36:00
	12	      2997968 2020-04-05 07:36:00
	13	      2997968 2020-04-05 07:36:00
	14	      2997968 2020-04-05 07:36:00
14 rows selected.
SQL> 
     FILE# NAME 			  STATUS	 TS#	 RFILE# RESETLOGS_CHANGE# RESETLOGS_TIME      CHECKPOINT_CHANGE# CHECKPOINT_TIME     CHECKPOINT_COUNT STATUS  ERROR	 REC FUZ
---------- ------------------------------ ------- ---------- ---------- ----------------- ------------------- ------------------ ------------------- ---------------- ------- ---------- --- ---
	 1 /oradata/epmsn/system01.dbf	  ONLINE	   0	      1 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  423 ONLINE		 NO  NO
	 2 /oradata/epmsn/sysaux01.dbf	  ONLINE	   1	      2 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  423 ONLINE		 NO  NO
	 3 /oradata/epmsn/undotbs01.dbf   ONLINE	   2	      3 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  344 ONLINE		 NO  NO
	 4 /oradata/epmsn/users01.dbf	  ONLINE	   4	      4 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  422 ONLINE		 NO  NO
	 5 /oradata/epmsn/test1.dbf	  ONLINE	   6	      5 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  204 ONLINE		 NO  NO
	 6 /oradata/epmsn/test2_1.dbf	  ONLINE	   7	      6 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		  168 ONLINE		 NO  NO
	 7 /oradata/epmsn/test3_1.dbf	  ONLINE	   8	      7 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	 8 /oradata/epmsn/test4_1.dbf	  ONLINE	   9	      8 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	 9 /oradata/epmsn/test5_1.dbf	  ONLINE	  10	      9 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	10 /oradata/epmsn/test6_1.dbf	  ONLINE	  11	     10 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	11 /oradata/epmsn/test7_1.dbf	  ONLINE	  12	     11 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	12 /oradata/epmsn/test8_1.dbf	  ONLINE	  13	     12 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	13 /oradata/epmsn/test9_1.dbf	  ONLINE	  14	     13 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
	14 /oradata/epmsn/test10_1.dbf	  ONLINE	  15	     14 	  2878267 2020-04-05 07:29:12		 2997968 2020-04-05 07:36:00		   36 ONLINE		 NO  NO
14 rows selected.
SQL> alter database open;
Database altered.
SQL> 
SQL> 
SQL> 
SQL> alter system switch logfile;
System altered.
SQL> 
```