If a control file is damaged due to a disk failure the associated instance must

If a control file is damaged due to a disk failure

This preview shows page 6 - 7 out of 7 pages.

Every Oracle Database should have at least two control files, each stored on a different physical disk. If a control file is damaged due to a disk failure, the associated instance must be shut down. Once the disk drive is repaired, the damaged control file can be restored using the intact copy of the control file from the other disk and the instance can be restarted. In this case, no media recovery is required. The behavior of multiplexed control files is this: The database writes to all filenames listed for the initialization parameter CONTROL_FILES in the database initialization parameter file. The database reads only the first file listed in the CONTROL_FILES parameter during database operation. If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted. ANSWER 9: This procedure assumes that one of the control files specified in the CONTROL_FILES parameter is corrupted, that the control file directory is still accessible, and that you have a multiplexed copy of the control file. VIEW DEWSCRIPTION V$DATABASE Displays database information from the control file. V$CONROLFILE List the status of all control files associated with the instance V$CONTROLFILE_RECORD_SECTION Provides information about the control file record section V$PARAMETER List the name, status, and location of the control files ANSWER 10: A client is any application that connects to Oracle Database to send or retrieve data. An Oracle Database client application can reside on any computer that has Oracle Database client software installed. Oracle Net Services provides enterprise wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services ease the complexities of network configuration and management, maximize performance, and improve network diagnostic capabilities.
Image of page 6
Connectivity Oracle Net, a component of Oracle Net Services, enables a network session from a client application to an Oracle database server. Once a network session is established, Oracle Net acts as the data courier for both the client application and the database server. It is responsible for establishing and maintaining the connection between the client application and database server, as well as exchanging messages between them. Oracle Net is able to perform these jobs because it is located on each computer in the network.
Image of page 7

You've reached the end of your free preview.

Want to read all 7 pages?

  • Spring '18
  • Oracle Database, Client-server

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture