A.Datafiles
B. Current control file
C. Server parameter file （spfile）
D. Password file
您可能感兴趣的试卷
你可能感兴趣的试题
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.
RMAN> COPY DATAFILE 2 TO ’D：\ORACLE\ORA90\MYNEWDB\DA2.DBF’；
Which two statements are true regarding the backup created using this command？（）
A. The copy of the datafile created is stored in the RMAN repository.
B. The copy of the datafile created can be viewed using the LIST BACKUP command.
C. The copy of the datafile created using this COPY command can be placed only on the disk.
D. The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
E. The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
A. the system change number
B. the locations of the redo log files
C. the locations of the datafiles
D. the physical location of all the database changes
In which scenario， will you issue the following command？（）
RMAN> REPORT NEED BACKUP DAYS 7；
A. to configure RMAN to maintain backup information in the RMAN repository for seven days
B. to configure RMAN to maintain backup information in the control file for at least seven days
C. to display the list of files that have not been backed up for the last seven days
D. to display the list of files that must be backed up within seven days
A. The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
B. The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
C. The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
D. The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace：
RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；
Which statement is true about executing this command？（）
A. The command generates an error.
B. The command backs up the tablespace and creates a backup set of size 200 MB
C. The command backs up the tablespace and creates two backup sets of size 100 MB each.
D. The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；
RMAN> BACKUP DATABASE；
Which files from the database will be backed up as a result of this BACKUP command？（）
A. control file
B. all datafiles
C. password file
D. online redo log file
E. archive redo log file
F. server parameter file
G. only the SYSTEM datafile
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.
Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
A. 0
B. 1
C. NONE
D. DEFAULT
A. rman TARGET / NOCATALOG
B. rman TARGET sys/password
C. rman TARGET sys/password AS SYSDBA
D. rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
A. Zero
B. One or more
C. NONE
D. DEFAULT
You issued the RMAN>SHOW ALL； command. The output of this command is as follows：
After analyzing the output， which conclusion will you draw？（）
A. The current control file is not automatically backed up every time you perform a backup.
B. The backups save space on the storage media.
C. While performing backups across a network， the network bandwidth is reduced.
D. The backups consist of backup pieces.
最新试题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）
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？（）
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？（）
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 executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）
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 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？（）
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？（）
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？（）
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario， which statement is true？（）