Database Backup and Recovery (MOSC)

MOSC Banner

Datafile 4 in the RECOVER state: no archives no backups

edited Nov 9, 2013 11:59PM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center