Configure backup optimization
Configure the channel to increase MAXOPENFILES
Configure the channel to increase the capacity with the RATE parameter
Configure the channel to adjust the tape buffer size with the BLKSIZE option
第1题:
You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?()
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第2题:
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
第3题:
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
第4题:
Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’;To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()
第5题:
Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()
第6题:
You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? ()
第7题:
An incremental backup requires fewer tapes for restoration than a differential backup.
A differential backup tape takes less time than an incremental backup tape.
A differential backup requires fewer tapes for restoration than an incremental backup.
An incremental backup tape costs less than a differential backup tape.
第8题:
·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and Thursday
·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and Thursday
·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, Thursday
·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday
第9题:
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第10题:
The tape I/O performed is asynchronous
The tape buffer is allocated from the System Global Area (SGA)
The tape buffer is allocated from the Program Global Area (PGA)
Oracle I/O uses an interrupt mechanism to determine when each I/O completes
第11题:
The RMAN parallelizes the backup although the parallelism is not set for a channel.
The backup piece size will be limited to 300 MB.
The operation is accomplished using the default channel available.
Three channels for the tape drive must be configured by setting the parallelism to three.
第12题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第13题:
Which of the following BEST describes the difference between differential and incremental backups?()
第14题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)
第15题:
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true regarding the execution of the above command?()
第16题:
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()
第17题:
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?()
第18题:
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
Use compression when performing tape backups
Configure multiple SBT channels
第19题:
Configure backup optimization
Configure the channel to increase MAXOPENFILES
Configure the channel to increase the capacity with the RATE parameter
Configure the channel to adjust the tape buffer size with the BLKSIZE option
第20题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第21题:
In the Backup utility, use the Restore and Manage Media tab to select the original tape media. Ensure that files will be restored to their original location. Start the restoration and verify that all files are restored successfully.
In the Backup utility, use the Restore and Manage Media tab to select the original tape media. Ensure that files will be restored to a new location. Start the restoration and verify that all files are restored successfully.
In the Backup utility, select the Verify data after the backup completes option. Use the original backup tape to perform another incremental backup. Ensure that all files are verifies successfully.
In the Backup utility, select the Verify data after the backup completes option. Use a new backup tape to perform another incremental backup. When the verification phase of the backup begins, replace the new tape with the original tape. Ensure that all files are verified successfully.
第22题:
redo log files
password file
control file
change tracking file
第23题:
Configure backup optimization
Configure the channel to increase MAXOPENFILES
Configure the channel to increase the capacity with the RATE parameter
Configure the channel to adjust the tape buffer size with the BLKSIZE option