Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recovery

  1. #1
    Join Date
    May 2001
    Posts
    736

    Recovery

    While going through some article i came across this question on recovery.
    The database is running Archive log mode.There is online backup every night.Two datafiles are deleted by mistake through OS level.One belong to USERS tablespace and other belongs to SYSTEM table space.
    How should be the recovery?
    My answer is SHutdown the database.Restore the datafiles.Mount the database.Recover the datafiles.Alter database open.
    The other options says take the System and user tablespace offline.REstore and recover the datafiles and bring them back online.
    Whats your openion on this?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Recovery

    Originally posted by akhadar
    The other options says take the System and user tablespace offline.REstore and recover the datafiles and bring them back online.
    U cannot take the system tablespace offline


    My answer is SHutdown the database.Restore the datafiles.Mount the database.Recover the datafiles.Alter database open.
    when system datafiles files are removed your DB will crash so shutdown option is not available.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2001
    Posts
    736
    Means through OS level Restore datafiles.Mount the DB.Recover the data files.Open the DB.

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