Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performi

题目
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()

A. Creating the control file for the duplicate database

B. Restoring the target data files to the duplicate database

C. Performing complete recovery using all available backups

D. Generating a new, unique DBID for the duplicate database

E. Copying the online redo log files from the target database to the duplicate database

相似考题

1.Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the following command:SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE ‘/mydir/rman_change_track.f‘;To perform incremental level 1 cumulative backup, you issued the following command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two statements are true in the above situation?（）A. The block change tracking data will be used only from the next incremental 0 backup.B. The incremental backup will use change tracking data for accomplishing the backup.C. The incremental backup will not use change tracking data for accomplishing the backup.D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

2.Examinethefollowingcommandusedtoperformincrementallevel0backup：RMAN>BACKUPINCREMENTALLEVEL0DATABASE；Toenabletheblockchangetracking，aftertheincrementallevel0backupyouissuedthefollowingcommand：SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE’/mydir/rman_change_track.f’；Toperformincrementallevel1cumulativebackup，youissuedthefollowingcommand：RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE；Whichtwostatementsaretrueintheabovesituation？（）A.Theblockchangetrackingdatawillbeusedonlyfromthenextincremental0backup.B.Theincrementalbackupwillusechangetrackingdataforaccomplishingthebackup.C.Theincrementalbackupwillnotusechangetrackingdataforaccomplishingthebackup.D.Theblocktrackfilewillscanalltheblocksandcreatebitmapforalltheblocksbackedupinthelevel0backup.

3.YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET

4.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

更多“Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?() ”相关问题

  • 第1题：

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案：B

  • 第2题：

    YouaremaintainingthePRODdatabaseforNetFxCorporation.Youhaveconfiguredcontrolfileautobackupinyourdatabase.At6：00P.M.onMonday，youissuethefollowingcommand：RMAN>BACKUPDATABASE；At8：00A.M.onTuesday，youareunabletostartthedatabasebecauseallthecontrolfilesaremissing.YoudecidetorestorethecontrolfilesfromthebackupbyusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command.WhichoperationshouldyouperformbeforeusingtheRMAN>RESTORECONTROLFILEFROMAUTOBACKUP；command？（）


    参考答案：C

  • 第3题：

    YouwouldliketocreateanRMANrecovercatalog&e

    YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder？（）

    1.Granttheappropriateprivileges（CONNECTandRESOURCE）androles

    （RECOVERY_CATALOG_OWNER）totheuserresponsibleforperformingbackupandrecoveroperations.

    2.Registerthetargetdatabaseinthecatalog.

    3.CreatethecatalogusingtheRMANcommandlineinterpreter.

    4.Createauserandschemawhichwillowntherecoverycatalog.

    5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.

    6.ConnecttothetargetdatabaseusingSYSDBAprivileges.


    参考答案：E

  • 第4题：

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案：B

  • 第5题：

    You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?（）

    A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

    B. The change tracking file must always be backed up when you perform a full database backup.

    C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

    D. More than one database block may be read by an incremental backup for a change made to a single block.

    E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.


    参考答案：B, C, E

  • 第6题：

    在对RMAN用户进行授权时,不需要授予的权限是()。

    A.CONNECT

    B.RECOVERY_CATALOG_OWNER

    C.DBA

    D.RESOURCE


    参考答案：C

相关内容