6-ASSIGNMENTS ON REDO LOG FILES (2)

6-ASSIGNMENTS ON REDO LOG FILES (2) - Hint V$DATABASE...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENTS ON REDO LOG FILES 1. List the number and location of existing log files and display the number of redo log file groups and members your database has Hint: V$LOGFILE, V$LOG 2. In which database mode is your database configured? Is the archiving enabled?
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Hint: V$DATABASE, V$INSTANCE 3. Add a redo log member to each group in your database. 4. Add a redo log group in your database with two members 5. Remove the redo log group created 6. Resize all online redo log files to 1024 KB....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online