Question about database recovery
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Question about database recovery

  1. #1
    Join Date
    Feb 2002
    Posts
    59
    I am recovering a database that lost all its control files and data files. A tablespace that was just created 8:30 am this morning was also lost. The last good backup was taken at 2:00am this morning. That backup doesn't have that tablespace (prodx) that was created after the backup.

    Now, What I did is restore the good backup and re-build the controlfile from the trace file. Now, I started the recovery process. Accroding to the docs, I also create the new datafiles for the tablespace that was created after the 2:00 am backup. Everything went pretty well.

    The only problem is that the recovery process keep asking new archived logs even after all archived logs have been applied. I tried to cancel the recovery and tried open the database resetlogs. It failed. Now, I am going nowhere.

    What could be wrong?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    you have to recover using backup controlfile until cancel. once you have applied all your archived logs, you can cancel.
    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 2002
    Posts
    59
    recover database using backup controlfile;

    Yes, I did that. And I can cancel the recovery at the end. However, when I tried open resetlogs, Oracle complained the system tablespace need recovery.


  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    As Jeff Said, you should use,

    recover database using backup controlfile until cancel;

    Note that there is a differance between,

    recover database using backup controlfile; and the above command.

    Then
    open database resetlogs;

    It should work.
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Feb 2002
    Posts
    59
    "recover database using backup controlfile until cancel;
    Note that there is a differance between,
    recover database using backup controlfile; and the above command. "

    What's the difference? I have never heard of that and will be appreciate if you can explain.

    The problem that I got was on Solaris on Intel platform. When I duplicate the same scenario on SPARC Solaris, there is no such problems. Do you think there is a differen between Oracle for Intel Solaris and Oracle for SPARC Solaris?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you dont use until cancel oracle will go on recovering until last archive log he can find and if redo logs are online then it will recover until there

  7. #7
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Until cancel....
    Recovering untill you cancelled/crashed the databse not after that.Once all logs are applied you can,
    Cancel;
    open with resetlogs.

    If you know approx time you can recover until time too...

    If the tablespace is not backed up....obviously it will ask for recover...
    for that follow the steps...
    Try to open the database.....it will ask for the datafile....
    try...
    alter database create datafile 'same datafile path';...no size
    statement processed
    recover datafile 'filepath';
    media recovery complete.
    alter databse open;(if required reset log)
    statement processed. hope this help.

    Thanks.
    Thanigaivasan...

  8. #8
    Join Date
    Feb 2002
    Posts
    59
    thanigai,

    My god! The db can be recovered without resetlogs.


  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you have you online redo logs intact you can recover until time of failure, i.e a complte recover and there is not need to resetlogs

  10. #10
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Yes we can.
    we tested it in our Oracle Traing class...I have the report on that too.
    By the by you are asking questions for discussion purpose or
    you have real senario at work.....
    Thanigaivasan.

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