Explore BrainMass
Share

ORACLE9i

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. What might cause the loss of one control file? What might cause the loss of all control files?

2. Compare and contrast multiplexing of control files and redo log files.

3. Why should a business have its database in ARCHIVELOG mode?

© BrainMass Inc. brainmass.com October 16, 2018, 6:40 pm ad1c9bdddf
https://brainmass.com/computer-science/files/oracle9i-91756

Solution Preview

1. A single disk failure may cause the loss of one control file stored on that disk. If you store all the control files on one disk, then the failure of this disk can cause the loss of all of the control files.

2. A. To multiplex control files:
1). shutdown the db.
2). copy existing controlfile to another location and ...

$2.19
Similar Posting

Oracle9i Database

9. Look at the following CREATE DATABASE command, and find the errors. Then please correct the problem.

CREATE DATABASE ultradb FOR UPDATE OF paralleldb
MAXINSTANCES 25
DATAFILE TABLESPACE 'ORACLE_BASEoradatasystem01.dbf'
CHARACTER_SET US7ASCII
LOGFILE GROUP A ('D:oraclelogsredoA.log') SIZE 50M,
GROUP B ('D:oraclelogsredoA.log') SIZE 50M;

View Full Posting Details