V$CONTROLFILE
V$DATABASE
init.ora
DBA FILES
第1题:
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第2题:
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?()
第3题:
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: RMAN>BACKUP 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?()
第4题:
Which two statements are correct about database transportation? ()
第5题:
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?()
第6题:
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?()
第7题:
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()
第8题:
Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
Make a copy of the control file with the database shut down
Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
Make a copy of the control file with the database still running
第9题:
The command restores only the missing control file.
The command restores all the control files.
The command fails because the database is running.
This is the correct way to address this problem.
This is not the correct way to address this problem.
第10题:
when all the control files are missing and only a binary backup of the current control file exists
when a multiplexed copy of the current control file is missing
when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
when the SPFILE is missing
第11题:
Start the instance and open the database, instance recovery automatically recovers control files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第12题:
the V$LOG view
the V$DBFILE view
the V$LOGFILE view
the V$INSTANCE_RECOVERY view
Oracle Enterprise Manager Database Control
第13题:
You executed the following command to start the database: SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205: error in identifying controlfile, check alert log for more info Which view would you query at this stage to investigate this missing control file?()
第14题:
In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()
第15题:
Which three statements are true about the stages of database startup?()
第16题:
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?()
第17题:
In which scenario will you issue the following command?() SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING BACKUP CONTROLFILE;
第18题:
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
第19题:
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
第20题:
When the instance is started
When the database is mounted
When the database is opened
When the database is closed
第21题:
All datafiles of a database
All datafiles, archive logs, and control files
All datafiles and control files
All the used blocks in a datafile
第22题:
Restore the latest whole backup, perform complete recovery, and open the database normally
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
第23题:
alter database controlfile autobacku on
alter system controlfile autobackup on
configure controlfile autobackup on
enable controlfile autobackup
第24题:
V$CONTROLFILE
V$DATABASE
init.ora
DBA FILES