I am stuck with errors below. I will appriciate your response.
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
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 7499690