The online redo log files and online data files are opened.
All the online data file headers are checked for consistency.
Instance recovery is performed before opening the database.
The path and existence of all the log file members are checked
第1题:
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()
第2题:
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()
第3题:
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL> shutdown immediate;What is the result of executing this command?()
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
第4题:
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()
第5题:
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()
第6题:
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?()
第7题:
Your archive-log destination directory runs out of space. What is the impact of this on the database?()
第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题:
Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()
第10题:
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()