单选题RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）A TrueB False
单选题
RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）
A
True
B
False
参考解析
解析：
暂无解析
相关考题：
RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）A、 TrueB、 False
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（） A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
Which RMAN backup command is used to create the block-change tracking file？（） A、 alter database create block change tracking fileB、 alter database enable block change fileC、 alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.filD、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’E、 alter system block change tracking on
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
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
After the recovery is complete， which command should you execute？（）A、ALTER DATABASE OPEN；B、ALTER DATABASE CLEAR LOGFILE；C、ALTER DATABASE OPEN RESETLOGS；D、ALTER DATABASE OPEN NORESETLOGS；
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a， b， c， d， e， fB、 c， d， a， b， fC、 d， c， a， b， fD、 d， b， d， c， eE、 d， c， a， b， e
Which command will result in a trace file being created with the create controlfile command contained in it？（） A、 alter database backup controlfileB、 alter database backup controlfile to traceC、 alter database controlfile backupD、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E、 alter database begin controlfile backup
Which is the correct command to put the database in ARCHIVELOG mode？（） A、 alter database archivelogB、 alter system enable archivelog modeC、 alter database enable archiveD、 alter database archivelog enableE、 None of the above
单选题Which command is used to open the database after an incomplete recovery？（）A alter database openB alter database open repairlogC alter database open resetlogsD alter database open resetlogE alter database resetlogs open
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;ARECOVER DATABASE；BSWITCH DATAFILE ALL；CRESTORE CONTROL FILE；DRECOVER DATABASE USING BACKUP CONTROL FILE；
单选题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
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）A Issue the grant command from the SYS user （or equivalent） of the target database.B Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E Issue the grant command from RMAN when connected to the target database.
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A Flashback logs are not deleted.B Flashback logs are deleted automatically.C Flashback logs are deleted only if you are using Recovery Manager （RMAN）D Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
多选题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.
单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A shutdown restore datafile 4； recover datafile 4； alter database open；B Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.
单选题Which command will result in a trace file being created with the create controlfile command contained in it？（）A alter database backup controlfileB alter database backup controlfile to traceC alter database controlfile backupD alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E alter database begin controlfile backup
单选题When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A a， b， c， d， e， fB c， d， a， b， fC d， c， a， b， fD d， b， d， c， eE d， c， a， b， e
单选题Which RMAN backup command is used to create the block-change tracking file？（）A alter database create block change tracking fileB alter database enable block change fileC alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.filD alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’E alter system block change tracking on
单选题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.
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）AFlashback logs are not deleted.BFlashback logs are deleted automatically.CFlashback logs are deleted only if you are using Recovery Manager （RMAN）.DFlashback logs are deleted only if you are using Oracle Managed Files （OMF）.EFlashback logs are deleted only if you are using Automatic Storage Management （ASM）.
多选题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
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A’SQL ALTER DATABASE OPEN’；BSQL ALTER DATABASE ’OPEN’；COPEN DATABASE；DDATABASE OPEN