Archive log questions

Hi all,

I've researched this a lot, but I just want to confirm some things.

We run our databases in archive mode. I have an script to do a hot backup. I backup the tablespaces, control files, .ora files, and then log files.

Questions:

• should I do a: alter system switch logfile or alter system archive log current or alter system archive log all ???
• I am currently doing this after backing up the tablespaces, and before backing up the log files. Correct?
• should I keep any of the archive logs? If so, how many, or how far back?

To recover to the point in time that I did the backup, I won't need any of the archive log files older than the backup time, will I?

However, if tommorrow, I want to recover the database to tommorrow's current time, I will need all the archive log files created since backup time, correct? In which case, I shouldn't need any archive logs previous to the backup, correct?

I copy files to another drive, and then back them up to tape.

We run on Unix. In the script, I use:

sqlplus ..... << THE_END

@backupscript

THE_END

• is there a way to capture the return code from Oracle to verify that the backup worked correctly?

Yes, I should know all this. But, I keep getting more and more work to do, which keeps spreading me thin.

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 16 2000 - 00:00:00 CDT