Re: Backup & Recovery

Hi Meng:

If you are newbee in oracle, I suggest you to start with regular hot backup and cold backup.
rman is more powerful and flexable, but it's optional. You can find the hot and cold backup scripts from books and run them by cron job.
I prefer to locate the archive in disk and cycle them out by cron job. It's better to have daily system backup for sure.

Roy

Meng wrote:

> Hi All,
> I am a new Oracle DBA. I want to know something about backup &
> recovery
> 1. How do you do daily backup for Oracle? Do you use RMAN and recovery
> catalog ? The Oracle version we purchase is 8i standard edition. Does
> It
> support incremenetal backup? Do you think it's necessary to use RMAN
> if it does not support incremenetal backup
> 3. How do you deal with archived redo log at daytime? Is the archived
> redo log written into a tape or disk after it's full ?
>
> Thanks in advance.
>
> Meng
Received on Sat Jul 21 2001 - 23:18:22 CEST