052-195(新增70题2018)

When you try to open your database, you receive the following error:

ORA-00205: error in identifying controlfile

Where would you find the details required to resolve this error?

A. audit trail

B. alert log file

C. user trace file

D. online trace file

E. background trace file

F. operating system event viewer

Answer: B

ORA-00205: error in identifying control file, check alert log for more info

Cause: The system could not find a control file of the specified name and size.

Action: Check that ALL control files are online and that they are the same files that the system created at cold start time.

Alert Log

Each database has an alert log, which is an XML file containing a chronological log of database messages and errors. The alert log contents include the following:

All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60)

Administrative operations such as DDL statements and the SQL*Plus commands STARTUP, SHUTDOWN, ARCHIVE LOG, and RECOVER

Several messages and errors relating to the functions of shared server and dispatcher processes

Errors during the automatic refresh of a materialized view

Oracle Database uses the alert log as an alternative to displaying information in the Enterprise Manager GUI. If an administrative operation is successful, then Oracle Database writes a message to the alert log as "completed" along with a time stamp.

Oracle Database creates an alert log in the alert subdirectory  when you first start a database instance, even if no database has been created yet.

alert是最先创建来记录问题的，开机出现问题一般都会记录。

 

052-184(新增70题2018)

SQL> select * from alert where upper(log) like '%CONTROL%';
LOG
--------------------------------------------------------------------------------
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl
  control_files            = "/home/oracle/app/oracle/flash_recovery_area/orcl/c
Create controlfile reuse set database "orcl"
Completed: Create controlfile reuse set database "orcl"
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl
  control_files            = "/home/oracle/app/oracle/flash_recovery_area/orcl/c
Create controlfile reuse set database "orcl"
Completed: Create controlfile reuse set database "orcl"
but not in the controlfile. Adding to controlfile.
         This condition can occur when a backup controlfile has
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
LOGSTDBY: Validating controlfile with logical metadata
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl
  control_files            = "/home/oracle/app/oracle/flash_recovery_area/orcl/c
Updating character set in controlfile to WE8MSWIN1252
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl
  control_files            = "/home/oracle/app/oracle/flash_recovery_area/orcl/c
  control_files            = "/home/oracle/app/oracle/oradata/orcl/control01.ctl
LOG
--------------------------------------------------------------------------------
  control_files            = "/home/oracle/app/oracle/flash_recovery_area/orcl/c