A complete database backup to media is taken for your database every day. Which three
actions would you take to improve backup performance?
A.
Set the backup_tape_io_slaves parameter to true.
B.
Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
C.
Configure large pool if not already done.
D.
Remove the rate parameter, if specified, in the allocate channel command.
E.
Always use RMAN compression for tape backups rather than the compression provided by
media manager.
F.
Always use synchronous I/O for the database.
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
I’m not agree with the F point ….
C maybe better
me too
Answer is BCD
Check
Tuning RMAN Backup Performance: Procedure
Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section:
Step 1: Remove RATE Parameters from Configured and Allocated Channels
Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES
Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE
Step 4: Tune RMAN Tape Streaming Performance Bottlenecks
Step 5: Query V$ Views to Identify Bottlenecks
Thanks Vonpire!
B, C, D Thanks Vonpire!
Answer is BCD
Check
Tuning RMAN Backup Performance: Procedure
Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section:
Step 1: Remove RATE Parameters from Configured and Allocated Channels
Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES
Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE
Step 4: Tune RMAN Tape Streaming Performance Bottlenecks
Step 5: Query V$ Views to Identify Bottlenecks
ACD
Note that they say the backup is done to “media”. Why don’t they say disk?
If it’s to tape, then you should set BACKUP_TAPE_IO_SLAVES parameter to true and ensure that the LARGE_POOL_SIZE is set. Just like with disk backups, removing RATE would be a good idea too.
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtunin.htm#BABDCEHG
Thanks Steve to find out idea to tape. Not to disk. ACD
The device that actually holds the data is known as the storage medium (“media” is the plural). A media can be disk or tape.
I would go for BCD.
BCD is correct answer
BCD
http://docs.oracle.com/cd/E16338_01/backup.112/b56269/rcmtunin.htm#BABDCEHG
This website was… how do I say it? Relevant!! Finally I have found something which helped me. Many thanks!|
BCD