單項(xiàng)選擇題

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）

A.Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B.Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C.Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D.Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

你可能感興趣的試題

單項(xiàng)選擇題

You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?（）

A.A different procedure is required to restore a database from compressed backups
B.The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C.Using this command to create backups minimizes the bandwidth consumed.
D.Using this command to create backups improves the performance of the backup process

單項(xiàng)選擇題

You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）

A.The Flashback Archive FLA1 is dropped only if it is empty.
B.The tablespace having Flashback Archive is dropped.
C.The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D.The Flashback Data Archive and historical data are dropped.