OCP-1Z0-053-V12.02-599题

最新推荐文章于 2019-01-28 10:17:41 发布

Riveore

最新推荐文章于 2019-01-28 10:17:41 发布

阅读量6.3k

点赞数

分类专栏： OCP-1Z0-053 OCP11g解析

本文链接：https://blog.csdn.net/rlhua/article/details/14648633

版权

OCP11g解析同时被 2 个专栏收录

870 篇文章 151 订阅

订阅专栏

OCP-1Z0-053

796 篇文章 0 订阅

订阅专栏

599.Given the following steps, which would be the correct order to create a backup of an Oracle database

in ARCHIVELOG mode with control-file autobackups enabled?

A. backup archivelog all;

B. backup database all;

C. backup controlfile;

D. backup archivelog, database, controlfile delete input;

E. backup database plus archivelog delete input

F. e

G. a, b, a, c

H. d

I. b, a, c

J. b, a, c, d, e

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF90026

DATABASE

Creates a backup of all data files in the database. If generating a backup set, then RMAN can include only data files and control files: it cannot include archived redo log files.

If the backupSpec includes data file 1, and if CONFIGURE CONTROLFILE AUTOBACKUP is OFF, then RMAN automatically includes the control file in the backup. If the instance is started with a server parameter file, then RMAN also includes this parameter file in the backup.

If the backupSpec includes data file 1, and if CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN does notautomatically include the control file in the output. Instead, RMAN generates a separate control file autobackup piece. If the instance is started with a server parameter file, then RMAN includes this parameter file in the autobackup piece.

Full database backups should usually be either image copies or compressed backup sets. Image copies are more flexible than backup sets for some purposes (such as use in an incrementally updated backups strategy), and compressed backup sets make more efficient use of storage space, if the CPU overhead involved in creating them is tolerable.

Note: To force RMAN to include the current control file in the backup when CONTROLFILE AUTOBACKUP is ON, specify the INCLUDE CURRENT CONTROLFILE clause.

See Also: The TABLESPACE description to learn about backup behavior when the database includes bigfile tablespaces

PLUS ARCHIVELOG

Includes archived redo log files in the backup (see Example 2-15). Causes RMAN to perform the following steps:

Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement.
Run the BACKUP ARCHIVELOG ALL command. If backup optimization is enabled, then RMAN only backs up logs that have not yet been backed up.
Back up the files specified in the BACKUP command.
Run an ALTER SYSTEM ARCHIVE LOG CURRENT statement.
Back up any remaining archived redo log files. If backup optimization is not enabled, then RMAN backs up the logs generated in step 1 plus all the logs generated during the backup.

You cannot specify PLUS ARCHIVELOG on the BACKUP ARCHIVELOG command or BACKUP AS COPY INCREMENTALcommand (or BACKUP INCREMENTAL command when the default backup type is COPY). You cannot specify PLUS ARCHIVELOG when also specifying INCREMENTAL FROM SCN.

Unless the online redo log is archived after the backup, DUPLICATE is not possible with this backup.