RE: Hot Backup Theory Revested:

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 24 Jun 2004 15:07:41 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C42C@25exch1.vicorpower.vicr.com>

Stephen,

Whether or not the database requests an offline redo log is dependant = on two things:

How long the database is in hot backup mode
How much transactional activity is occurring in the database.

We use EMC BCV splits to replicate databases and like you, every once in = a while, we need an offline redo log. That's why we have the archive = log destination as part of the BCV's.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Hodgkinson, Stephen [mailto:Stephen.Hodgkinson_at_cba.com.au] Sent: Thursday, June 24, 2004 4:47 AM
To: oracle-l_at_freelists.org
Subject: FW: Hot Backup Theory Revested:

> Can somebody give me there opinion on the below - either yes this can
> happen or no this is impossible you must have a mistake elsewhere.

>=20


> /****************************************************

>=20

> I have an automated script that backups my database, ftp's it to a =
test
> server and rebuild it each night.

>=20

> This process works 95 % of the time.

>=20
> Occasionally the restore of the database fails as it asks for an =
archive
> log before the backup process began.

>=20

> My backup is something like this:

>=20


> 1)	ALTER SYSTEM ARCHIVE LOG CURRENT

> 2)	Start Begin and End Backups and copies of all tablespaces.

> 3)	ALTER SYSTEM ARCHIVE LOG CURRENT

> 4)	CopyArchivedRedoLogs (From the time of step1 to tep 4)

>=20

> So my question is do you ever require the archive logs that are =
generated
> before the first begin backup e.g. Maybe for a long running =
transaction
> that spans redo logs.

>=20
> I tried executing step 1) four times but I Didn't really expect it =
to
> help - and it didn't

>=20

> Please don't suggest using RMAN - we will use it soon.
>=20
> I known you generally would want all you archive logs and we do have =
this
> it is just an automation issue I am trying to resolve.
>=20
> If you believe what I am suggesting is impossible please let me known =
and
> the next time it happens I will investigate it 100 % rather than just
> manually ftp over the old archive log.

>=20

> Thanks in advance.

>=20
>=20
>=20

IMPORTANT MESSAGE ************** This e-mail message is intended only for the addressee(s) and contains = information which may be confidential. If you are not the intended = recipient please advise the sender by return email, do not use or = disclose the contents, and delete the message and any attachments from = your system. Unless specifically indicated, this email does not = constitute formal advice or commitment by the sender or the Commonwealth = Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be = contacted through our web site: www.commbank.com.au

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 24 2004 - 14:05:06 CDT