Re: Backup Oracle Databases by ADSM

Grace Tsai wrote: (responses in-line below)

> We are going to use ADSM to backup the ORACLE databases. Currently, I am
>
> using offline backup for all the Oracle databases since our usage is
> very very low.
>
> Questions:
>
> 1. Does ADSM only do the online Oracle Backup?

ADSM can do regular filesystem backups, so it should be indifferent to whether or not your database is online (cold backup should work fine). It may have special features for facilitating hot backup by interacting with Oracle to put tablespaces into and out of online backup mode in coordination with the backups; ask your rep or check the literature. But cold offline backups should work no matter what.

>
>
> 2. If yes, does that mean that the ArchiveLog have to be enabled?

If you choose to do online backups (and I recommend them), you must archive your redo logs.

>
>
> 3. How to relocate the existing online redo log files?

I'm not sure what this means. Going to archivelog mode does not require you to do anything to your redo logs. If you're talking about the actual archiving, that is handled by the ARCH process. You will have to give it a destination, and make sure that destination has enough space to handle at least a day's worth of transactions (each log switch is recorded in your alert log, so you can check that for a feel of how many logs you'll go through in a day), unless you can automate the transfer of archived logs to tape to keep the archive destination clear.

>
>
> Thanks.
>
> GraceTsai
> Brookhaven National Lab
Received on Wed Jun 16 1999 - 23:23:46 CDT