Loss of all control file missing | https://www.xedok.com/posts

Loss of all control file missing

Posted on: 2025-01-28 16:52:47


Follow these steps:

SQL> shut abort;
SQL> startup nomount;
$ rman target /
RMAN> list backup of controlfile;
RMAN> restore controlfile from '/home/oracle/backup/BKP_03ngied9_1_1';  ( Suppose controlfile backup is kept in BKP_03ngied9_1_1 file)
RMAN > alter database mount;
RMAN> recover database;
RMAN> alter database open resetlogs;
Now take immediate Full backup;
RMAN> backup database plus archivelog;



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



Leave a reply