单项选择题

A.a， b， c， dB.b， d， e， cC.a， b， d， e， cD.b， f， d， f， cE……

Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）
a. Issue a checkpoint.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.

A.a， b， c， d
B.b， d， e， c
C.a， b， d， e， c
D.b， f， d， f， c
E.b， d， a， c

<上一题目录下一题>

热门试题

多项选择题WhichfileswillyouneedtoperformafullrecoveryofadatabasebackedupinNOARCHIVELOGmode？（）

A. Database datafiles
B. Control files
C. Archived redo logs
D. Online redo logs
E. Flashback logs

单项选择题You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.

A.a， b， f， g
B.c， f， g
C.a， d， f， g
D.a， f， g
E.a， e， g

单项选择题You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.

A.a， c， f， g
B.b， d， e， h
C.a， b， c， f， g
D.d， a， e， g
E.b， c， f， e， g

单项选择题Assoonasyoudiscoverthatyouhavelostanonlineredolog，ifthedatabaseisstillfunctioning，whatshouldbeyourfirstaction？（）

A. Shut down the database
B. Clear the online redo log
C. Back up the database
D. Checkpoint the database
E. Call Oracle support

单项选择题Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.

A.a， c， f， g
B.b， c， f， h
C.a， b， c， f， g
D.a， b， c， f， g， h
E.b， c， f， e， g