Recovery- Step by Step guidance req:
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Recovery- Step by Step guidance req:

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I was trying to simulate a recovery environment. I took the cold backup of all the files(control,log,data,etc..). I have deleted the original files (log,data) and have restored from backup. I am trying to recover the database, by issuing the following
    1) svrmgr> startup mount;
    2) svrmgr>alter database recover using backup controlfile.
    (THis statement was issued after copying all the backup files to the main directory indivisually)
    statement processed.
    3) However,while opening database, it say
    ora-01589: must use resetlogs or noresetlogs option for database open;
    4) alter database open resetlogs;
    *ora -01113:file 1 needs media recovery
    ora-1110 : data file 1: 'D:\...\sys1orcl.ora'

    How can I bring up by database.
    Badrinath

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You are doing everything correct but the last statement. When you are using Recover database using backup controlfile. You must use Resetlogs option. Try applying this you should be OK.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    svrmgrl> startup mount
    svrmgrl> alter database recover until cancel using backup controlfile;
    svrmgrl> alter database recover continue default;
    svrmgrl> alter database recover continue default;
    (This process continues until you have applied all your archived redo logs)
    svrmgrl> alter database recover cancel;
    svrmgrl> alter database open resetlogs;

    [Edited by marist89 on 01-17-2001 at 01:18 PM]
    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."

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    If you're restoring from a cold backup, you shouldn't need to recover from anything, since everything is from a single point in time and is all synchronized as far as SCN's and data are concerned.

    If you're recovering a hot backup which requires applying archived redo logs, then you need to follow the steps outlined already by the others.

    If the log files from your cold backup need media recovery, just

    > startup mount
    > alter database recover until cancel;
    > alter database recover cancel; // might say recovery hasn't started
    > alter database open resetlogs;

  5. #5
    Join Date
    Jan 2001
    Posts
    642
    I would like to bring to your notice that, after the cold backup and before the actual deletion of the datafiles and log files, some transactions have happened like insertions/delete/drop tables.
    The database is in archive log mode. All the archive files are intact.
    while trying to follow the steps of Mr.pwoneil
    I get the following
    svrmgr>startup mount
    statement processed

    svrmgr>alter database recover until cancel;
    I GET: ORA-00275: media recovery has already been started.
    I then issued

    svrmgr> alter database recover cancel
    I GET: ORA-00279:change 14072 generated at 01/17/01 12:45:26 needed for thread 1
    ORA-00289: suggestion :D:\orant\d...\archive\orclorcls.arc
    ORA-00280: change 14072 for thread 1 is in sequence #1

    Because, the archiving was on, does it mean I cannot make the recovery from cold backup; At this stage
    How dow i make cold backup restoration(I know I will lose data)


  6. #6
    Join Date
    Jun 2000
    Posts
    417
    You said cold backup first, and didn't mention archived log mode or archive logs, so my steps were for a cold backup since nothing should have been modified.

    You should be able to recover by applying the logs after restoring the cold backup. Follow the suggestions of marist89 to apply all of the archived logs.

  7. #7
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Just use the Archive logfile/s from the suggestions given by oracle and you should be able to open the database
    Thanks
    Kishore Kumar

  8. #8
    Join Date
    Jun 2000
    Posts
    417
    Oh, it's possible for you to lose data if you restore your cold backup and overwrite your online redo logs. If any redo information was contained in your online logs before they were archived, and you either lost, or overwrote the files you won't be able to recover that data.

    To protect that you should have mirrored redo logs.

  9. #9
    Join Date
    Jan 2001
    Posts
    642
    Hi, I am trying to follow these command for cold backup recovery

    svrmgrl> startup mount
    statement processed

    svrmgrl> alter database recover until cancel using backup controlfile;

    ORA-00279: change 14072 generated at 01/17/01 12:45 needed for thread 1
    ORA-00289: suggestion : D"\ORNT\DATABASE\ARCHIVE\ORCLORCLS.arc
    ORA-00280: change 14072 for thread 1 is in sequence #1

    svrmgrl> alter database recover continue default;
    ORA-00310; archived log contains sequence 7;sequence 1 required
    ORA-00334:archived log:'D:\orant\database\archive\orclorcls.arc';


    svrmgrl> alter database recover cancel;
    ORA-01547:warning:RECOVER succeded but OPEN RESETLOGS would get error below
    ORA-01152:file 1 was not restored from a sufficiently old backup
    ORA-01110:data file 1: 'D:\ORANT\DATABASE\SYS1ORCL.ora'

    svrmgrl> alter database open resetlogs;

    ORA-01152: file 1 was not restored from a sufficiently old backup
    ORA-01110:datafile 1:'D:\orant\database\sys10RCL.ora'

    The database still does not come up. Please help me.
    Badrinath

  10. #10
    Join Date
    Jun 2000
    Posts
    417
    Ok. Just to open the database (without regarding data loss) from a cold backup, all you have to do (provided your cold backup contains all datafiles, control files, and log files), is to restore all the files from your cold backup, then you should be able to "startup" from svrmgrl. No need to worry about database recovery.

    Test that to see if it works. If it doesn't, do you have all of your datafiles, control files, and log files in the backup? Was it taken while the database was closed?

    Once that opens, shut it down, and restore the cold backup again. Now you can try to get back data that was commited after the cold backup was taken.

    Restore all the files from the cold backup
    svrmgrl> startup mount
    svrmgrl> alter database recover until cancel using backup controlfile;
    -- here it should start prompting for archived logs
    svrmgrl> alter database recover continue default;
    -- repeat that until there are no more suggestions, or when you apply it it says "no such file or directory"
    svrmgrl> alter database recover cancel;
    svrmgrl> alter database open resetlogs;

    The second method assumes you have the archived logs from the database. However it looks like you might not have all of the archived logs available, or they are corrupted.

    00310, 00000, "archived log contains sequence %s; sequence %s required"
    // *Cause: The archived log is out of sequence, probably because it
    // is corrupted or the wrong redo log filename was specified

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