Oracle认证考试
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the fa
题目
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMAN>RESTORE DATABASE； RMAN>RECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQL>ALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）
- A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
- B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
- C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
- D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
参考答案和解析
相似问题和答案
第1题：
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
- A、 by using the RMAN utility
- B、 by using the export/import utility
- C、 by using the ALTER DATABASE command
- D、 by enabling the change tracking feature
正确答案:C
第2题：
For which database operation would you need the database to be in the MOUNT state（）
- A、renaming the control files
- B、re-creating the control files
- C、dropping a user in your database
- D、dropping a tablespace in your database
- E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
正确答案:E
第3题：
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
- A、 Restore and recover the datafile.
- B、 Restore and recover the tablespace.
- C、 Restore and recover the database.
- D、 Restore and recover the control file.
- E、 Restore and recover the parameter file.
正确答案:A
第4题：
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）
- A、the time when the last flashback operation in your database was performed
- B、the time when the first flashback operation in your database was performed
- C、a list of flashback operations performed in your database using SCN and time
- D、the approximate time and the lowest system change number （SCN） to which you can flash back your database
正确答案:D
第5题：
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
- A、renaming the control files
- B、dropping a user in your database
- C、enabling or disabling redo log archiving
- D、dropping a tablespace in your database
- E、re-creating the control files， after you lost all the control files in your database
正确答案:C
第6题：
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）
- A、 Complete database recovery.
- B、 Incomplete database recovery.
- C、 Approximate database recovery.
- D、 Archived database recovery.
- E、 The database could not be recovered with RMAN.
正确答案:B
第7题：
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）
- 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,C
第8题：
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
- A、The database is in mount state.
- B、One of the tablespaces is offline.
- C、One of the tablespaces is read only.
- D、The database operates in ARCHIEVELOG mode.
- E、The database operates in NOARCHIEVELOG mode.
正确答案:E
第9题：
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）
- A、 Yes， if the database is in ARCHIVELOG mode
- B、 Yes， if the database is in NOARCHIVELOG mode
- C、 No， the backup is not usable in any way
- D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
正确答案:C
第10题：
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
- A、 backup database all
- B、 backup compressed database
- C、 backup as compressed backupset database
- D、 backup as compressed backup database plus archivelog all
- E、 backup as compressed backupset database plus compress archivelog all
正确答案:C