A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
您可能感兴趣的试卷
你可能感兴趣的试题
A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
A. Multiple change tracking files can be created for a database.
B. The change tracking file must be created after the first level 0 backup.
C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again,after whole database restore and recovery operations.
You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.()
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
A. ALTER DISKGROUP misc MOUNT
B. ALTER DISKGROUP misc DROP DISK misc2
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR
D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m
E. ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’
A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted.
What steps should you take to recover from this tempfile loss in an efficient manner?()
A. Allow the database to continue running,drop the TEMP tablespace,and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup,and then open the database with RESETLOGS
C. Allow the database to continue running,take the TEMP tablespace offline,drop the missing tempfile,and then create a new tempfile
D. Allow the database to continue running,add a new tempfile to TEMP tablespace with a new name,and drop the tempfile that has been corrupted
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?()
A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file
3) Start the target database instance
4) Mount the database
5) Restore the data files
6) Open the database with RESETLOGS option
7) Recover the data files
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?()
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
最新试题
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this: 1. Set the retention target: SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; 2. Enable Flashback Database: SQL> ALTER DATABASE FLASHBACK ON; 3. Mount the database: SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE 5. Open the database: SQL> ALTER DATABASE OPEN; Choose the correct sequence.()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()
Which three tasks can be performed using a duplicate database?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Which two client requests are captured during database replay Capture?()
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?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
Which two statements are true about encrypting RMAN backup?()
Which three statements are true about windows?()
Which two commands never trigger an implicit rebalancing within the disk group?()