单选题You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）A The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

考题 View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

查看答案

考题 You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN REPORT NEED BACKUP days 3；What would be the output of this command？（）A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days

查看答案

考题 You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？（）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

查看答案

考题 In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?（） (Choose two.)A、2, 6, 4, 5, 3B、1, 2, 4, 5, 3, 6C、1, 2, 4, 6, 3D、1, 2, 7, 5, 3, 6

查看答案

考题 As A DBA， which of the following methods can you use to make a backup of your table？（）A、Recover Manager （RMAN） utilityB、Import utilityC、Export utilityD、O/S backup command

查看答案

考题 Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

查看答案

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

查看答案

考题 It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository

查看答案

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

查看答案

考题 In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）A、 2， 6， 4， 5， 3B、 1， 2， 4， 5， 3， 6C、 1， 2， 4， 6， 3D、 1， 2， 7， 5， 3， 6

查看答案

考题 If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list

查看答案

考题 Which statement about using RMAN stored scripts is true?（）A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

查看答案

考题单选题Which statement about using RMAN stored scripts is true？（）A To create and execute an RMAN stored script，you must use a recovery catalog.B When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

查看答案

考题多选题In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?（） (Choose two.)A2, 6, 4, 5, 3B1, 2, 4, 5, 3, 6C1, 2, 4, 6, 3D1, 2, 7, 5, 3, 6

查看答案

考题多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.

查看答案

考题单选题You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）A The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

查看答案

考题单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题多选题You issue this RMAN command： RMAN create script Level0Backup { backup incremental level 0 format ‘/u01/db01/backup/%d_%_Sp’ fileperset 5 （database include current controlfile）； sql ‘alter database archive log current’； } Which three statements are true about the Level0Backup script you just created？（）AThe script is stored only in the control file.BThe script is stored only in the recover catalog.CThe script can be executed only by using the RMAN RUN command.DThe commands of the script can be displayed with the LIST command.EThe commands of the script can be displayed with the PRINT command.FThe commands of the script can be displayed with the REPORT command.

查看答案

考题单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

查看答案

考题单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？（）A Only the SET command must be within a RUN block.B All commands should be executed at the RMAN prompt.C All three commands must be within a single RUN block.D Only the RESTORE and RECOVER commands must be within a single RUN block.

查看答案

考题多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？（）AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

查看答案

考题单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?（）A It produces a warning for new failures before advising for CRITICAL and HIGH failures.B It ignores new failures and considers the failures listed in the last LIST FAILURE command only.C It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.D It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

查看答案

考题单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A You need to perform the restore and recover operations manually, because the backup was made manually. B First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

查看答案

考题单选题When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?（）A The database is in ARCHIVELOG mode.B There is not a current backup of the database available.C The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D The USERS tablespace is not eligible for TSPITR because it has invalid objects.E The recover tablespace command is incorrect and generates the error.

查看答案

考题单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list

查看答案

考题单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

查看答案

考题多选题In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）A2， 6， 4， 5， 3B1， 2， 4， 5， 3， 6C1， 2， 4， 6， 3D1， 2， 7， 5， 3， 6

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：