« WMI+VBS: how to get the domain name | Home | Oracle: information about ASM »

Oracle: file needs recovery (offline mode)

SELECT d.file# f#, d.name, d.status, h.status
FROM v$datafile d, v$datafile_header h
WHERE d.file# = h.file#
AND (d.STATUS NOT IN ('SYSTEM','ONLINE') OR h.STATUS != 'ONLINE' );

If there are such files, the recovery is necessary:

  1. restore the file from the backup
  2. recover datafile '&the_file_name' ;
  3. alter database datafile '&the_file_name' online;

Another possibility (if there are a lot of files):

  1. restore the files from the backup
  2. recover tablespace '&tbs_name' ;
  3. alter tablespace '&tbs_name' online;

Topics: Oracle, backup, restore | Submitter: checkthis

Comments

You must be logged in to post a comment.

Keep on coding