Problem with standby database ORA-01157
Hi blokes,
My standby database is currently bringing up the error below in the alert log .
I would appreciate if anyone cold give me a clue to the solution . Below is the the content of my alert log .
Cheers ..
Errors in file /opt/app/oracle/admin/edt02/bdump/edt02_dbw0_5392.trc:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/oradata/edt02/audit_data_01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Tue Jul 24 09:14:04 2007
Media Recovery failed with error 1670
ORA-283 signalled during: ALTER DATABASE RECOVER managed standby database ...
Tue Jul 24 09:25:55 2007
Errors in file /opt/app/oracle/admin/edt02/bdump/edt02_dbw0_5392.trc:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/oradata/edt02/audit_data_01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Tue Jul 24 09:25:55 2007
Errors in file /opt/app/oracle/admin/edt02/bdump/edt02_dbw0_5392.trc:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/oradata/edt02/audit_data_01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Tue Jul 24 09:26:30 2007
alter database create datafile '/u01/oradata/edt02/audit_data_01.dbf'
Tue Jul 24 09:26:31 2007
Completed: alter database create datafile '/u01/oradata/edt02
Tue Jul 24 09:27:04 2007
ALTER DATABASE RECOVER standby database until cancel
Tue Jul 24 09:27:04 2007
Media Recovery Start
ORA-279 signalled during: ALTER DATABASE RECOVER standby database until can...
Tue Jul 24 09:27:06 2007
ALTER DATABASE RECOVER CONTINUE DEFAULT
Tue Jul 24 09:27:06 2007
Media Recovery Log /u02/archive/edt02/EDT02_1_1611.arc
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Tue Jul 24 09:27:10 2007
ALTER DATABASE RECOVER CANCEL
Tue Jul 24 09:27:10 2007
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL
Tue Jul 24 09:27:30 2007
ALTER DATABASE RECOVER managed standby database
Media Recovery Start: Managed Standby Recovery
Media Recovery Waiting for thread 1 seq# 1612
Media Recovery Log /u02/archive/edt02/EDT02_1_1612.arc
Media Recovery Waiting for thread 1 seq# 1613