Using backup controlfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Using backup controlfile

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96

    Using backup controlfile

    Hi there!
    I want to recover my database until a scn. i mean incomplete recover.
    I want to use the current control file.question is may i need to include the "using backup controlfile" on the recover database command?
    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You're right. If you give us more information we might be able to help. Things like:
    1. using rman?
    2. in archivelog mode?
    3. how did you perform backup?
    4. incremental or full?
    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
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    hi marist89!
    My question is: in archivelog mode, but not using rman commands. What are the difference between "recover database until change 222222" and
    "recover database until change 222222 using backup controlfile" while the current controlfile is available.
    In god i trust

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    If your current controlfile is available, use it.

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    using backup contol file tells oracle to ignore the SCN in the control file you are using....so If you have a backup of the control file on Sunday and then Friday you have a failure. using the Sun control file without the backup controlfile option would result in Oracle rolling forward to Sunday and then stopping as the reocery process would see that control files SCN as being the most current.
    I'm stmontgo and I approve of this message

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