Backing up database with missing datafile

Question

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

Answer 1

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

• tesla747: Will I be able to make it offline even if the datafile is not physically available in the file system?
• Balazs Papp: @tesla747 Yes .