Database Backup and Recovery (MOSC)

MOSC Banner

I am stuck with errors below. I will appriciate your response.

edited Oct 25, 2011 7:28PM in Database Backup and Recovery (MOSC) 9 commentsAnswered
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle/oradata/alepo/system01.dbf'
ORA-01206: file is not part of this database - wrong database id

According to knoeldge base, I have tried the following output;

See Below and adivse please.

SQL> select substr(name, 1, 50), status from v$datafile;SUBSTR(NAME,1,50) STATUS -------------------------------------------------- ------- /oracle/oradata/alepo/system01.dbf SYSTEM /oracle/oradata/alepo/undo01.dbf ONLINE /oracle/oradata/alepo/sysaux01.dbf ONLINE /oracle/oradata/alepo/RBSSERV01.dbf ONLINE 4 rows selected.SQL> select substr(name,1,40), recover, fuzzy, checkpoint_change# from v$datafile_header;SUBSTR(NAME,1,40) REC FUZ CHECKPOINT_CHANGE# ---------------------------------------- --- --- ------------------ /oracle/oradata/alepo/system01.dbf NO 749969 /oracle/oradata/alepo/undo01.dbf NO 749969 /oracle/oradata/alepo/sysaux01.dbf NO 749969 /oracle/oradata/alepo/RBSSERV01.dbf NO 749969 4 rows selected.SQL> select GROUP#,substr(member,1,60) from v$logfile;GROUP# SUBSTR(MEMBER,1,60) ---------------- ------------------------------------------------------------ 1 /oracle/oradata/alepo/redo01_1.log 1 /oracle/oradata/alepo/redo01_2.log 2 /oracle/oradata/alepo/redo02_1.log 2 /oracle/oradata/alepo/redo02_2.log 3 /oracle/oradata/alepo/redo03_1.log 3 /oracle/oradata/alepo/redo03_2.log 4 /oracle/oradata/alepo/redo04.log 5 /oracle/oradata/alepo/redo05.log 6 /oracle/oradata/alepo/redo06.log 9 rows selected.SQL> select * from v$recover_file;FILE# ONLINE ONLINE_ ERROR CHANGE# TIME ---------------- ------- ------- ----------------------------------------------------------------- ---------------- --------- 1 ONLINE ONLINE WRONG DATABASE 749969

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