Re: Oracle Backup Log files and recovery

hari_om_at_hotmail.com (Hari Om) wrote in message news:<d1d5ebe4.0312080802.43d05c52_at_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:
> -------------
> 1) Is this INCREMENTAL or DIRRERENTIAL BACKUP Log files....?
> 2) If my Instance crashes, how can I recover from these files?
> 3) 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
Hari,

you made a good start on posting the oracle server software version and OS info.
can you supply a few more bits of relevant info?

from the init.ora, or spfile.ora (which will take a little more work) can you supply the values for these parameters:

log_archive_format
db_file_create_dest

and answer this question:

are you using RMAN for your backups?

see, the log_archive_format could be set to generate archived redo logs with a format of *.dbf - you have the control to do that if you wish.

its also possible for you to have created rman backupset pieces in that directory with an extension of .dbf.

If you query the view v$archived_log, you'll know if in fact these are exclusively your transaction logs.

Having the archived redo logs is necessary for performing media recovery, but not sufficient, in that you'll need a controlfile, initialization file in order to support an instance to recover the database.

you're making progress.

Pd Received on Mon Dec 08 2003 - 23:47:17 CST