InRecoveryManager(RMAN),youhavesetcontrolfileautobackuptoONbyusingthefollowingcommand:CONFIGURECONTROLFILEAUTOBACKUPONWhichtwoeventswouldcausethecontrolfiletobebackedupautomatically?() A.atablespaceistakenofflineB.thedatabaseinstanceisrestartedC.anewdatafileisaddedtoanexistingtablespaceD.asuccessfulbackupisrecordedintheRMANrepositoryE.theRMANconnectionisdisconnectedfromthetargetdatabase
InRecoveryManager(RMAN),youhavesetcontrolfileautobackuptoONbyusingthefollowingcommand:CONFIGURECONTROLFILEAUTOBACKUPONWhichtwoeventswouldcausethecontrolfiletobebackedupautomatically?()
A.atablespaceistakenoffline
B.thedatabaseinstanceisrestarted
C.anewdatafileisaddedtoanexistingtablespace
D.asuccessfulbackupisrecordedintheRMANrepository
E.theRMANconnectionisdisconnectedfromthetargetdatabase
相关考题：
In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. 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 data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file.Which option must you consider for this task?（）A. using only the RMAN SWITCH command to set the new location for the data fileB. placing the database in the MOUNT state for the restore and recovery operations.C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.D. configuring two channels: one for the restore operation and the other for the recovery operation
InRecoveryManager(RMAN),yousettheretentionpolicytoNONEbyexecutingthefollowingcommand:CONFIGURERETENTIONPOLICYTONONEWhatwouldbetheimpactofthissetting?() A.Theretentionpolicyiscleared.B.RMANdoesnotconsideranybackupasobsolete.C.Theretentionpolicyissettoitsdefaultsettingofredundancy1.D.Theretentionpolicyissettoitsdefaultsettingofrecoverywindow7.
YouexecutedthefollowingcommandinRecoveryManager(RMAN):RMAN>RESTORECONTROLFILEWhichoperationmustyouperformbeforethiscommandisexecuted?() A.backupthecontrolfiletotraceB.bringdatabasetotheMOUNTstateC.openaconnectiontotheRMANrecoverycatalog，whichcontainstheRMANmetadataforthetargetdatabaseD.setthedatabaseID（DBID），butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog
Whenrunningthetablespacepoint-in-timecommandrecovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;youreceivethefollowingerror:RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat10/08/200816:00:30RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacenameUSERSWhatisthelikelycauseoftheerror?（）A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.
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 database2) Take the data file offline3) Bring the data file online4) Use the RMAN SWITCH TO command to switch the image copy5) Apply the archived redo logs6) Open the database7) Use the RMAN RESTORE TO command to switch to the image copyWhich 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
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?() A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption
Youareperformingadatabaserecoverybecauseauser’sschemaisdropped.Whileperformingtherecovery,youusetheUNTILSEQUENCEclause.Whichtypeofdatabaserecoveryareyouperforming?() A.usermanagedcompleterecoveryB.usermanagedincompleterecoveryC.RMAN-basedcompleterecoveryD.RMAN-basedincompleterecovery
ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourdatabase:RMAN>REPORTOBSOLETE;Whatwouldyouseeintheoutput?() A.alistofallthosefilesthathavebeendeletedinthelasttwodaysB.alistofallthosefilesthathavebeenrecoveredwithinthelasttwodaysC.alistofalltheexpiredbackupsandcopiesD.alistofbackupsandcopiesthatareoutsidetherangecoveredbythecurrentretentionpolicy
InRecoveryManager(RMAN),youhavesetcontrolfileautobackuptoONbyusingthefollowingcommand:CONFIGURECONTROLFILEAUTOBACKUPON;Whichtwoeventswouldcausethecontrolfiletobebackedupautomatically?() A.Atablespaceistakenoffline.B.Thedatabaseinstanceisrestarted.C.Anewdatafileisaddedtoanexistingtablespace.D.AsuccessfulbackupisrecordedintheRMANrepository.E.TheRMANconnectionisdisconnectedfromthetargetdatabase.