You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）A. To store the backup information of multiple databa

题目

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

A. To store the backup information of multiple database

B. To restrict the amount of space that is used by the backups

C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

D. To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

相似考题

1.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

2.Youexecutedthefollowingcommandtostartthedatabase：SQL>STARTUPORACLEinstancestarted.TotalSystemGlobalArea281018368bytesFixedSize789000bytesVariableSize229635576bytesDatabaseBuffers50331648bytesRedoBuffers262144bytesORA-00205：errorinidentifyingcontrolfile，checkalertlogformoreinfoWhichviewwouldyouqueryatthisstagetoinvestigatethismissingcontrolfile？（）A.V$INSTANCEB.V$CONTROLFILEC.DBA_CONTROL_FILESD.V$DATABASE_PROPERTIESE.V$CONTROLFILE_RECORD_SECTION

3.Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.

4.YouwantanASMinstancetomanagethefilesofyourdatabase.Toachievethisobjective，youspecifythefollowingparametersintheparameterfileofthedatabase：INSTANCE_TYPE=RDBMSDB_NAME=PRODLARGE_POOL_SIZE=8MBDB_BLOCK_SIZE=4KLOG_ARCHIVE_DEST=+dgroupALOG_ARCHIVE_FORMAT="$ORACLE_SID_%s_%t.%t"DB_CREATE_FILE_DEST=+dgroupACOMPATIBLE=10.1.0.2.0CONTROL_FILES=+dgroupAWhichparameterwouldbeignoredwhilestartinguptheinstanceforthedatabasePROD？（）A.DB_BLOCK_SIZEB.CONTROL_FILESC.LARGE_POOL_SIZED.LOG_ARCHIVE_DESTE.LOG_ARCHIVE_FORMATF.DB_CREATE_FILE_DEST

更多“You are using the control file to maintain information about the database backups that are ”相关问题

  • 第1题：

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案：B

  • 第2题：

    Whileinstallinganapplication，theadministratorisinstructedtoperformtwofinaltaskspriortostartingtheapplication：1.Settheownershipofafilenamed’control_file’tobeownedbytheuser’database’andthegroup’appsrvr’.2.Changethepermissionsof’control_file’to0766.Afterthesetwotaskshavebeencompleted，whatwillthefilepermissionslooklikewhen’ls-lcontrol_file’isexecuted？（）

    A.-rwxrw-rw-1databaseappsrvr4913Mar1708：24control_file

    B.-rw-r--r--1appsrvrdatabase4913Mar1708：24control_file

    C.-rw-r--r--1databaseappsrvr4913Mar1708：24control_file

    D.-rwxrw-rw-1appsrvrdatabase4913Mar1708：24control_file


    参考答案：A

  • 第3题：

    使用数据库初始化参数文件中的()参数可以指定控制文件名。

    A.CONTROL_FILES

    B.CONTROL_FILES_NAME

    C.CONTROL_NAME

    D.CONTROL_FILE


    参考答案：A

  • 第4题：

    Which command should an administrator use to view files and volume group backup information from a mksysb called server1.mksysb that is found in ／backups?()

    A.lsmksysb -l /backups/server1.mksysb

    B.showmksysb -f /backups/server1.mksysb

    C.listvgbackup -f /backups/server1.mksysb

    D.showvgbackup -l /backups/server1.mksysb


    参考答案：C

  • 第5题：

    WhichtwostatementsregardingthecontrolfileandRecoverManageraretrue?()

    A.Thecontrolfilecangrowinsize.

    B.ThecontrolfilecanstoreRMANscripts.

    C.CONTROL_FILE_RECORD_KEEP_TIMEdeterminesretentiontimeforRMANrecords.

    D.TheRMANcatalogcanexistsolelyinthecontrolfileofthetargetdatabase.


    参考答案：C, D

  • 第6题：

    ______ has many elements: text, audio sound, static graphics images, animations, and video.

    A.Multimedia]
    B.DatabasE.C.File]
    D.Document

    答案：A
    解析：
    多媒体有如下多种元素：文本、音频、静态图像、动画和视频。

相关内容