Point-in-time recovery test
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Point-in-time recovery test

  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Point-in-time recovery test

    I am testing archive logging point-in-time recovery on Oracle 8.1.6. What I'd like to do is recover twice really. Recover to a point in time BEFORE the change and then recover to a point in time AFTER the change.

    What I've tried is this:

    1. Did a physical backup of files
    2. Made a change to the database
    3. Switched the log files.
    4. Simulated a database crash.
    5. Restored datafiles from physical backup (no logs or control files)
    6. Recovered to a point BEFORE the change was made to show that the change is gone.
    - recover database until time 'BEFORE CHANGE';
    - alter database open noresetlogs;

    7. Then recovered to a point AFTER the change to show that the change can come back from the archive log file.
    - recover database until time 'AFTER CHANGE';
    - alter database open resetlogs;

    Is this possible? If so, what am I missing because this is not working.

    Thank you in advance.

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    I guess after an incomplete recovery, you need to open DB with resetlogs.
    Vinit

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you resetlogs you cannot recover it further more with OLD archived logs so basically what you are trying to do does NOT work

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by pando
    if you resetlogs you cannot recover it further more with OLD archived logs so basically what you are trying to do does NOT work
    Yes, perhaps he should start all over again, barring steps 1 (if backups are still available) and 6.
    Vinit

  5. #5
    Join Date
    Dec 2002
    Posts
    2
    You are all right. It's not working. I'm trying to figure out how to make it work.

    I'm testing to see if I can recover to BEFORE the change and THEN roll forward again to bring the change back. Is this possible?

    I guess I should have clarified myself more.

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Friends,
    I dont think you can do it in this way..
    Nore you have any recover method for this kind of a senario.

    regards
    anandkl
    anandkl

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