2

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

1 Answer 1

3

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

2
  • Will I be able to make it offline even if the datafile is not physically available in the file system?
    – tesla747
    Jan 10, 2016 at 17:49
  • @tesla747 Yes . Jan 10, 2016 at 17:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.