Hi Guy's,
Ora-01113 occurs when Recovery needed for any file.
- There can be many reasons for these errors as per the oracle.
1. AT STARTUP AFTER CRASH WITH TABLESPACE(S) IN HOT BACKUP.
2. AFTER RESTORING A DATAFILE OR TABLESPACE FROM A BACKUP.
3. TRYING TO ONLINE A DATAFILE OR TABLESPACE
4. WHEN RECOVERING ' USING BACKUP CONTROLFILE' OPTION TO DO INCOMPLETE RECOVERY.
In my case i am trying to make datafile online.
======================================
SQL> alter database datafile '+DATA1/kkprod/datafile/tsnew.256.963078241' OFFLINE;
Database altered.
SQL> select name,status from v$datafile where file#='6'
NAME STATUS
-------------------------------------------------------------------------------
+DATA1/kkprod/datafile/tsnew.256.963078241 RECOVER
SQL> alter database datafile '+DATA1/kkprod/datafile/tsnew.256.963078241' ONLINE;
alter database datafile '+DATA1/kkprod/datafile/tsnew.256.963078241' ONLINE
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '+DATA1/kkprod/datafile/tsnew.256.963078241'
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2087780352 bytes
Fixed Size 2256784 bytes
Variable Size 536871024 bytes
Database Buffers 1543503872 bytes
Redo Buffers 5148672 bytes
Database mounted.
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 2642889656 generated at 12/19/2017 09:29:36 needed for thread1
ORA-00289: suggestion : E:\FRA\KKPROD\ARCHIVELOG\2017_12_19\O1_MF_1_32_%U_.ARC
ORA-00280: change 2642889656 for thread 1 is in sequence #32
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
- Apply the log here.
+DATA/kkprod/onlinelog/group_2.260.963052729
log applied.
Media recovery complete.
- Now open the database.
SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.
Enjoy Reading...
No comments:
Post a Comment