Passed Backup & Recovery - feedback

[dmarian]

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 djcarving@hotmail.com

[achkar]

Well done.

How long it took you to prepare yourself for this exam ?
Is there a lot of questions about RMAN, Catalog DB and StandBy DB?

I am preparing my self for this exam and I need your advice please about it and if you can send me some STS , that would be great and kind

Thanks in advance.

achkar@freemail.com.au

[dmarian]

Standby database I guess is a database you setup for clone.
No questions about.
Rman, lot of questions.
Recovery catalog also, questions just about connecting, reseting the catalog.
I worked 3 weeks on it, one week full time at work.
Have practice lots of exercices, founded on Oracle website documentation, or in Couchman's book.
I have found this exam the eazyest but I have prepare it the most seriously one.

[vimalp]

Big Congrates Dmarian!

[snje]

Hi Dmarian,

Thanks for the exam question. I just passed the Back and Recovery at 58/60,
The question is same as yours, I will do the DBA next week.

SNJE (sjhqw@yahoo.com)

[vimalp]

Congratulations SNJE :o

[JOHNZ]

[QUOTE][i]Originally posted by dmarian [/i]
[B]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 djcarving@hotmail.com


[/B][/QUOTE]

Dear Friend:
If you can email more questions regarding B&Recovery to john@ietla.com, I will be very appreciated.
thanks. John