The recovery operation you are preparing includes read-only tablespaces. Which command can you issue to get a listing of the procedures needed to recover this database?
ALTER DATABASE BACKUP CONTROLFILE TO TRACE When you need to recover the database from the loss of the control file, you recreate the control file with the CREATE CONTROLFILE command. If you are recreating the control file of a database with read-only tablespaces, issue the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command to generate a listing of the special procedures required for recovery. • Evaluate this command: SVRMGR> RECOVER TABLESPACE user_01; Which task will this command accomplish if the database is in ARCHIVELOG mode? Recover the USER_01 tablespace using the archived redo logs. To recover a lost datafile – start up the database in MOUNT mode – take the tablespace with the missing datafile offline – open the database – restore the backup datafile and all offline redolog files with OS commands – recover the datafile (not the database !) – bring the tablespace online. The tablespace will be recovered to the current time and the system will resynchronize the files.
Related Questions
- The recovery operation you are preparing includes read-only tablespaces. Which command can you issue to get a listing of the procedures needed to recover this database?
- How do I get extra copies of the August 31 issue of Wine Spectator that includes the complete listing of all the Restaurant Wine List Awards winners?
- Ingres Version: All OS: VMS Q: I am using VMS with Ingres II installed. When I issue show sys command, why can I find the recovery process dmfrcp?
