原 【DB宝9】Oracle 2019 OCP题目解析
1、目前网上留传的题库都是假的。望大家擦亮眼睛,仔细辨别。
2、Oracle 12.1只是Oracle的一个过渡版本,我们工作中常用到的是12cR2、18c(12.2.0.2)和19c(12.2.0.3)。本次2019 OCP培训针对工作内容进行培训。详情请私聊麦老师,QQ:646634621,微信:db_bao
题1、有关控制文件自动备份的题目
1 2 3 4 5 6 7 | Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN? A) It requires the use of fast recovery area (FRA). B) The control file is backed up whenever a new table is created. C) The server parameter file (SPFILE) is automatically backed up each time the control file is backed up. D) The control file is backed up automatically each time the SPFILE is backed up manually. E) The control file is backed up whenever a new tablespace is created. F) The control file is backed up whenever an RMAN backup is successfully recorded in the catalog. |
正确答案:CDE
关于控制文件自动备份内容的官网说明:https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-basic.html#GUID-98BA7492-7108-4DF9-B5A2-21957072E308
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-backup-concepts.html#GUID-95840C84-1595-49AC-923D-310DA750676B
You can configure RMAN to automatically back up the control file and server parameter file. The autobackup occurs whenever a backup record is added.
If the database runs in ARCHIVELOG mode, then an autobackup is also taken whenever the database structure metadata in the control file changes. A control file autobackup enables RMAN to recover the database even if the current control file, recovery catalog, and server parameter file are lost.
By default, control file autobackups are turned on for CDBs and standalone databases that have the COMPATIBLE initialization parameter set to 12.2 or higher.
该题的环境为Oracle 19.3环境,归档模式,以下为rman实验默认配置:
1 2 3 4 5 | RMAN> show all; RMAN configuration parameters for database with db_unique_name LHRCDB2 are: CONFIGURE CONTROLFILE AUTOBACKUP ON; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default |
关于在RMAN中配置控制文件自动备份的说法,正确的3个选项是什么?
对于A选项,可以不用配置FRA,如果配置中不写路径的话会备份到默认路径闪回恢复区FRA,如果闪回恢复区没有设置的话,那么就在$ORACLE_HOME/dbs下,但是告警日志中都会有提示。所以,该选项错误。
对于B选项,在建表后会自动备份控制文件,很显然是错误的。
真实有效,考过的!!
很详细
good