Re: Online backup of 7.2.6

Rainer

I'd suggest you get a copy of the Oracle Backup and Recovery Handbook by Rama Velpuri. It sounds like there are some key concepts you need to get a firmer understanding of.

In answer to your questions, online backup does not need the tablespaces to be taken offline. What you need to do for each tablespace (this is the simplest approach rather than trying to exclude particular tbalespaces that you might be able to recreate) is the following:

1. alter tablespace begin backup;
2. copy datafile to backup location
3. alter tablesapce end backup;

This should be automated by writing a SQL script to query v$datafile to get the locations etc. Note you do not need to backup the online redo log files, but should backup the controlfile. For flexibility, do the control file each way:

1. alter database backup controlfile to trace;
2. alter database backup controlfile to 'another_directory/controlfilename';

This is the correct approach to backup the database online. What you're currently doing is probably not recoverable from if I'm reading it correctly.

The archive logs that you need to keep are since the last backup (or two for a doublecheck), regardless of whether the database has been shutdown or not.

HTH. Pete

Rainer Fritz wrote:

> Hey,
>
> I have some questions:
>
> our DB-system is running 24 hours a day and 360 days a year.
> So I have only one possibilty to backup our database: online!!
> In some case I have the possibility to create a tape with the datafiles of
> our DB in offline-mode.
>
> By the way the db-system runs in archive mode.
>
> While the backup I stop the different tablespace with the command Alter
> tablespace....offline , then I backup the datafile and then I put the
> tablespace online with the command Alter tablespace online.
> After this procedure I then backup the controlfile and then all
> archive-log-files from our UNIX-System.
>
> Question:
> 1.) Is this the right way to backup the ORACLE-database or are there any
> other files I should also backup?
> If yes, which files should I backup and at which time?
>
> 2.) Which archive-logs are necessary for a successful recovery? Only the
> archive-logs between the last DB
> shutdown (without backup the DB) or all tapes with all files I created
> after the last Offline-Backup?
>
> Thanks in advance
>
> Rainer
>
> My adresse Ra_Fritz_at_t-online.de

--
Regards

Pete

Received on Thu Jul 22 1999 - 15:03:23 CDT