网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?（）
A
The database is in ARCHIVELOG mode.
B
There is not a current backup of the database available.
C
The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
D
The USERS tablespace is not eligible for TSPITR because it has invalid objects.
E
The recover tablespace command is incorrect and generates the error.
参考答案
参考解析
解析：
暂无解析
更多 “单选题When running the tablespace point-in-time command recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 10/08/2008 16:00:30 RMAN-20202: Tablespace not found in the recovery catalog RMAN-06019: could not translate tablespace name "USERS" What is the likely cause of the error?（）A The database is in ARCHIVELOG mode.B There is not a current backup of the database available.C The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.D The USERS tablespace is not eligible for TSPITR because it has invalid objects.E The recover tablespace command is incorrect and generates the error.” 相关考题
考题
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 logB、 Complete Recovery with archived redo logC、 Tablespace Point-in-Time Recovery （TSPITR）D、 Incomplete Recovery with system change number （SCN）
考题
When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.
考题
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
考题
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 databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
考题
What RMAN command is used to execute a tablespace point-in-time recovery？（）A、 recoverB、 duplicateC、 restoreD、 copyE、 None of the above
考题
Which command is used to begin a tablespace point-in-time recovery？（） A、 Restore tablespaceB、 Recover tablespaceC、 Tablespace recoverD、 Recover to timeE、 recover datafile
考题
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command. A、a， c， f， gB、b， c， f， hC、a， b， c， f， gD、a， b， c， f， g， hE、b， c， f， e， g
考题
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A、Only bring the tablespace back online.B、Only recover the tablespace and then bring the tablespace back online.C、Shut down the database， recover the data file and then start up the database.D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
考题
In which of the following scenarios is a tablespace recovery required？（）A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeC、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only
考题
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A
Only bring the tablespace back online.B
Only recover the tablespace and then bring the tablespace back online.C
Shut down the database， recover the data file and then start up the database.D
Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E
Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
考题
单选题In which scenario will you perform a cancel-based recovery？（）A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
多选题In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）AAfter the COPY command.BAfter adding a data file in the target database.CAfter adding a tablespace in the target database.DAfter adding a tablespace in the catalog database.EAfter dropping a data file in the catalog database.FAfter running SQL Loader to load a large amount of data.
考题
单选题Which command would correctly start a TSPITR of the USERS tablespace？（）A
recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB
recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC
recover tablespace users to point-in.D
recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE
recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
考题
单选题What is the proper procedure to recover a lost tempfile?（）A
Restore the backup copy of the tempfile from the backup media. B
Re-create the tempfile with the create tempfile command. C
Copy an existing tempfile from another database. D
Re-create the tempfile with the create tablespace command. E
Re-create the tempfile with the alter tablespace command.
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup； there is no need to apply the redo informationB
restore the full database to recover the data up to the point when you performed the backupC
restore the tablespace from the backup and then perform a recovery using the backup control fileD
restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
单选题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 databaseB
perform point-in-time recoveryC
perform a full database recoveryD
drop and re-create the tablespaceE
use Recovery Manager （RMAN） to recover the database
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup; there is no need to apply the redo information B
restore the full database to recover the data up to the point when you performed the backup C
restore the tablespace from the backup， and then perform a recovery using the backup control fileD
restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
考题
单选题Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）A
Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.B
Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.C
Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.D
Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
考题
单选题Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?（）A
6，5，4，7B
10，1，2，5，8C
10，1，2，5，4，9，8D
10，1，5，8，10
考题
单选题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?（）A
Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB
Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC
Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD
Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
考题
多选题When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）AThe SYSTEM tablespace.BThe UNDO tablespace.CAll tablespaces with tables.DAll tablespaces with indexes.ENo tablespaces are automatically restored.
考题
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（）A
Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfilesB
Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGSC
Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfileD
Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted
考题
单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）A
a， b， e， cB
b， e， dC
a， b， d， cD
b， g， c， fE
a， b， d， f
考题
单选题Which command is used to begin a tablespace point-in-time recovery？（）A
Restore tablespaceB
Recover tablespaceC
Tablespace recoverD
Recover to timeE
recover datafile
考题
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
考题
单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）A
recoverB
duplicateC
restoreD
copyE
None of the above
热门标签
最新试卷
