Results 1 to 2 of 2

Thread: can i recover database in noarchivelog mode

  1. #1
    Join Date
    Jun 2004
    Location
    nepal
    Posts
    8

    can i recover database in noarchivelog mode

    MEDIA RECOVERY
    =================

    SVRMGR> alter database open;
    alter database open
    *
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'C:\ORANT\database\SYS01.ORA'

    SVRMGR> alter database recover datafile 'C:\ORANT\database\SYS01.ORA';
    alter database recover datafile 'C:\ORANT\database\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:



    when i try to recover datafile i get message like this
    this database is in noarchivelog mode. i don't have coldbackup also.
    so how can i recover that noarchivelog mode database?
    please help me.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't recover a database which is in NOARCHIVELOG mode. It can only do instance recovery, which is recovering transactions which were in redo logs when system crashed.

    If you do not have a cold backup, then there is not much you can do. If you have export dump then you can import that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •