Results 1 to 3 of 3

Thread: recovery

  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Thumbs up Unanswered: recovery

    Dear Views

    I have a suitation like this :
    At 12.00 i have taken Hot backup
    At 12.20 i add a datafile to a tablespace
    At 12.30 the system crashes.

    Now can i recover the newly added datafile. If so How ?

    And can any one explain how the Oracle gets crashed ?

    Please mail me at manips15@hotmail.com.

    With regards
    MANI PS

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Yes Dear Manisiva,

    You can recover database because your database is in Archivelog mode. You can perform following steps...

    (1) Shutdown Immediate. ( If not work then Shutdown abort.)
    (2) Startup mount
    (3) Recover Database (Using Auto Option)
    (4) alter database open.

    I guess this will help you out.

    Thanks,

    Hings...
    ============
    Still Learning...

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Oracle crashes when you have hardware, media or database failure.

    In media failure the disk(s) or controllers fail and the data is unaccesible.

    In hardware failure the MB, RAM, CPU, power suplly fail, and the instance is crashing.

    In database failure, bugs or internal errors cause the instance to crash.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •