A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
您可能感兴趣的试卷
你可能感兴趣的试题
A. Enable the flash recovery area and specify it as the archived redo log destination.
B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
C.Enable the flash recovery area but do not specify it as the archived redo log destination.
D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
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?()
A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the USERS tablespace?()
A. The database will open, and the tablespace automatically comes out of the backup mode.
B. The database will be mounted, and recovery must be performed on the USERS tablespace.
C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
A. Stored scripts in the recovery catalog
B. Backups that can be deleted from disk
C. Backup sets and images copies that are obsolete
D. Backups that do not have the AVAILABLE status in the RMAN repository
Examine the following commands and their output:
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050
QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';
1 row updated.
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row?()
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup
Examine the following scenario:
-Database is running in ARCHIVELOG mode.
-Complete consistent backup is taken every Sunday.
-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
-The disk having active online redo log files is also corrupted.
-The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?()
A. Restore the latest whole backup, perform complete recovery, and open the database normally
B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option
C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
最新试题
Which three statements are true about persistent configuration?()
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?()
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?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
Which two commands never trigger an implicit rebalancing within the disk group?()
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
Examine the parameter setting in your database:Which statement is correct about the database?()
Which three functions are performed by the SQL Tuning Advisor? ()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()