A. If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.
B. If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.
C. If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.
D. If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
您可能感兴趣的试卷
你可能感兴趣的试题
A. backup pieces
B. copies of all the parameter files
C. trace file generated using BACKUP CONTROLFILE TO TRACE
D. control file autobackups
A. The database writer writes to a trace file, indicating that the temporary file is not found.
B. The database prompts for a database recovery.
C. The database opens normally.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.
A. The database must be started in the MOUNT EXCLUSIVE state.
B. The database must have multiplexed control files.
C. The database must be opened by using a text-based parameter file instead of a server parameter file (SPFILE).
D. The database must be in ARCHIVELOG mode.
E. The database must be in the NOMOUNT state.
F. The database must be opened in RESTRICTED mode.
A. The Oracle database will not perform block checking for any of the data blocks.
B. The Oracle database will perform block checking for the default permanent tablespace only.
C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
A. log buffer
B. Java pool
C. Large pool
D. Fixed SGA
E. Shared pool
F. Streams pool
G. Keep buffer cache
H. Database buffer cache
A. Enable flashback logging.
B. Start the database in the ARCHIVELOG mode.
C. Issue the ALTER DATABASE FLASHBACK ON; command.
D. Set the FAST_START_MTTR_TARGET initialization parameter.
A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
A. RBAL
B. CKPT
C. SMON
D. PMON
E. MMON
F. CTWR
G. DBWR
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
最新试题
You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’20040805:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
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?()
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?()
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use?()
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? ()
You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace. What methods can you use to recreate the indexes?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()