Question on RMAN

[jaehokim1]

Issue following BACKUP command to create data file backup set:

BACKUP
FORMAT /BACKUP/df_%d_%s_%p.bus
DATABASE filesperset =3 ;


Which two statement are true?
a. The control file was NOT backed up
b. Each data file was copied three times
c. A channel was automatically allocated
d. The archived redo log file were backed up
e. The database was mounted or open when the backup occured.

Can you explain this.. This is from STS 032

[hrishy]

Hi

The answers are A & E.

regards
Hrishy

[jaehokim1]

thanks anyway.. I passed the exam... Just barely..

and I am moving to 033... now...

[ehaskins]

jaehokim1,

Congratulations on passing the B&R exam!

[oca9i2002]

I do not have STS with me, so I do not know the answer.. But I believe the answer is C and E.

The reason is when you issue backup database. it will backup the datafile 1. and when datafile 1 is get backed up, the control file should be backed up too.

[latroy]

I recalled that same question on my B&R exam. I think the answer is A and B

[oca9i2002]

Sorry that I am not sure which version of RMAN we are talking about. RMAN 8 or RMAN 9?


If it is RMAN 9 we are talking about, then

B can not be ture since filesperset is parameter to limit the number of files in one backupset, not parameter of copies.

For A, if you have RMAN 9. You can check whether controlfile autobackup is off. If it is not, turn it off. Then issue backup database/ backup datfile 1/ backup tablespace system. Then you will know the result.

[cravi]

Hi,

I cleared 2 ocp (8i) papers recently.
Is there anyway that i can see my results on the web or I have to wait to see the results on the web until i finish all 5 papers!!!

Thx..

[Sameer]

Originally posted by hrishy
The answers are A & E.

Options C and E are correct

C:\oracle\ora92\bin>rman target / nocatalog

RMAN> show CONTROLFILE AUTOBACKUP ;

RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;

RMAN> list backup of controlfile;

RMAN> list backup;


RMAN> BACKUP FORMAT 'd:\db_backup\df_%d_%s_%p.bus' DATABASE filesperset =3;

Starting backup at 17-OCT-02
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00009 name=C:\ORACLE\ORADATA\ORCL\USERS01.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\ORCL\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\ORCL\INDX01.DBF
channel ORA_DISK_1: starting piece 1 at 17-OCT-02
channel ORA_DISK_1: finished piece 1 at 17-OCT-02
piece handle=D:\DB_BACKUP\DF_ORCL_3_1.BUS comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
.
.
.
.
piece handle=D:\DB_BACKUP\DF_ORCL_5_1.BUS comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: starting piece 1 at 17-OCT-02
channel ORA_DISK_1: finished piece 1 at 17-OCT-02
piece handle=D:\DB_BACKUP\DF_ORCL_6_1.BUS comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:57
Finished backup at 17-OCT-02

RMAN>

Sameer

[stecal]

cravi -

You can see the results (pass/test completed) at http://www.2test.com (after you log in, you can view your test history).