单选题In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （

题目
单选题
In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）
A

%t_%s.dbf

B

arch_%t.arc

C

arch_%d.arc

D

arch_%t_%d.arc

E

arch_%d_%s_.dbf

F

arch_%t_%s_%r.arc

相似考题

1.The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery

2.You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.

3. The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery

4.Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

更多“单选题In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （”相关问题

  • 第1题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第2题：

    You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

    • A、to uniquely identify the archived log files with the restore operation
    • B、to uniquely identify the archived log files with the redo log group number
    • C、to uniquely identify the archived log files for each incarnation of the database
    • D、to uniquely identify the archived log files with the number of recovery operations performed

    正确答案:C

  • 第3题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

    • A、Open the database in NORMAL mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第4题：

    In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）

    • A、%t_%s.dbf
    • B、arch_%t.arc
    • C、arch_%d.arc
    • D、arch_%t_%d.arc
    • E、arch_%d_%s_.dbf
    • F、arch_%t_%s_%r.arc

    正确答案:F

  • 第5题：

    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

    • A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
    • B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
    • C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
    • D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

    正确答案:D

  • 第6题：

    单选题
    Which statement about recovering from the loss of a redo log group is true？（）
    A

     If the lost redo log group is ACTIVE， you should first attempt to clear the log file.

    B

     If the lost redo log group is CURRENT， you must clear the log file.

    C

     If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.

    D

     If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）
    A

     The log sequence for the database will restart from 1.

    B

     The log sequence number will be written to the control file.

    C

     The log sequence number will be written to the datafile headers.

    D

     The log sequence number will be written to the initialization parameter file.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


    正确答案： C,D
    解析： 暂无解析

  • 第9题：

    单选题
    You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
    A

    loss of a tempfile

    B

    loss of a system data file

    C

    loss of one of the control files

    D

    loss of one of the tablespaces

    E

    loss of a member from each redo log group

    F

    loss of the only member of an unarchived redo log group


    正确答案： E
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
    A

    Open the database in NORMAL mode

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information？（）
    A

    V$LOGFILE

    B

    V$RECOVER_LOG

    C

    V$RECOVER_DATABASE

    D

    V$LOG_RECOVER

    E

    V$LOG


    正确答案： A,D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:D

  • 第14题：

    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

    • A、 The archived redo log files will be overwritten.
    • B、 The archived redo log files are deleted automatically.
    • C、 The archived redo log files should be moved to some other location.
    • D、 The archived redo log files are still maintained because the file names are unique.

    正确答案:D

  • 第15题：

    Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）

    • A、RMAN recovers up to log sequence 230， but not including 230.
    • B、RMAN returns an error because the log sequence number mentioned in the command should be 229.
    • C、RMAN returns an error because the log sequence number mentioned in the command may never be missing.
    • D、RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

    正确答案:A

  • 第16题：

    Which statement about recovering from the loss of a redo log group is true?（）

    • A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
    • B、If the lost redo log group is CURRENT, you must clear the log file.
    • C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
    • D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

    正确答案:D

  • 第17题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

    • A、You find that one of the redo log members in each redo log group is lost.
    • B、You find that a data file that belongs to the USERS tablespace is damaged.
    • C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、You find that the current redo log group is damaged and is not available for recovery.
    • E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第18题：

    单选题
    Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1； 3> ALTER DATABASE MOUNT；  4> RESTORE DATABASE；  5> RECOVER DATABASE；  6> ALTER DATABASE OPEN RESETLOGS；  7> }；  With reference to this scenario， which statement is true？（）
    A

     RMAN recovers up to log sequence 230， but not including 230.

    B

     RMAN returns an error because the log sequence number mentioned in the command should be 229.

    C

     RMAN returns an error because the log sequence number mentioned in the command may never be missing.

    D

     RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）
    A

     The archived redo log files will be overwritten.

    B

     The archived redo log files are deleted automatically.

    C

     The archived redo log files should be moved to some other location.

    D

     The archived redo log files are still maintained because the file names are unique.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）
    A

    %t_%s.dbf

    B

    arch_%t.arc

    C

    arch_%d.arc

    D

    arch_%t_%d.arc

    E

    arch_%d_%s_.dbf

    F

    arch_%t_%s_%r.arc


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）
    A

     Restore the latest whole backup，perform complete recovery，and open the database normally 

    B

     Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.

    C

     Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.

    D

     Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）
    A

    A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 

    B

    During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 

    C

    After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 

    D

    At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


    正确答案： B
    解析： 暂无解析

相关内容