【DB宝9】Oracle 2019 OCP题目解析

3    3657    6

👉 本文共约3554个字,系统预计阅读时间或需14分钟。

1、目前网上留传的题库都是假的。望大家擦亮眼睛,仔细辨别。
2、Oracle 12.1只是Oracle的一个过渡版本,我们工作中常用到的是12cR2、18c(12.2.0.2)和19c(12.2.0.3)。本次2019 OCP培训针对工作内容进行培训。详情请私聊麦老师,QQ:646634621,微信:db_bao

题1、有关控制文件自动备份的题目

正确答案: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实验默认配置:

关于在RMAN中配置控制文件自动备份的说法,正确的3个选项是什么?

对于A选项,可以不用配置FRA,如果配置中不写路径的话会备份到默认路径闪回恢复区FRA,如果闪回恢复区没有设置的话,那么就在$ORACLE_HOME/dbs下,但是告警日志中都会有提示。所以,该选项错误。

对于B选项,在建表后会自动备份控制文件,很显然是错误的。

对于C选项,在备份控制文件时,spfile会自动备份。此说法正确。

此时,告警日志文件会记录控制文件自动备份文件的位置:

对于D选项,在手动备份spfile时,控制文件会自动进行备份。此说法正确。

此时,告警日志文件会记录控制文件自动备份文件的位置:

对于E选项,创建表空间后,控制文件也会自动备份,但是会延迟备份,延迟备份的时间由隐含参数“_controlfile_autobackup_delay”控制,默认300秒,即5分钟。这是11g的新特性,10g不会延迟备份,综上所述,该选项说法正确:

告警日志会记录表空间创建语句,控制文件自动备份会延迟进行:

查询隐含参数:

官网资料:

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

Note: Beginning with Oracle Database Release 11g Release 2, RMAN takes only one control file autobackup when multiple structural changes contained in a script (for example, adding tablespaces, altering the state of a tablespace or data file, adding a new online redo log, renaming a file, and so on) have been applied.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog

对于F选项,控制文件自动备份和catalog没有关系,F选项错误。

题2、有关DBUA升级数据库的题目

正确答案;BCE
Oracle 19c - 使用 DBUA 升级数据库到 Oracle Database 19c (19.x) 的完整核对清单 (Doc ID 2577574.1):http://blog.itpub.net/26736162/viewspace-2690457/

使用database upgrade Assistant升级Oracle数据库时,以下哪三项是正确的?

对于选项A,源库的timezone版本应当小于或等于目标数据库timezone版本。题目是must,所以错误。以下SQL可以查询时区文件的版本:

对于选项B,Oracle Application Express即APEX组件,如果安装了APEX,则建议先升级源数据库中的APEX组件,然后再升级DB。也可以升级完DB后再升级APEX组件。所以,B选项正确。升级APEX组件可以参考:http://blog.itpub.net/26736162/viewspace-2222308/

对于选项D,TNSNAMES.ORA中不包含ORACLE_HOME变量,所以错误。

题3、有关使用rman创建PDB的问题

正确答案:BDE

相关知识的官网连接:
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-F31F9FCE-B610-49EB-B9DB-44B9AA4E838F
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-EA6E8219-56BF-471C-AC5A-DFC55E760806
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-539E89F6-C0BC-49CB-8D8C-CD8FF88BAF32
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/rman-duplicating-databases.html#GUID-23205E75-CFA8-4BCE-AC50-3D39DF040512
该题目需要注意,在rman中,克隆一个数据库到一个已经存在的cdb中:

对于选项A,duplicate不支持复制一个非cdb到一个pdb中。

对于选项C,一次不能复制多个pdb,但是可以一次克隆多个pdb到一个不存在的cdb中。

对于选项F,密码可以不用相同。

题4、有关多重复制备份(Duplexed Backup Sets)的题目

正确答案:CE
Duplexed Backup Sets即多重复制备份。多重复制备份可以一次备份在不同路径生成最多4个完全一样的备份片,只能用于备份集,不能用于镜像.可以在磁盘或磁带上使用,但是不能同时在磁盘和磁带上进行多重备份.在磁带上使用时,注意备份集的个数不要超过磁驱的个数.用法:confiuger bakcup set中使用.
BACKUP DEVICE TYPE DISK COPIES 3 DATAFILE 7
FORMAT '/disk1/%U','?/oradata/%U','?/%U';

RMAN支持同时备份4份,同样一个备份集合可以一次备份4份,放到不同地方,以防一个丢失了,其它地方还有。
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV107
In RMAN, you can make multiple, identical copies of backups in the following ways:
Duplex backups with the BACKUP ... COPIES command, in which case RMAN creates multiple copies of each backup set
Back up your files as backup sets or image copies, and then back up the backup sets or image copies with the RMAN BACKUP BACKUPSET or BACKUP COPY OF commands

Duplexed Backup Sets
When backing up datafiles, archived redo log files, server parameter files, and control files into backup pieces, RMAN can create a duplexed backup set, producing up to four identical copies of each backup piece in the backup set on different backup destinations with one BACKUP command. Duplexing is not supported for backup operations that produce image copies.

You can use the COPIES parameter in the CONFIGURE, SET, or BACKUP commands to specify duplexing of backup sets when using the BACKUP command. RMAN can duplex backups to either disk or tape, but cannot duplex backups to tape and disk simultaneously. When backing up to tape, ensure that the number of copies does not exceed the number of available tape devices.

The FORMAT parameter of the BACKUP command specifies the destinations for duplexed backups. The following example creates three copies of the backup of data file 7:
BACKUP DEVICE TYPE DISK COPIES 3 DATAFILE 7
FORMAT '/disk1/%U','?/oradata/%U','?/%U';
RMAN places the first copy of each backup piece in /disk1, the second in ?/oradata, and the third in the Oracle home. RMAN does not produce three backup sets, each with a different unique backup set key. Rather, RMAN produces one backup set with a unique key, and generates three identical copies of each backup piece in the set.

题5、有关RPH的相关题目

RHP: Rapid Home Provisioning Server - Minimum Requirement (文档 ID 2126710.1)
How To Setup a Rapid Home Provisioning (RHP) Server and Client (文档 ID 2097026.1)
http://www.oracle.com/technetwork/database/database-cloud/private/rapid-home-provisioning-2405191.pdf
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sprhp/what-can-i-do-rapid-home-provisioning.html

With Rapid Home Provisioning, you create, store,and manage templates of Oraclehomes as images (called gold images) of Oracle software, such as databases,middleware, and applications.
You can make a working copy of any gold image and then you can provision that working copy to any node in the data center or cloudcomputing environment.

You can use Rapid Home Provisioning to provision, patch, and upgrade single instance databases running on clusters or on single, standalone nodes.
However, Rapid Home Provisioning does not support single-instance databases for Oracle Restart configurations.

Note: Rapid Home Provisioning is not supported on Microsoft Windows and HP-UX Itanium systems.

关于RHP的说法,正确的3个选项是什么?
对于C选项,不仅仅用于Oracle databases,而是middleware和applications都可以,所以C选项错误。
对于D选项,RHP不支持Restart环境的单实例数据库,所以D选项错误。

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

3 条回复

  1. 头像 ocp说道:

    真实有效,考过的!!

  2. 头像 xml说道:

    很详细

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

2 + 10 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部