DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recovering Datafile without backup

Hybrid View

  1. 04-11-2003, 11:33 AM #1
    zeeshan
    zeeshan is offline Junior DBA
    Join Date
    Mar 2003
    Posts
    32

    Recovering Datafile without backup

    Hi
    I have a problem.
    My Oracle version is 9.0.1.1. Operating System is Windows 2000 Server.
    My database server was improperly shutdown due to power failure,
    which caused some of some kind of media failure in system01.dbf datafile. Now i cannot open my database.
    I created this database only two days ago and had never taken any backup of the database but archiving was enabled.
    I really need to recover this database because it had some very important record in it.
    Can anyone please tell how i can recover my database using archivelogs. The error i keep on getting when i try the recover database command or recover datafile command is

    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:\ORACLE\ORADATA\TEST\REDO02.LOG'

    Can anyone help me.Its really urgent.
    Regards Zeeshan!
    Reply With Quote Reply With Quote
  2. 04-11-2003, 12:12 PM #2
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: Recovering Datafile without backup

    Originally posted by zeeshan
    Hi
    I have a problem.
    My Oracle version is 9.0.1.1. Operating System is Windows 2000 Server.
    My database server was improperly shutdown due to power failure,
    which caused some of some kind of media failure in system01.dbf datafile. Now i cannot open my database.
    I created this database only two days ago and had never taken any backup of the database but archiving was enabled.
    I really need to recover this database because it had some very important record in it.
    Can anyone please tell how i can recover my database using archivelogs. The error i keep on getting when i try the recover database command or recover datafile command is

    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:\ORACLE\ORADATA\TEST\REDO02.LOG'

    Can anyone help me.Its really urgent.
    Just try supplying the path of other redo logfiles.. Dont use recover datafile command. Use recover database command.
    -nagarjuna
    Reply With Quote Reply With Quote
  3. 04-11-2003, 02:41 PM #3
    badrinathn
    badrinathn is offline Advisor
    Join Date
    Jan 2001
    Posts
    642
    Document id 1016968.102, on metalink should help.
    But, take a copy of your existing online redo logs and the db files before performing those action: Worst case, you can try it the next time.

    Let us know how the recovery goes.

    Badrinath
    There is always a better way to do the things.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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