Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> DBA Q

DBA Q

From: Puja <garg_at_iname.com>
Date: Thu, 17 Aug 2000 14:46:15 -0500
Message-ID: <399c40f4_5@data.wt.net>

Any help appreciated.........
Evaluate this command:

rman> run

           2> allocate channel d1 type disk;
           3> format = 'tue-%s_%p.bck';
       4> backup incremental level = 1 cumulative (database);

    Which type of backup will be performed by this command?

   1 full
   2 blocks changed since yesterday's backup     3 blocks changed since ylast week's backup     4 only blocks changed since the last full backup     5 only blocks changed since the last incremental backup

I understand level = 1 stands for only blocks changed since the last imonthly backup. But answer says yesterday's. Why?

Evaluate this command:

rman> run

           2> allocate channel d1 type disk;
           3> format = '/backup/prod_%s_%p.bck';
       4> backup incremental level = 0 (database);

    Which task will this command accomplish?

Back up only the blocks changed since the last full backup. Create an image copy of the entire database. Start an incremental backup strategy.
Enable parallelization for the backup operation.

Ans. Start an incremental backup strategy. Why the an is not = Back up only the blocks changed since the last full backup.

Q. The PROD database has 10 datafiles stored on 2 disk drives. You need to perform a full database backup with 3 files in each backup set. How many channels should you allocate to perform a parallel backup operation?

1
2
3
4
5

To perform a parallel backup operation, allocate two channels of type disk to simultaneously read from the two disk drives that store the ten datafiles to be backed up. What if there are 20 datafiles?

Thanks in advance
Puja Garg Received on Thu Aug 17 2000 - 14:46:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US