SYMPTOMS
ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-01565: error in identifying file '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-27037: unable to obtain file status
SYS AS SYSDBA>select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/system01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/sysaux01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/undotbs01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/rman01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/users01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_02.dbf
/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010
CHANGES
Customer recreated the controlfile
CAUSE
Customer recreated the controlfile, and one of the datafile missed in create controlfile statment.
SOLUTION
If the datafile exists on the filesystem, and DB was opened with resetlogs, after recreating the controlfile,
Option 1: If datafile still exists on filesystem (available at OS level)
======
Restart the database in mount mode and rename the datafile
SYS AS SYSDBA>shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS AS SYSDBA>startup mount
ORACLE instance started.
Total System Global Area 2063595328 bytes
Fixed Size 8898368 bytes
Variable Size 704643072 bytes
Database Buffers 1342177280 bytes
Redo Buffers 7876608 bytes
Database mounted.
SYS AS SYSDBA>alter database rename file '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010' to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';
Database altered.
SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_COUNT from v$datafile_header;
FILE# STATUS ERROR RESETLOGS CHECKPOINT_COUNT
---------- ------- ----------------------------------------------------------------- --------- ----------------
1 ONLINE 27-OCT-23 1645
2 ONLINE 27-OCT-23 1173
3 ONLINE 27-OCT-23 1634
4 ONLINE 27-OCT-23 1589
5 ONLINE 27-OCT-23 1319
7 ONLINE 27-OCT-23 1632
8 ONLINE 27-OCT-23 1047
9 ONLINE 27-OCT-23 1043
10 OFFLINE WRONG RESETLOGS 08-MAY-23 420
9 rows selected.
Now run recover datafile command and bring it back to online (in mount mode only
RMAN> recover datafile 10;
Starting recover at 27-OCT-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 27-OCT-23
RMAN> alter database datafile 10 online;
Statement processed
RMAN> alter database open;
Statement processed
RMAN> alter system checkpoint;
Statement processed
RMAN>
Now check the Datafile status again
SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_COUNT from v$datafile_header;
FILE# STATUS ERROR RESETLOGS CHECKPOINT_COUNT
---------- ------- ----------------------------------------------------------------- --------- ----------------
1 ONLINE 27-OCT-23 1647
2 ONLINE 27-OCT-23 1175
3 ONLINE 27-OCT-23 1636
4 ONLINE 27-OCT-23 1591
5 ONLINE 27-OCT-23 1321
7 ONLINE 27-OCT-23 1634
8 ONLINE 27-OCT-23 1049
9 ONLINE 27-OCT-23 1045
10 ONLINE 27-OCT-23 423
9 rows selected.
Option 2:- If datafile does not exists at OS level, but the backup does exists, prior to recreating the controlfile
Try to restore datafile with set new name
RMAN> run {
2> set newname for datafile 10 to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';
3> restore datafile 10;
4> recover datafile 10;
5> }
executing command: SET NEWNAME
Starting restore at 27-OCT-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/27/2023 07:03:24
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL1930 4194918935 PARENT 85128967 27-OCT-23
2 2 ORCL1930 4194918935 CURRENT 85135204 27-OCT-23
RMAN> catalog recovery area; 没有用catalog start with
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300790_lmpmopc3_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302951_lmpos84h_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300699_lmpmlw81_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300777_lmpmo9jm_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302142_lmpnzy9s_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_ncnnf_TAG20231027T054627_lmpmoo1g_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3wq_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3ym_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_lkwz7y30_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9r86g2c_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9oqd3qp_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l99k5615_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9pq3ktv_.flb
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnq61r_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnzlt2_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300790_lmpmopc3_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302951_lmpos84h_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300699_lmpmlw81_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300777_lmpmo9jm_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302142_lmpnzy9s_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_ncnnf_TAG20231027T054627_lmpmoo1g_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3wq_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3ym_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnq61r_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnzlt2_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc
RMAN> run {
2> set newname for datafile 10 to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';
3> restore datafile 10;
4> recover datafile 10;
5> }
executing command: SET NEWNAME
Starting restore at 27-OCT-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00010 to /refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp tag=TAG20231027T054402
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 27-OCT-23
Starting recover at 27-OCT-23
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/27/2023 07:05:35
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
if needed datafile 10
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 10 is unknown - rename to correct file
ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01111: name for data file 10 is unknown - rename to correct file
ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
RMAN> switch datafile 10 to copy;
datafile 10 switched to datafile copy "/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf"
RMAN> recover datafile 10;
Starting recover at 27-OCT-23
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 158 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
archived log for thread 1 with sequence 159 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
archived log for thread 1 with sequence 160 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
archived log for thread 1 with sequence 161 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
archived log for thread 1 with sequence 162 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc
archived log for thread 1 with sequence 1 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_1_lmpqw34o_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=147
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_147_lmprbrgl_.arc thread=1 sequence=147
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_147_lmprbrgl_.arc RECID=9 STAMP=1151305560
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=148
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=149
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=150
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_148_lmprbsp1_.arc thread=1 sequence=148
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_148_lmprbsp1_.arc RECID=10 STAMP=1151305561
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_149_lmprbspv_.arc thread=1 sequence=149
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_149_lmprbspv_.arc RECID=11 STAMP=1151305561
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_150_lmprbsqq_.arc thread=1 sequence=150
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_150_lmprbsqq_.arc RECID=12 STAMP=1151305561
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=151
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=152
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=153
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_151_lmprbtyt_.arc thread=1 sequence=151
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_151_lmprbtyt_.arc RECID=13 STAMP=1151305562
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_152_lmprbv0o_.arc thread=1 sequence=152
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_152_lmprbv0o_.arc RECID=14 STAMP=1151305563
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_153_lmprbv22_.arc thread=1 sequence=153
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_153_lmprbv22_.arc RECID=15 STAMP=1151305563
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=154
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=155
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=156
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_154_lmprbw98_.arc thread=1 sequence=154
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_154_lmprbw98_.arc RECID=16 STAMP=1151305564
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_155_lmprbwb3_.arc thread=1 sequence=155
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_155_lmprbwb3_.arc RECID=17 STAMP=1151305564
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_156_lmprbwbw_.arc thread=1 sequence=156
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_156_lmprbwbw_.arc RECID=18 STAMP=1151305564
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=157
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_157_lmprbxkc_.arc thread=1 sequence=157
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_157_lmprbxkc_.arc RECID=19 STAMP=1151305565
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc thread=1 sequence=158
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc thread=1 sequence=159
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc thread=1 sequence=160
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc thread=1 sequence=161
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc thread=1 sequence=162
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_1_lmpqw34o_.arc thread=1 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 27-OCT-23
RMAN> alter database datafile 10 online;
Statement processed
RMAN>
Now check the status of datafile
SYS AS SYSDBA>set lines 300
SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_TIME from v$datafile_header;
FILE# STATUS ERROR RESETLOGS CHECKPOIN
---------- ------- ----------------------------------------------------------------- --------- ---------
1 ONLINE 27-OCT-23 27-OCT-23
2 ONLINE 27-OCT-23 27-OCT-23
3 ONLINE 27-OCT-23 27-OCT-23
4 ONLINE 27-OCT-23 27-OCT-23
5 ONLINE 27-OCT-23 27-OCT-23
7 ONLINE 27-OCT-23 27-OCT-23
8 ONLINE 27-OCT-23 27-OCT-23
9 ONLINE 27-OCT-23 27-OCT-23
10 ONLINE 27-OCT-23 27-OCT-23
9 rows selected.