单项选择题
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：
SQL>ALTER DATABASE OPEN RESETLOGS；
Which of the following options is true about using the RESETLOGS option？（）
A. The log sequence is reset to 0.
B. All the online redo logs are deleted.
C. All the archived redo logs from a previous incarnation become useless.
D. The full database backup taken from a previous incarnation can be used in future.
E. Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
相关考题
-
多项选择题
YouaremaintainingyourdatabaseinOracle10g.Youperformafulluser-managedbackupeverySundayat8：00P.M.YourdatabaseisrunninginARCHIVELOGmode.OnMonday，at9：00A.M.，atablespaceisdropped.Youdecidetoperformincompleterecoverytorecoverthedroppedtablespace.WhichtwoclausescanyouusewiththeRECOVERcommand？（）
A. UNTIL SEQUENCE
B. UNTIL SCN
C. UNTIL CHANGE
D. UNTIL CANCEL -
单项选择题
In which situation will you run the script containing the following statement？（） CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 （ ’/disk1/prod/orders/db/log1a.dbf’， ’/disk2/prod/orders/db/log1b.dbf’ ）SIZE 100K GROUP 2 （ ’/disk1/prod/orders/db/log2a.dbf’， ’/disk2/prod/orders/db/log2b.dbf’ ） SIZE 100K， DATAFILE ’/disk1/prod/orders/db/database1.dbf’， ’/disk2/prod/orders/db/file1.dbf ’；
A. when all the control files are missing and only a binary backup of the current control file exists
B. when a multiplexed copy of the current control file is missing
C. when all the control files are missing and only an ASCII representation of the binary control file exists
D. when the SPFILE is missing -
多项选择题
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL> ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）
A. The DBWn process writes to the datafile.
B. Changes in the background process are recorded.
C. The log file is updated with the current SCN number.
D. The System Change Number （SCN） is recorded in the control file.
E. The changes to the listener configuration in the listener.ora file are recorded.
