Wednesday, May 20, 2015

ORA-01113: file 13 needs media recovery

oracle@Linux01:[+DATA1] $ sqlplus /"As sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 21 10:09:56 2012

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL > ALTER database  RENAME FILE '/u01/app/oracle/datafiles/SOME_TABLESPC_USER_03.dbf' TO '/u01/app/oracle/datafiles/qpdev/SOME_USER_04.dbf';
            

SQL> ALTER DATABASE

DATAFILE '+DATA1/USER_DATA_04.dbf'

ONLINE  2 ;

*

ERROR at line 3:

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected


SQL> ALTER DATABASE DATAFILE '+DATA1/USER_DATA_04.dbf' ONLINE;

ALTER DATABASE DATAFILE '+DATA1/USER_DATA_04.dbf' ONLINE

*

ERROR at line 1:

ORA-01113: file 13 needs media recovery

ORA-01110: data file 13: '+DATA1/USER_DATA_04.dbf'

SQL> recover datafile '+DATA1/USER_DATA_04.dbf';

Media recovery complete.

SQL> ALTER DATABASE DATAFILE '+DATA1/USER_DATA_04.dbf' ONLINE;

Database altered.


SQL>

No comments:

Post a Comment