Oracle: Rollback Segment Data File is Offline. File needs media recovery

SQL> alter database datafile '/oracle01/dbf/dbinst/rbs01.dbf' online;
alter database datafile '/oracle01/dbf/dbinst/rbs01.dbf' online
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/oracle01/dbf/dbinst/rbs01.dbf'

SQL> select name, status from v$datafile;
/oracle01/dbf/dbinst/rbs01.dbf
RECOVER

villavejAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
LindaCConnect With a Mentor Commented:
Try this:
III. TRYING TO ONLINE A DATAFILE OR TABLESPACE
**********************************************
 
   1. Recover the datafile:
 
           SVRMGRL> RECOVER DATAFILE '<datafile_name>';
 
      If recovering a tablespace, do
 
           SVRMGRL> RECOVER TABLESPACE <tablespace_name>;

      If recovering a database, do
         
           SVRMGRL> RECOVER DATABASE;
 
   2. Confirm each of the archived logs that you are prompted for until you
      receive the message "Media recovery complete".

      If you are prompted for an archived log that does not exist, Oracle probably
      needs one or more of the online logs to proceed with the recovery. Compare
      the sequence number referenced in the ORA-280 message with the sequence
      numbers of your online logs. Then enter the full path name of one of the
      members of the redo group whose sequence number matches the one you are
      being asked for.

   3. Open the database.
         
       SVRMGR> ALTER DATABASE OPEN;
0
 
villavejAuthor Commented:
Thanks.  It worked.
0
All Courses

From novice to tech pro — start learning today.