单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）Arestore datafiles until time '09/28/2008:21:03:11'Brestore database files until time '09/28/2008:18:00:00'Crestore database until time '09/28/2008:18:00:00'Drecover database until time '09/28/2008:18:00:00'Erecover database until timestamp '09/28/2008:18:00:00'
单选题
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）
A
restore datafiles until time '09/28/2008:21:03:11'
B
restore database files until time '09/28/2008:18:00:00'
C
restore database until time '09/28/2008:18:00:00'
D
recover database until time '09/28/2008:18:00:00'
E
recover database until timestamp '09/28/2008:18:00:00'
参考解析
解析：
暂无解析
相关考题：
In the video form. the OrderDate field (Which shows When the video may be ordered)is calculated based on the Date field (Which displays the release date ). The order date is 30 days prior to the release date. Which one the following formulas will calculate the OrderDate value?（）A、@Number(Date)-30 B、@Adjust(Date;0;0;30;0;0;0) C、@Adjust(Date;0;0;-30;0;0;0) D、@If(Date!="";Date-30;@Failure(There is no current release date"))
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database
Which of the following best describes a full backup? （）A、All datafiles of a database B、All datafiles, archive logs, and control files C、All datafiles and control files D、All the used blocks in a datafile
Which of the following local files is used to run the date command on the remote machine "Earth" using the following rexec command without request for a password？ rexec Earth date（）。A、~/ .rhostsB、$HOME/.netrcC、/etc/hosts.equivD、/etc/security/user
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order？（） a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN. A、 a， b， c， d， e， f， gB、 b， c， d， g， f， e， aC、 g， f， a， b， c， e， dD、 c， a， d， b， f， e， gE、 g， f， a， b， e， c， d
What information does the report schema command not provide？（） A、 Size of the datafilesB、 Size of the tempfilesC、 Date of last backup for datafiles and tempfilesD、 Filenames for each datafileE、 Checkpoint SCN associated with the last RMAN backup
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?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.A、1，3，6，7B、2，3，6，8C、1，2，3，6，7D、1，2，3，6，，7，8E、2，3，6，5，7
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.
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， gB、b， c， f， hC、a， b， c， f， gD、a， b， c， f， g， hE、b， c， f， e， g
Why would you execute the report obsolete command？（） A、 To list all backups that were no longer available for restore operationsB、 To list all backups that had aged beyond the RMAN retention criteriaC、 To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup mediaD、 To list all datafiles that are no longer part of the database and thus do not need to be backed upE、 To list all archived redo logs that are no longer needed for any database recovery
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A、 all the datafiles in the databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
单选题Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A the datafiles associated with the SYSTEM tablespaceB the datafiles associated to the DATA1 tablespaceC the datafiles associated to the SYSTEM and DATA1 tablespacesD all the datafiles in the database
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）ADrop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. BTake the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. CRestart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.DPut the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B The restore command will fail.C The recover command will fail.D The alter database open resetlogs command will fail.E All these commands will fail because they must be in the confines of a run block.
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
单选题What is the result of this command？（） RMAN Report need backup days 3；A Lists all datafiles created in the last three days that are not backed up.B Lists all datafiles not recoverable based on the current retention criteria.C Lists all datafiles not backed up in the last three days. The datafile is not recoverable. D Lists all datafiles that need to be backed up due to unrecoverable operations.E Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
单选题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.Aa， c， f， gBb， c， f， hCa， b， c， f， gDa， b， c， f， g， hEb， c， f， e， g
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
单选题Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）A Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.B Tell them that their request cannot be met with the current backup strategy.C Restore the 19ths backup， apply the online redo logs，and open the database.D Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo logs，and recover the database to the 20th.E Use the recover database command to roll back the database from today to the 19th of the month.
单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）Aa， b， e， cBb， e， dCa， b， d， cDb， g， c， fEa， b， d， f
单选题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.Aa， c， f， gBb， d， e， hCa， b， c， f， gDd， a， e， gEb， c， f， e， g
单选题You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）A all the datafiles in the databaseB the datafiles associated with the SYSTEM tablespaceC the datafiles associated with the DATA1 tablespaceD all the datafiles in the database except those associated with the DATA1 tablespace
单选题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，6B 2，4，5，3C 4，7，3D 2，4，7，3E 2，7，3