网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）
- A、ALTER DATABASE DROP LOGFILE GROUP 1;
- B、ALTER DATABASE CLEAR LOGFILE GROUP 1;
- C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
- D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
参考答案
更多 “ Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）A、ALTER DATABASE DROP LOGFILE GROUP 1;B、ALTER DATABASE CLEAR LOGFILE GROUP 1;C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG” 相关考题
考题
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery
考题
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG
考题
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
Upon starting your database， you receive the following error： SQL startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted. ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’ You can choose from the following steps： a. Restore the database datafiles. b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database. g. Back up the database. Which is the correct order of these steps in this case？（）A、a， f， e， d， gB、f， e， dC、f， b， c， gD、a， f， cE、The database cannot be recovered.
考题
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（） A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery
考题
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
考题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A、When a new log group is added， it would have one member in each disk group.B、When a new log group is added， it would have two members in each disk group.C、When a new tablespace is added， it would have one data file in each disk group.D、When a new log file is added， it would have one member spread across the disk groups.
考题
Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
考题
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
考题
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）A、You should perform a log switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery
考题
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
考题
You have the following online redo log configuration： Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；
考题
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.
考题
You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B、 Before the instance starts， you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
考题
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A、b， a， fB、e， b， a， fC、e， b， a， gD、b， a， gE、c， e， b， d， f
考题
Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）A、 The database will operate normally without generating any redo.B、 The database will hang， and you must shut down and restart the instance.C、 The database will crash， and you must recover the database from the point of failure.D、 The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
考题
In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin
考题
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A、 SQLALTER DATABASE DROP LOGFILE GROUP 1；B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
考题
多选题In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？ （）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
考题
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A
V$LOGB
V$LOGFILEC
DBA_LOG_GROUPSD
V$LOG_HISTORY
考题
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）A
You should perform a log switchB
You should make a backup of the databaseC
You should switch the database to the NONARCHIVELOG modeD
You should shut down the database instance and perform a complete database recovery
考题
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）A
You should perform a log switchB
You should make a backup of the databaseC
You should switch the database to the NONARCHIVELOG modeD
You should shut down the database instance and perform a complete database recovery
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A
When a new log group is added， it would have one member in each disk group.B
When a new log group is added， it would have two members in each disk group.C
When a new tablespace is added， it would have one data file in each disk group.D
When a new log file is added， it would have one member spread across the disk groups.
考题
多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer
考题
单选题You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）A
The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.B
Before the instance starts， you receive an error about the missing redo log files of a group.C
The instance starts and the database opens with an error message written to the alert log file.D
The instance starts and the database opens because two redo log groups still exist.E
The instance starts and the database opens， but every attempt to write to redo log files fails with an error.
考题
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A
ALTER DATABASE DROP LOGFILE GROUP 1B
ALTER DATABASE CLEAR LOGFILE GROUP 1C
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D
ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
考题
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A
SQLALTER DATABASE DROP LOGFILE GROUP 1；B
SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C
SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D
SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
热门标签
最新试卷