Is there a way to backup a Oracle 12c database which has a missing datafile?
I dont have backups. Database is running in archive log mode. One of the data files is physically missing from the disk.
But querying dba_data_files, it shows up as a datafile and when I try to backup using RMAN or expdp, it throws an error and fails.
What are the options I have got here?
Oracle12c/RHEL 6
Best Answer
You can specify
SKIP
options in your backup command.For example:
BACKUP DATABASE SKIP INACCESSIBLE;
or take the datafile offline, and:
BACKUP DATABASE SKIP OFFLINE;
skipSpec