COPY
BACKUP
CHANGE
DELETE
CATALOG
第1题:
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()
第2题:
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
第3题:
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)
第4题:
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)
第5题:
Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file?()
第6题:
To store the backup information of multiple database
To restrict the amount of space that is used by the backups
To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
第7题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第8题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第9题:
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
第10题:
COPY
BACKUP
CHANGE
DELETE
CATALOG
第11题:
To store the backup information of multiple database
To restrict the amount of space that is used by the backups
To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
第12题:
Creating the control file for the duplicate database
Restoring the target data files to the duplicate database
Performing complete recovery using all available backups
Generating a new, unique DBID for the duplicate database
Copying the online redo log files from the target database to the duplicate database
第13题:
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()
第14题:
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: $ rman target / What would be the effect of this command?()
第15题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第16题:
Which two statements regarding the control file and Recover Manager are true? ()
第17题:
Each target database requires its own recover catalog.
RMAN scripts can be stored in the recovery catalog or the target control file.
A channel is a stream of data to a device type and corresponds to one server session.
The RMAN executable interprets sever session commands and establishes connections to the target database.
第18题:
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
第19题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第20题:
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
第21题:
The control file can grow in size.
The control file can store RMAN scripts.
CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.
The RMAN catalog can exist solely in the control file of the target database.
第22题:
the alert log file
the server parameter file
the formatted name of a control file autobackup
an RMAN session log file
the trace file
第23题:
You can use RMAN stored scripts.
Recovery is faster if data is stored in catalog in addition to the control file.
You can store backup Information of all registered databases in one place.
Database backups are automatically deleted when they are older than the specified time period.
第24题:
Reregistering the target database in recovery catalog
Transporting the new tablespaces to the recovery catalog database
Syncronizing the recovery catalog with the target database control file
Performing a fresh backup of the target database to include the new data files in the catalog database