Oracle Backup Log files and recovery

From: Hari Om <hari_om_at_hotmail.com>
Date: 8 Dec 2003 08:02:45 -0800
Message-ID: <d1d5ebe4.0312080802.43d05c52@posting.google.com>

I am using Oracle DB 9.2.0.1 on IBM AIX 5.1L System

I have a instance running on it named "utahprod" which is running in ARCHIVEMODE. My Archive destination is "/storage/archive/utahprod" and everday ONE LOG File is generated and Archived and stored in this directory.

My Syntax for this file is "utahprod_1_1.dbf" all the way through "utahprod_1_108.dbf"

My QUESTIONS:

Is this INCREMENTAL or DIRRERENTIAL BACKUP Log files....?
If my Instance crashes, how can I recover from these files?
What happens if one of the above files (say utahprod_1_36.dbf") gets corrupted....? What would happen or what are the consequences of this corrupted Log file on the recovery of the DB?

Any related information on this is appreciated.

THANKS! HARI Received on Mon Dec 08 2003 - 10:02:45 CST