-
MEDIA RECOVERY
=================
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.
-
Are you in archivelog mode?
Jeff Hunter
-
Are u not runnign in ArchiveLog Mode.
-
Yes...
Database is in Archiving Mode.
-
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.
Jeff Hunter
-
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?
Baliga
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|