Correct Answer: AB

ARBn (ASM Rebalance Process): Rebalances data extents within an ASM disk group, possible processes are ARB0-ARB9 and ARBA.

ALTER DISKGROUP..POWER clause, specify a value from 0 to 11, where 0 stops the rebalance operation and 11 permits Oracle ASM to execute the rebalance as fast as possible. The value you specify in the POWER clause defaults to the

value of the ASM_POWER_LIMIT initialization parameter. If you omit the POWER clause, then Oracle ASM executes both automatic and specified rebalance operations at the power determined by the value of the ASM_POWER_LIMIT

initialization parameter.

Note:

Beginning with Oracle Database 11g Release 2 (11.2.0.2), if the COMPATIBLE.ASM disk group attribute is set to 11.2.0.2 or higher, then you can specify a value from 0 to 1024 in the POWER clause.

Correct Answer: B

Key points:

1.

The COMPATIBILITY.ASM>=11.1 and COMPATIBILITY.RDBMS>=11.1

2.

The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr.

Refer to here.

Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to "Disk Group Compatibility".

Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage.

The extents are resynced when the disk is brought back online. By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a

time interval to repair the disk and bring it back online.

Correct Answer: B

job_type

Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

Correct Answer: D

Correct Answer: D

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTDB are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/ dbs/snapcf_testdb.f'; # default

RMAN> Backup database plus archivelog delete input;

Starting backup at 19-DEC-13 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=10 RECID=5 STAMP=834597174 input archived log thread=1 sequence=11 RECID=6 STAMP=834597417 channel ORA_DISK_1: starting piece 1 at 19-DEC-13 channel ORA_DISK_1: finished piece 1 at 19-DEC-13 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/ o1_mf_annnn_TAG20131219T163657_9c5d1bn3_.bkp tag=TAG20131219T163657 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 channel ORA_DISK_1: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/ o1_mf_1_10_9c5csl13_.arc RECID=5 STAMP=834597174 archived log file name=/u01/app/oracle/ fast_recovery_area/TESTDB/ archivelog/2013_12_19/o1_mf_1_11_9c5d19cn_.arc RECID=6 STAMP=834597417 Finished backup at 19-DEC-13

Starting backup at 19-DEC-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in

backup set input datafile file number=00001 name=/u01/app/oracle/oradata/testdb/system01.dbf input

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

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

name=/u01/app/oracle/oradata/testdb/undotbs01.dbf input datafile file number=00004 name=/u01/app/

oracle/oradata/testdb/users01.dbf channel ORA_DISK_1: starting piece 1 at 19-DEC-13

channel ORA_DISK_1: finished piece 1 at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/

o1_mf_nnndf_TAG20131219T163703_9c5d1j8c_.bkp tag=TAG20131219T163703 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05 Finished backup at 19-DEC-13

Starting backup at 19-DEC-13

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=12

RECID=7 STAMP=834597550 channel ORA_DISK_1: starting piece 1 at 19-DEC-13

channel ORA_DISK_1: finished piece 1 at 19-DEC-13

piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2013_12_19/

o1_mf_annnn_TAG20131219T163911_9c5d5hlk_.bkp tag=TAG20131219T163911 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 channel ORA_DISK_1: deleting

archived log(s)

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB/ archivelog/2013_12_19/

o1_mf_1_12_9c5d5g7r_.arc RECID=7 STAMP=834597550

Finished backup at 19-DEC-13

Starting Control File and SPFILE Autobackup at 19-DEC-13 piece handle=/u01/app/oracle/

fast_recovery_area/TESTDB/autobackup/2013_12_19/ o1_mf_s_834597553_9c5d5lz1_.bkp

comment=NONE

Finished Control File and SPFILE Autobackup at 19-DEC-13 RMAN> list backup;