Hi all,
I have passed today backup & recovery workshop exam(oracle8) . It is the more STS like exam.

Here the questions I have found more difficult:

Which init.ora parameter enables detection of block corruption in a redo log file?
LOG_BLOCK_CHECKSUM
DB_BLOCK_CHECKSUM

What is updated when you issue the command to put the database in ARCHIVEDLOG mode?
init.ora
controlfile

What are two results of running your database in NOARCHIVELOG mode?
-you can only perform backup after a ALTER SYSTEM command.
-you must backup entire set of database files, redologs and controlfiles for each backup.
-you can perform a PITRecovery of a database.
-the entire database become unavailable if a tablespace datafile is damaged.

A datafile that is not syncronised with the rest of the database files must be in wich type of tablespace in order to continue to run the database without error?
-temporary
-online
-read-write
-read-only

wich one is correct to see datafiles need backup?
-report backup days 3
-report need backup days 3

A database is down with a missing file. After taking the file offline, what command is right?
-ALTER DATABASE OPEN?
-RECOVER TABLESPACE

In order to bring up a database ASAP with a file damaged wich one is right?
-restore backup copy of file and perform database recovery.
-take damaged file offline, MOUNT the database, restore backup copy of the datafile and perform database recovery.
-restore backup copy of datafile, OPEN database in restrict mode and perform datafile recovery.
-Take the file offline, OPEN database and perform datafile recovery.

Dmarian [email protected]