A. control file
B. RMAN files
C. password file
D. parameter file
E. flashback logs
F. data file copies
G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus
您可能感兴趣的试卷
你可能感兴趣的试题
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
A. The location used for control files.
B. The location used for redo log files.
C. The location set by using $ORACLE_BASE
D. The location set by using $ORACLE_HOME
E. The location set by using CORE_DUMP_DEST
F. The location set by using BACKGROUND_DUMP_DEST
A. It would result in an error because the template cannot be used along with the disk group.
B. It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C. It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.
D. It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.
A. The database re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries, no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
A. Export and import the mapping table.
B. Drop and re-create the mapping table.
C. Truncate the mapping table and reinsert the values.
D. Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.
A. The subplan must belong to the consumer group, SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for a user.
D. You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
A. RMAN image copies.
B. RMAN database backups.
C. RMAN tablespace backups.
D. User-managed backups placed in the flash recovery area.
E. User-managed backups that have been cataloged with RMAN.
F. User-managed data file backups for which the pull path name is specified.
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
最新试题
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
The loss of the control file forced you to recreate the control file. After recreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a fivedigit number starting with 0. What could be the possible reason?()
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()