backup/recovery senarios
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: backup/recovery senarios

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    backup/recovery senarios

    let's say the database was shutdown for cold backup and unfortunately the database was scheduled to startup while the datafiles are still being copied. What would happen to the database????

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    The pertinent question is this: how valid are the copies of files you made? Database startup, some SCN's get tossed around, some job starts that deletes data, what good are the already-copied files?

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Nothing to the database.
    Last edited by adewri; 06-04-2003 at 12:15 PM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    open files that get copied are marked as fuzzy by oracle and cannot be used for recovery.

    steve
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Sep 2002
    Posts
    411
    by any mean I just tried this out and here what I get:

    I open the database while the datafiles being copied and below is what I got:

    SQL> startup pfile=c:\oracle\admin\mytest\pfile\initmytest.ora
    ORACLE instance started.

    Total System Global Area 58906652 bytes
    Fixed Size 75804 bytes
    Variable Size 32538624 bytes
    Database Buffers 26214400 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    ORA-01113: file 4 needs media recovery
    ORA-01110: data file 4: 'C:\ORADATA\MYTEST\DATA_TS_01.DBF'


    any comments or advise???

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    Yeah, don't do that.

  7. #7
    Join Date
    Sep 2002
    Posts
    411
    if this is what happened, what do we need to do ????

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    recover your database.
    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."

  9. #9
    Join Date
    Aug 2001
    Location
    Indonesia
    Posts
    5
    Yeah...

    With "Recover Database" command, Oracle will try to find the Information needed to syncronize the database in the RedoLog Files, if the info is not available in Redolog, it will ask the Archive_files if your database in Archive Log Mode....

    TIA
    Jeram
    Oracle DBA

  10. #10
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    The database was closed (Hopefully clean shutdown ), so There is no problem with database, only your Backup will not be consistent. And there is no problem of fuzzy status of datafile, as it was cold backup.

    Just do cold backup once again (by taking database shutdown), so your backup is proper.

    Cheers
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

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