Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
第1题:
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully? ()
第2题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()
第3题:
A. The database must be opened in restricted mode.
B. The database must be configured to run in ARCHIVELOG mode.
C. The tablespaces are required to be in backup mode before taking the backup.
D. The tablespaces are required to be in read-only mode before taking the backup
第4题:
Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()
第5题:
you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
第6题:
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()
第7题:
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file?()
第8题:
A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.
第9题:
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()
第10题:
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()