Re: Complete Database Backup in Oracle 8i

Re: Complete Database Backup in Oracle 8i

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Mitch' on August 30, 2001 at 04:16:20 EST:

In Reply to: Complete Database Backup in Oracle 8i posted by 'Fauzia' on August 14, 2001 at 13:23:20 EST:

: How do I take a Complete Database Backup in Oracle 8i and similarly Recover from the Backup?
: Thanx

The first question that you need to consider is whether you require 24 x 7 availability?. If you can schedule downtime, then take the DB down and do a file level "cold backup". Make sure you backup the \ora81\oradata and the \ora81\admin directries.

If however you need availability 24 x 7 then you can consider a number of options.

You could create scripts that switch the archive logs, backup the controlfile and then alter the tablespaces to backup mode.

Alternatively you could use Oracle Enterprise Manager or DBA Studio, which provide GUI alternatives.

Hope this helps as an overview

Mitch

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : : How do I take a Complete Database Backup in Oracle 8i and similarly Recover from the Backup? : : Thanx : : The first question that you need to consider is whether you require 24 x 7 availability?. If you can schedule downtime, then take the DB down and do a file level "cold backup". Make sure you backup the <oracle_home>\ora81\oradata and the <oracle_home>\ora81\admin directries. : If however you need availability 24 x 7 then you can consider a number of options. : You could create scripts that switch the archive logs, backup the controlfile and then alter the tablespaces to backup mode. : Alternatively you could use Oracle Enterprise Manager or DBA Studio, which provide GUI alternatives. : Hope this helps as an overview : Mitch

[ Follow Ups ] [ Post Followup ] [ Message Board ]