|
-
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?
-
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."
 
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote