SVRMGR> alter database open;
alter database open
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORANT\MANJUTIGER\SYS01.ORA'
SVRMGR> alter database recover datafile 'C:\ORANT\MANJUTIGER\SYS01.ORA';
alter database recover datafile 'C:\ORANT\MANJUTIGER\SYS01.ORA'
*
ORA-00283: recovery session canceled due to errors
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'C:\ORANT\MANJUTIGER\LOG02B.LOG'
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'C:\ORANT\MANJUTIGER\LOG02A.LOG'
SVRMGR> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'C:\ORANT\MANJUTIGER\LOG02B.LOG'
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'C:\ORANT\MANJUTIGER\LOG02A.LOG'
Since i am in mount stage... i cant issue the following command,
SVRMGR> alter system switch logfile;
how to proceed... Please help me.
03-01-2001, 03:51 PM
marist89
Are you in archivelog mode?
03-01-2001, 03:52 PM
gpsingh
Are u not runnign in ArchiveLog Mode.
03-01-2001, 03:56 PM
yajman
Yes...
Database is in Archiving Mode.
03-01-2001, 04:05 PM
marist89
Was this file restored from a backup?
You can try to clear the unarchived log file "ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'file name'" and then open database with resetlogs.
If that doesn't work, you will have to restore from your last backup and do an incomplete recovery through your last archived redo log file.
03-01-2001, 05:35 PM
mbaliga
Hi,
ORA 322 indicates that the online redo log is not the current one. Have you restored the online redo log too from an old backup?
