MEDIA RECOVERY
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: MEDIA RECOVERY

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    15
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Are you in archivelog mode?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    Are u not runnign in ArchiveLog Mode.

  4. #4
    Join Date
    Feb 2001
    Posts
    15
    Yes...
    Database is in Archiving Mode.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Jan 2001
    Posts
    126
    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
  •  



Click Here to Expand Forum to Full Width