Is linked to a single database Should be multiplexes Maintains integrity of

Is linked to a single database should be multiplexes

This preview shows page 2 - 4 out of 4 pages.

• Is linked to a single database • Should be multiplexes • Maintains integrity of database • Sized initially by CREATE DATABASE 7. Briefly describe what are Oracle control file contents? Ans: A control file contains the following entries: • Database name and identifier • Time stamp of database creation • Table space names • Names and locations of data files and redo log files • Current redo log file sequence number • Checkpoint information
Image of page 2
• Begin and end of undo segments • Redo log archive information • Backup information 8. Briefly describe what are the steps to multiplexing the Oracle control file? Ans: Multiplexing the Control File - Using SPFILE • Alter the SPFILE ALTER SYSTEM SET control files = ‘$HOME/ORADATA/u01/ctrl01.ctl’, ‘$HOME/ORADATA/u02/ctrl02.ctl’ SCOPE=SPFILE; • Shutdown normal SQL> shutdown normal • Create additional control files $ cp $HOME/ORADATA/u01/ctrl01.ctl $HOME/ORADATA/u02/ctrl02.ctl • Start the database SQL> startup Multiplexing the Control File - Using init.ora • Shut down the database in normal status SQL> shutdown normal;
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '16
  • Oracle Database, Computer file, Redo log, Data hierarchy

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes