OCP-1Z0-052-V8.02-84题

84. Which two files in the database can be configured for automatic backups by using the autobackup

feature in Recovery Manager (RMAN)? (Choose two.)

A.data files

B.control files

C.parameter file

D.online redo log files

E.server parameter file

Answer: BE

答案解析：

实验参考：

全库备份一次，在最后会自动备份控制文件和spfile文件。

RMAN> backup database;

Starting backup at 2013-10-12:20:29:51

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=226 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=38 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=132 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oracle/oradata/test0924/sysaux01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/test0924/fla_tbs02.dbf

input datafile file number=00009 name=/u01/app/oracle/oradata/test0924/undotbs01.dbf

channel ORA_DISK_1: starting piece 1 at 2013-10-12:20:29:57

channel ORA_DISK_2: starting full datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/test0924/system01.dbf

input datafile file number=00007 name=/u01/app/oracle/oradata/test0924/fla_tbs01.dbf

input datafile file number=00010 name=/u01/app/oracle/oradata/test0924/inventory01.dbf

channel ORA_DISK_2: starting piece 1 at 2013-10-12:20:29:58

channel ORA_DISK_3: starting full datafile backup set

channel ORA_DISK_3: specifying datafile(s) in backup set

input datafile file number=00005 name=/u01/app/oracle/oradata/test0924/example01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/test0924/undotbs02.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/test0924/users01.dbf

channel ORA_DISK_3: starting piece 1 at 2013-10-12:20:29:59

channel ORA_DISK_3: finished piece 1 at 2013-10-12:20:33:55

piece handle=/u01/app/oracle/fast_recovery_area/TEST0924/backupset/2013_10_12/o1_mf_nnndf_TAG20131012T202954_95mtdb8h_.bkp tag=TAG20131012T202954 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:03:56

channel ORA_DISK_2: finished piece 1 at 2013-10-12:20:42:37

piece handle=/u01/app/oracle/fast_recovery_area/TEST0924/backupset/2013_10_12/o1_mf_nnndf_TAG20131012T202954_95mtd7vq_.bkp tag=TAG20131012T202954 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:12:39

channel ORA_DISK_1: finished piece 1 at 2013-10-12:20:43:07

piece handle=/u01/app/oracle/fast_recovery_area/TEST0924/backupset/2013_10_12/o1_mf_nnndf_TAG20131012T202954_95mtd809_.bkp tag=TAG20131012T202954 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:13:10

Finished backup at 2013-10-12:20:43:07

Starting Control File and SPFILE Autobackup at 2013-10-12:20:43:08

piece handle=/u01/app/oracle/fast_recovery_area/TEST0924/autobackup/2013_10_12/o1_mf_s_828650588_95mv4ytt_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2013-10-12:20:43:15