Question on RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Question on RMAN

  1. #1
    Join Date
    Jul 2002
    Posts
    31
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    The answers are A & E.

    regards
    Hrishy

  3. #3
    Join Date
    Jul 2002
    Posts
    31
    thanks anyway.. I passed the exam... Just barely..

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

  4. #4
    Join Date
    Dec 2001
    Location
    New Jersey
    Posts
    292
    jaehokim1,

    Congratulations on passing the B&R exam!
    Edward Haskins, OCP
    OraKnowledge, Inc.
    www.oraknowledge.com

    --"Live" Instructor-led Online Training for Oracle9i, Java and XML--

  5. #5
    Join Date
    Aug 2002
    Posts
    15
    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.





  6. #6
    Join Date
    Oct 2001
    Posts
    10
    I recalled that same question on my B&R exam. I think the answer is A and B

  7. #7
    Join Date
    Aug 2002
    Posts
    15
    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.

  8. #8
    Join Date
    Nov 2000
    Posts
    157

    ocp

    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..
    ravi

  9. #9
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by hrishy
    The answers are A & E.
    Options C and E are correct

    Code:
    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

  10. #10
    Join Date
    May 2002
    Posts
    2,645
    cravi -

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width