take data files from the read-only tablespace offline before performing a recovery
recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
drop the read-only tablespace and re-create the tablespace after recovery
perform a recovery; status of the tablespace in control file will be changed automatically
第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题:
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?()
第3题:
You have a read/x7fonly tablespace on read/x7fonly 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/x7fonly tablespace was read/write when the control file was backed up. What should you consider?()
第4题:
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()
第5题:
The loss of the control file forced you to re-create the control file. After re-creating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five-digit number starting with 0. What could be the possible reason?()
第6题:
In which of the following scenarios is a tablespace recovery required?()
第7题:
A backup of the target database when it is mounted
A backup of online redo log files when the database is open
A backup of only used data blocks in the file beingbeingbackup up
A backup of online, read/write data files when the database is open
A backup of only those data blocks that have changed since a previous backup
A backup of online, read/write data files when the database is in the NOMOUNT state.
第8题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第9题:
restore the tablespace from the backup; there is no need to apply the redo information
restore the full database to recover the data up to the point when you performed the backup
restore the tablespace from the backup, and then perform a recovery using the backup control file
restore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
第10题:
a, b, f, g
c, f, g
a, d, f, g
a, f, g
a, e, g
第11题:
restore the tablespace from the backup, and then perform an incomplete recovery
restore the tablespace from the backup, and then apply all the redo information
restore all the data files in the database, and then perform an incomplete recovery
restore the tablespace from the backup
第12题:
These are the data files that are corrupted.
There is no SYSAUX tablespace in your database
There is a read-only tablespace in your database.
These are the data files that cannot be recovered.
第13题:
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
第14题:
One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file. Which operation do you need to perform after re/x7fcreating the control file and opening the database?()
第15题:
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? ()
第16题:
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? ()
第17题:
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()
第18题:
drop and recreate the readonly tablespaces
rename the readonly data files to their correct file names
change the tablespace status from read/write to readonly
recreate the readonly tablespace because it is automatically removed
第19题:
drop the readonly tablespace and recreate the tablespace after recovery
take data files from the readonly tablespace offline before performing a recovery
perform a recovery; status of the tablespace in control file will be changed automatically
recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
第20题:
drop and re-create the read-only tablespaces
rename the read-only data files to their correct file names
change the tablespace status from read/write to read-only
re-create the read-only tablespace because it is automatically removed
第21题:
when recovering a lost read-only tablespace from a read-only tablespace backup
when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG mode
when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only
第22题:
restore the tablespace from the backup; there is no need to apply the redo information
restore the full database to recover the data up to the point when you performed the backup
restore the tablespace from the backup and then perform a recovery using the backup control file
restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
第23题:
Until SCN
Until time
Until cancel
Recover using backup control file.