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.
第1题:
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()
第2题:
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
第3题:
Examine the following RMAN command: BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06; Which two statements are true regarding the backup taken by using the above RMAN command?()
第4题:
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
第5题:
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?()
第6题:
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file , C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN, how would you respond to this error?()
第7题:
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?()
第8题:
shut down and restart the instance
add new tempfiles to the temporary tablespaces after recovery
perform a media recovery and open the database with the RESETLOGS option
perform a media recovery and bring the database to NOARCHIVELOG mode
第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题:
A tablespace is taken offline.
The database instance is restarted.
A new data file is added to an existing tablespace.
A successful backup is recorded in the RMAN repository.
The RMAN connection is disconnected from the target database.
第11题:
Only data files and the control file are backed up.
Archived redo logs are backed up only if the database is open during the backup.
The backup is deleted after one day,regardless of the default retention policy settings.
The backup becomes obsolete after one day,regardless of the default retention policy settings.
第12题:
by using the trace file
by using the alert log file
by using the database ID
by using the server parameter file
by using the V$CONTROLFILE view
by using the autobackup format configuration setting
第13题:
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
第14题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第15题:
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()
第16题:
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()
第17题:
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RMAN> REPORT NEED BACKUP days 3; What would be the output of this command?()
第18题:
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()
第19题:
a list of files that require a backup within three days
a list of files that have not been backed up for three days
a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
a list of files for which a backup has already been performed and may need a backup after three days
第20题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第21题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第22题:
a tablespace is taken offline
the database instance is restarted
a new data file is added to an existing tablespace
a successful backup is recorded in the RMAN repository
the RMAN connection is disconnected from the target database
第23题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第24题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
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