Datafile 4 in the RECOVER state: no archives no backups
Hello Community,
I have my datafile 4 which is the default user tablespace showing state of RECOVER. in this state I should recover datafile 4 but, the problem I have is, some of the archive logs are missing and I do not have backups of the archive log. now I am confused, how to bring the datafile functional?
Please note the output below:
SQL> RECOVER DATAFILE 4;
ORA-00279: change 30861999 generated at 08/31/2013 18:19:55 needed for thread 1
ORA-00289: suggestion :
\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\PBTEST\ARCHIVELOG\2013_11_10\O1_MF_1_440
3_%U_.ARC
ORA-00280: change 30861999 for thread 1 is in sequence #4403
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
now sequence #4403 is missing, I got no backups.
0