What methods are available to recover lost control files？（） A、 Backup control file.B、 Emergency control file.C、 The create controlfile command.D、 The restore controlfile SQL*Plus command.E、 No backup is required. The database will re-create the control file when it is discovered to be lost.
What methods are available to recover lost control files？（）
- A、 Backup control file.
- B、 Emergency control file.
- C、 The create controlfile command.
- D、 The restore controlfile SQL*Plus command.
- E、 No backup is required. The database will re-create the control file when it is discovered to be lost.
相关考题：
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB、Make a copy of the control file with the database shut downC、Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD、Make a copy of the control file with the database still running
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A、Start the instance and open the database， instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（） A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）A、 Restore the lost data file from the backup， and then flash back the database.B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
You issue this RMAN command： RMAN create script Level0Backup { backup incremental level 0 format ‘/u01/db01/backup/%d_%_Sp’ fileperset 5 （database include current controlfile）； sql ‘alter database archive log current’； } Which three statements are true about the Level0Backup script you just created？（）A、The script is stored only in the control file.B、The script is stored only in the recover catalog.C、The script can be executed only by using the RMAN RUN command.D、The commands of the script can be displayed with the LIST command.E、The commands of the script can be displayed with the PRINT command.F、The commands of the script can be displayed with the REPORT command.
In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
Which is not a valid way of backing up a control file？（） A、 Backing up the control file to traceB、 Copying the existing control file of the database to the backup location during a hot backup C、 Copying the existing control file of the database to the backup location during a cold backupD、 Creating a backup control fileE、 Using the create controlfile command
单选题Which is not a valid way of backing up a control file？（）A Backing up the control file to traceB Copying the existing control file of the database to the backup location during a hot backup C Copying the existing control file of the database to the backup location during a cold backupD Creating a backup control fileE Using the create controlfile command
单选题You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）AImage of the control fileBLocation of the control fileCContents of the control file in text formatDSQL command to re-create the databaseESQL command to re-create the control fileFContents of the control file in binary format
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）AA text copy of the control file.BA binary copy of the control file.CA file containing a SQL statement which will re-create the database.DA file containing a SQL statement which will re-create the control file.
单选题You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A take data files from the read-only tablespace offline before performing a recoveryB recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC drop the read-only tablespace and re-create the tablespace after recoveryD perform a recovery； status of the tablespace in control file will be changed automatically
单选题You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）A The control file will be multiplexed.B The control file will be recreated.CThe script containing the CREATE CONTROLFILE statement will be created.D The binary backup of the control file will be created.
单选题In which scenario will you issue the following command？（） SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；A when all the control files are missing and only a binary backup of the current control file existsB when a multiplexed copy of the current control file is missingCwhen all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD when the SPFILE is missing
单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database， instance recovery automatically recoverscontrol filesBCreate a file based on the contents of the trace file and save it to the control file locations and start the databaseCRe-create the database （The recovery of the control file is not possible because you have lost all the control files.）DStart the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.EStart the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
多选题What methods are available to recover lost control files？（）ABackup control file.BEmergency control file.CThe create controlfile command.DThe restore controlfile SQL*Plus command.ENo backup is required. The database will re-create the control file when it is discovered to be lost.
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;ARECOVER DATABASE；BSWITCH DATAFILE ALL；CRESTORE CONTROL FILE；DRECOVER DATABASE USING BACKUP CONTROL FILE；
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）A A user table was lost at the specified time.B A redo log file was lost at the specified time.C The backup control file is on a faster disk than the current one.D The current control file has a different path compared with the intended time of recovery.E The current control file does not match the physical structure of the database at the intended time of recovery.
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command