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?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 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

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?()  

  • A、 You will need to open the database with the resetlogs command.
  • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
  • C、 You will use the resetlogs version of the create controlfile command.
  • D、 You will use the noresetlogs version of the create controlfile command.
  • E、 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

相关考题:

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?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

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

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?()A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()A、All control files are openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened

Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  A、 Put the database in hot backup mode and perform an online backup,including backing up the  archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

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 are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

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 executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files, after you lost all the control files in your database

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 are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A、Database Datafiles B、Database Control Files C、Online redo logsD、Archived redo logs E、The database SPFILE F、None of the above, all these files are backed up.

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()  A、 register databaseB、 recover catalogC、 load backupsetD、 synch metadataE、 catalog start with

Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()  A、 13:00 on Tuesday.B、 15:00 on Tuesday.C、 Up until the last available archived redo log on Sunday.D、 To any point; all the redo should still be available in the online redo logs.E、 The database is not recoverable.

You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?()A、 Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th,and open the database.B、 Tell them that their request cannot be met with the current backup strategy.C、 Restore the 19ths backup, apply the online redo logs,and open the database.D、 Switch the database into ARCHIVELOG mode,restore the 19th’s backup,restore all archived redo  logs,and recover the database to the 20th.E、 Use the recover database command to roll back the database from today to the 19th of the month.

Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case?()A、a, b, e, cB、b, e, dC、a, b, d, cD、b, g, c, fE、a, b, d, f

单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A online redo log filesB alert log filesC control fileD datafiles associated with the SYSTEM tablespace

单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()ADatabase Datafiles BDatabase Control Files COnline redo logsDArchived redo logs EThe database SPFILE FNone of the above, all these files are backed up.

单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A The log sequence is reset to 0.B All the online redo logs are deleted.C All the archived redo logs from a previous incarnation become useless.D The full database backup taken from a previous incarnation can be used in future.E Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-creating the control files, after you lost all the control files in your database

单选题You have lost datafiles 1 and 3 from your database,and the database has crashed.  In what order should you perform the following steps to recover your database?() 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.A 2,1,3,4,5,6B 2,4,5,3C 4,7,3D 2,4,7,3E 2,7,3

单选题You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire You wa database, noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion.  Using the following steps,what is the correct order in which the following RMAN commands should be executed?()   1. STARTUP NOMOUNT  2. ALTER DATABASE OPEN RESETLOGS  3. SQL "ALTER DATABASE RENAME ,,logfile1 path TO ,,+dgrp4 ,," # plus all other logfiles  4. SWITCH DATABASE TO COPY  5. BACKUP AS COPY DATABASE FORMAT ,,+dgrp4 6. ALTER DATABASE MOUNT  7. RESTORE CONTROLFILE FROM ,,controlfile_locationA 2, 5, 3, 1, 7, 6, 4B 1, 7, 6, 5, 4, 3, 2C 5, 1, 2, 7, 4, 6, 3D 7, 3, 1, 5, 6, 2, 4

单选题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 are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A Database DatafilesB Database Control FilesC Online redo logsD Archived redo logsE The database SPFILEF None of the above,all these files are backed up

单选题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?()A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E 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