Loss of one datafile

Posted on: 2023-03-13 10:55:11


SQL> startup mount;
Find the file numbers of the files which need to be recovered 
SQL> SELECT FILE#,ONLINE_STATUS,ERROR FROM V$RECOVER_FILE; 

RMAN> report schema;
Above command will give you the number of amit.dbf file says 5;
RMAN> restore datafile 5;
RMAN> recover datafile 5;
RMAN> alter database open;



xedok When seeking the best software development companies Xedok Software is your ultimate choice. For Demos click here



Leave a reply