Recovery help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Recovery help

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    Recovery help

    Hi,
    I need help to recover the following Case.



    Database running in archive log mode.

    Time T1:
    cold backup of the database was taken; All datafile,controlfile and redo log files.


    Time T2:

    New tablespace added.


    Time T3:
    Latest Control file and Latest datafiles are lost. But I have only latest Redo log files intact.

    Also i have all the archive log files since the last cold backup.
    The cold backup taken at Time T1 is also intact.


    Is it possible to recover the database including the tablespace recently added at Time T2 ??

    I tried recovering with latest redo log and the cold backup, but the recovery errored out

    SQL> recover database using backup controlfile;
    ORA-00279: change 565321 generated at 04/06/2006 19:22:34 needed for thread 1
    ORA-00289: suggestion : E:\ORACLE\ORADATA\ARCHIVES\ARC00008.001
    ORA-00280: change 565321 for thread 1 is in sequence #8


    Specify log: {=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00283: recovery session canceled due to errors
    ORA-00600: internal error code, arguments: [3020], [8388697], [1], [8],
    [12856], [16], [], []
    ORA-10567: Redo is inconsistent with data block (file# 2, block# 89)
    ORA-10564: tablespace UNDOTBS1
    ORA-01110: data file 2: 'E:\ORACLE\ORADATA\STST\UNDOTBS01.DBF'
    ORA-10560: block type 'KTU SMU HEADER BLOCK'


    ORA-01112: media recovery not started
    Last edited by bang_dba; 04-06-2006 at 10:29 AM.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Which release of oracle are you on?
    Are you doing the recover on a standby database? There are documents in Metalink related to 'stuck recovery'
    thomasp

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    Quote Originally Posted by thomasp
    Which release of oracle are you on?
    Are you doing the recover on a standby database? There are documents in Metalink related to 'stuck recovery'
    Release 9.2.0.1.0
    Not a standby; just a normal database.
    The question is, i just have the redo logs which are latest and rest of the things are old, which are taken during last backup.
    Also i have all the archives since last backup.

    Can i recover the database till the latest point.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    1.) If redologs are overwritten, since last backup then u caught..
    2.) you have all archived log files, but you caught apply them as you have not a valid online backup.

    3.) Try is do incomplete Recovery or create datafile and apply archivelogs.
    Last edited by dhar_kiran; 04-07-2006 at 06:01 AM.
    ~KD.DBA~

  5. #5
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Yes, I believe you can restore:

    http://download-west.oracle.com/docs...rios.htm#14480

    This explains what to do if you have online redo, but no backup of new tablespace and datafile(s). However, if you ire unsure of what you need to do I really would recommed opening a serverity 1 service request with Oracle Support.

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Also, I think that you will need to make sure the online logs are applied manually (automatic recovery will search for archived logs with the same log sequence numbers as the online logs).

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