« 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.