Can you use a binary backup of controlfile to recover a db without reset logs?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Can you use a binary backup of controlfile to recover a db without reset logs?

  1. #1
    Join Date
    Feb 2002
    Posts
    59
    Can you use a binary backup of controlfile to recover a db without reset logs?

    Here is the steps:

    alter database backup controlfile to '/export/home/u03/oradata/mnki/bkpctl';

    On the OS level, remove the control file.

    alter system checkpoint; ==> the db will crash

    Now, on the OS level, cp bkpctl control01.ctl.

    Then:

    SQL> startup mount;
    ORACLE instance started.

    Total System Global Area 24297632 bytes
    Fixed Size 73888 bytes
    Variable Size 7266304 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 180224 bytes
    Database mounted.
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    SQL> recover database;

    Then the db will keep asking archived log even ALL archived logs have been supplied.

    What could went wrong?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to use recover database using backup controlfile

    however I wonder how you can recover still because you should get ora-01207 straoght away, are you sure you have tried this?

  3. #3
    Join Date
    Feb 2002
    Posts
    59
    Yes, I tested. I could not use the binary backup to recover the db. But I could use the backup trace (SQL) to recreate the new control file and then open the db.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well in your first post you are saying you used binary copy, that is different ok....

  5. #5
    Join Date
    Feb 2002
    Posts
    59
    Right. I have no problem using the trace file.

    My question is "Can you use a binary backup of controlfile to recover a db without reset logs?"




  6. #6
    Join Date
    Feb 2002
    Posts
    59
    My question is "Can you use a binary backup of controlfile to recover a db without reset logs?"




  7. #7
    Join Date
    Nov 2000
    Posts
    224
    Using binary copy, you have to reset the logs.

    Reseting the logs is the mechanism oracle uses to synchronize controlfile with datafiles

  8. #8
    Join Date
    Feb 2002
    Posts
    59
    Originally posted by Sharma
    Using binary copy, you have to reset the logs.

    Is this true? Why?

  9. #9
    Join Date
    Nov 2000
    Posts
    224
    When you use the binary copy backup of controlfile, it will be outofsync with Datafile and redologs.

  10. #10
    Join Date
    Feb 2002
    Posts
    59
    This doesn't necessarily require resetlogs. As long as you have all archived logs, you should be able to synch the database. So, why shuold I resetlogs?

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