單項(xiàng)選擇題

Which command is used to open the database after an incomplete recovery？（）

A. alter database open
B. alter database open repairlog
C. alter database open resetlogs
D. alter database open resetlog
E. alter database resetlogs open

你可能感興趣的試題

單項(xiàng)選擇題

You have lost datafiles 1 and 3 from your database，and the database has crashed.
In what order should you perform the following steps to recover your database？（）
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.

A. 2，1，3，4，5，6
B. 2，4，5，3
C. 4，7，3
D. 2，4，7，3
E. 2，7，3

單項(xiàng)選擇題

If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）

A. Recover the online redo log from backup.
B. Delete and re-create the log file.
C. Use the alter database clear logfile command to clear the log file.
D. Shut down the database and restart it.
E. Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.

Which command is used to open the database after an incomplete recovery？（）

你可能感興趣的試題

If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）

Which command is used to open the database after an incomplete recovery？（）

If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）