单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）A Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B Oracle will automatically take the datafile out of hot backup mode and then open the database.C Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D The database will open with the file in hot backup mode. You can restart the backup at any time.E The datafile in hot backup mode will be corrupted and you will have to recover it.
单选题
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
A
Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
B
Oracle will automatically take the datafile out of hot backup mode and then open the database.
C
Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
D
The database will open with the file in hot backup mode. You can restart the backup at any time.
E
The datafile in hot backup mode will be corrupted and you will have to recover it.
参考解析
解析：
暂无解析
相关考题：
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.
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
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.
Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）A、 The copy of the datafile created is stored in the RMAN repository.B、 The copy of the datafile created can be viewed using the LIST BACKUP command.C、 The copy of the datafile created using this COPY command can be placed only on the disk.D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（） A、 The database will open，and the tablespace automatically comes out of the backup mode.B、 The database will be mounted，and recovery must be performed on the USERS tablespace.C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（） A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D、 If you restart the database，the database will not be opened.
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？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（） A、 Do nothing.B、 Restart the database.C、 Perform recovery on the database.D、 Restore the alert log from the last backup.
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
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
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
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？ （）A、 The database is in NOMOUNT state.B、 The database is in NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（） A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.
Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B、 Datafiles are not written to during hot backups.C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D、 The datafile headers are not updated during the backup.E、 The way data is written to the online redo logs is unchanged during the backup.
单选题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）A Do nothing.B Restart the database.C Perform recovery on the database.D Restore the alert log from the last backup.
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.DIf you restart the database, the database will not be opened.
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）A The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D If you restart the database，the database will not be opened.
单选题To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（）A The database will open，and the tablespace automatically comes out of the backup mode.B The database will be mounted，and recovery must be performed on the USERS tablespace.C The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
单选题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 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？ （）AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.
单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B Datafiles are not written to during hot backups.C Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D The datafile headers are not updated during the backup.E The way data is written to the online redo logs is unchanged during the backup.
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
单选题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