网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogs
- A、 b， a， c， d， e
- B、 a， c， b， d， f
- C、 c， a， b， d， e
- D、 c， a， b， d， f
- E、 e， a， b， d， c
参考答案
更多 “ Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA、 b， a， c， d， eB、 a， c， b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 e， a， b， d， c” 相关考题
考题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?（）A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
考题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A、 2， 7， 3， 5， 1， 6， 4B、 2， 1， 7， 6， 3， 5， 4C、 7， 1， 3， 2， 6， 5， 4D、 7， 2， 3， 1， 4， 6， 5
考题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）A、recover using Oracle Flashback Database technologyB、restore the data files from backup and perform a complete recoveryC、restore only the corrupted data file and perform tablespace recoveryD、restore the data files from backup and perform cancel-based recoveryE、restore the entire database from the most recent backup and start the instance and open the database
考题
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order？（） a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN. A、 a， b， c， d， e， f， gB、 b， c， d， g， f， e， aC、 g， f， a， b， c， e， dD、 c， a， d， b， f， e， gE、 g， f， a， b， e， c， d
考题
You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed. What would be the appropriate order of operations to correct the situation？（） a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.A、a， c， f， gB、b， d， e， hC、a， b， c， f， gD、d， a， e， gE、b， c， f， e， g
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA、 b， d， eB、 b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 a， b， d， e
考题
Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database open A、 a， b， c， d， e， fB、 c， b， a， d， e， fC、 c， b， a， d， fD、 c， a， b， dE、 c， a， e， b， d， f
考题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
考题
Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（） A、 shutdown restore datafile 4； recover datafile 4； alter database open；B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
考题
What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（） a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4 d. sql ’alter database datafile 4 offline’ e. startup f. shutdownA、 a， c， b， dB、 d， b， c， aC、 f， d， b， c， a， eD、 c， a， b， d， fE、 a， b， d， e
考题
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a， b， c， d， e， fB、 c， d， a， b， fC、 d， c， a， b， fD、 d， b， d， c， eE、 d， c， a， b， e
考题
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： RMANBACKUP 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？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
考题
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and perform tablespace recoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
单选题David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order？（） a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN.A
a， b， c， d， e， f， gB
b， c， d， g， f， e， aC
g， f， a， b， c， e， dD
c， a， d， b， f， e， gE
g， f， a， b， e， c， d
考题
单选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A
2， 7， 3， 5， 1， 6， 4B
2， 1， 7， 6， 3， 5， 4C
7， 1， 3， 2， 6， 5， 4D
7， 2， 3， 1， 4， 6， 5
考题
单选题Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database openA
a， b， c， d， e， fB
c， b， a， d， e， fC
c， b， a， d， fD
c， a， b， dE
c， a， e， b， d， f
考题
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A
Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B
Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C
Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D
Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）A
Restore and recover the datafile.B
Restore and recover the tablespace.C
Restore and recover the database.D
Restore and recover the control file.E
Restore and recover the parameter file.
考题
单选题You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database openA
b， d， eB
b， d， fC
c， a， b， d， eD
c， a， b， d， fE
a， b， d， e
考题
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;A
RECOVER DATABASE；B
SWITCH DATAFILE ALL；C
RESTORE CONTROL FILE；D
RECOVER DATABASE USING BACKUP CONTROL FILE；
考题
单选题When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A
a， b， c， d， e， fB
c， d， a， b， fC
d， c， a， b， fD
d， b， d， c， eE
d， c， a， b， e
考题
单选题Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA
b， a， c， d， eB
a， c， b， d， fC
c， a， b， d， eD
c， a， b， d， fE
e， a， b， d， c
考题
单选题Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database openA
a， b， c， d， e， fB
c， b， a， d， e， fC
c， b， a， d， fD
c， a， b， dE
c， a， e， b， d， f
热门标签
最新试卷