Backing up database with missing datafile

backuporacleoracle-12c

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.

enter image description here

For example:

BACKUP DATABASE SKIP INACCESSIBLE;

or take the datafile offline, and:

BACKUP DATABASE SKIP OFFLINE;

skipSpec