Re: archive log destination-HELP!!!

You will get lots of opinion on this subject, but you have to stick to the facts.

1. Exports only give you a point to which you can restore. That point could be up to a day old if you are doing daily exports.
2. Exports can miss data if they are not run with the consistent=y flag.
3. It is easier to restore just one object with an export than it is to restore the entire database up to a point in time.
4. If you are running in archivelogmode, you can recover up to ANY point in time.
5. Archivelogs are irrelevent if you are planning on using exports as your backup methodology.

Now for the opinion:
I personally like to mix the two different methods for my production systems. I run in archivelog mode and tape the archived logs at least daily. I then take an export of specific schemas at night just in case someone drops an object inadvertantly. The exports become somewhat irrelevent if you have adequate production controls in place, but then again, some of us are just anal...

Jeff Hunter
Enterprise DBA
Anurag Minocha wrote in message <37B8EB1C.581FBCB9_at_synergy-infotech.com>...
>Hi,
>I am planning to put my database in archive log mode but am consfused
>regarding the destination. Oracle manuals/books suggest that you should
>first archive on a seperate hard disk and from there schedule backup's
>to the tape drive.
>
>If i do this i can as well take a export and put it on the tape and
>delete the old archive log's from the hard disk . Where is the need to
>back them up on the Tape since i already have the latest export .There
>is no need for me to backup the archive log's on a Tape. Everyday I can
>backup my exports on a Tape drive and immediately after that delete the
>archive log's from the seperate hard Disk.,.
>
>My question is what is the best practice and what are it's advantages
>and disadvantages..
>
>Thanks
>anurag
>
>also reply at
>anurag_at_synergy-infotech.com
>
Received on Tue Aug 17 1999 - 22:12:36 CDT