Backup control file.
Emergency control file.
The create controlfile command.
The restore controlfile SQL*Plus command.
No backup is required. The database will re-create the control file when it is discovered to be lost.
第1题:
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.
第2题:
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?()
第3题:
What methods are available to recover lost control files?()
第4题:
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
第5题:
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?()
第6题:
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?()
第7题:
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?()
第8题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第9题:
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?()
第10题:
You issued the following RMAN command: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()