recover database until time
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: recover database until time

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    recover database until time

    All:

    I am trying to get the recover database until time option to work.

    I took the following steps

    1) created a table and added 25 rows to it and at 10:30AM

    2) I shutdown the database

    3) I backed up the data file associated with the tablespace.

    4) I startuped database

    5) 10:35AM I dropped the table.

    6) shutdown database

    7) I restored datafile from back

    8) startup mount database

    9) recover database until time '2009-02-25:10:30:00';

    I get the following erorr: ORA-00283: recovery session canceled due to errors
    ORA-19907: recovery time or SCN does not belong to recovered incarnation

    Is there a table I need to query first to find the correct time I can recover
    too? Or is there something wrong with my test case. If so, can somebody
    please correct

    Thanks in advance to all who answer this post

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I'm not sure you got the concept of point-in-time recovery... it relies on having hot backups followed by archivelog backups. It seams to me you are attempting point-in-time recovery with a cold backup.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    These are the instructions I found on-line, granted they are old but what step am I missing.

    Incomplete Recovery Using Time-Based

    Scenario: The current time is 12 pm on 9-Mar-01 and someone dropped the
    EMP table around 11:45 am. The table must be recovered.
    If the database is open, shut it down using either the "normal" or "immediate" options: SVRMGR> shutdown normal;

    Mount the database:
    SVRMGR> startup mount pfile=Oracle\admin\mike\pfile\init.ora;
    Restore all datafiles(*.dbf) from the most recent backup. (Do not restore
    the Control file, Redo Logs, or Parameter files.)
    UNIX> !cp /disk1/backup/*.dbf /disk1/data/
    NT > !copy c:\backup\*.dbf c:\data\

    Recover the database: SVRMGR> recover database until time '2001-03-09:11:44:00';

    To synchronize datafiles with control files and redo logs, open database using
    "resetlogs" options:
    SVRMGR> alter database open resetlogs;

    Any data entered after the recovery time (11:44 am) will need to be reentered.
    Perform a closed whole backup

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    The hot backup part perhaps?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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