Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number

第1题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

• A、 Reregistering the target database in recovery catalog
• B、 Transporting the new tablespaces to the recovery catalog database
• C、 Syncronizing the recovery catalog with the target database control file
• D、 Performing a fresh backup of the target database to include the new data files in the catalog database

第2题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

• A、flash back the database
• B、perform point-in-time recovery
• C、perform a full database recovery
• D、drop and re-create the tablespace
• E、use Recovery Manager （RMAN） to recover the database

第3题：

第4题：

To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

• A、OPEN
• B、MOUNT
• C、NOMOUNT
• D、CLOSE

第5题：

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?（）

• A、Complete Recovery with online redo log
• B、Complete Recovery with archived redo log
• C、Tablespace Point-in-Time Recovery (TSPITR)
• D、Incomplete Recovery with system change number (SCN)

第6题：

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

• A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
• B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
• C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
• D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

第7题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

• A、You must configure block change tracking file
• B、You must have first level 1 backups for RMAN to restore blocks
• C、You must ensure that the SALES database is mounted or open
• D、You must have full or level 0 backups for RMAN to restore blocks
• E、You must take the tools01.dbf data file offline before you start a block media recovery

第8题：

You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

• A、 The log sequence for the database will restart from 1.
• B、 The log sequence number will be written to the control file.
• C、 The log sequence number will be written to the datafile headers.
• D、 The log sequence number will be written to the initialization parameter file.

第9题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

• A、 The target database must be in NOARCHIVELOG mode.
• B、 No backup is required of the database before you perform a TSPITR.
• C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
• D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
• E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

第10题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

• A、Open the database in NORMAL mode
• B、Open the database in read-only mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option