1

When i typed the command "backup database" it mentioned

"RMAN-06169: could not read file header for datafile 5 error reason 4..."etc enter image description here

and then i checked the STATUS of the datafile 5

(look at the picture)

enter image description here

so i tried to recover ,it didn't work.

it told me that "ORA-00283: recovery session canceled due to errors ORA-01110: data file 5: '/u01/app/oracle/oradata/abc/abc.dbf' ORA-01157: cannot identify/lock data file 5 - see DBWR trace file ORA-01110: data file 5: '/u01/app/oracle/oradata/abc/abc.dbf' (datafile 7 is the same situation.)"

It reminded me that i once delected the document-abc under the graphic interface,which meant that i didn't use the command to delect the file.

so i tried to alter the datafile 5 and datafile 7.. it didn't work also.

how to alter the datafile 5 and 7? and backup database? thanks very much~！

Improve this question
5
  • what actually want to do that? want to take backup of your database through RMAN or want to see the backup file through RMAN.
    – Md Haidar Ali Khan
    Commented Aug 9, 2017 at 9:26
  • i want to backup full database.but there is something wrong with the datafile 5 and 7. the datafile 5 and 7 is useless and i want to alter them,
    – forest 251
    Commented Aug 9, 2017 at 9:32
  • I am not able to see your 'Alter Command' could you please edit in your question. what you are trying to run ALTER command in SQL or RMAN command prompt.
    – Md Haidar Ali Khan
    Commented Aug 9, 2017 at 9:35
  • @MdHaidarAliKhan Um...could you tell me how to solve the problem about"RMAN-06169: could not read file header for datafile 5 error reason 4"
    – forest 251
    Commented Aug 9, 2017 at 9:36
  • @MdHaidarAliKhan I mean"alter database datafile 5 offline drop;"←
    – forest 251
    Commented Aug 9, 2017 at 9:41

1 Answer 1

Reset to default
1

Try this command to SKIP the offline and corrupted datafiles:

BACKUP DATABASE
    SKIP INACCESSIBLE
    SKIP OFFLINE;

SKIP INACCESSIBLE: Inaccessible datafiles. A datafile is only considered inaccessible if it cannot be read. Some offline datafiles can still be read because they exist on disk. Others have been deleted or moved and so cannot be read, making them inaccessible.

SKIP OFFLINE: skipping Offline datafiles;

Details: https://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmbackp.htm

Improve this answer

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.