Re: hot backup offline db synch

You're describing a standby database, and that was possible in 7.3. But *managed* recovery mode was not available until 8i (where the machines automatically exchange archives, and they are applied automatically at the standby machine). So if you're going to do it, you'll need to sit there manually transferring archives, and manually applying them, unless you are a dab hand with a shell script and cron.

I seriously doubt that 60Gb can be upgraded to 8i in 3 hours, but it's impossible to tell with the information provided.

If the only reason you are contemplating the standby database is that it gives you a 'clone' which can be upgraded leaving the source unaffected and with no downtime, that's a fairly convoluted way to go about it. Standby databases can be invalidated by a single 'nologging' (or 'unrecoverable') DML operation, and assorted bits of DDL will play havoc, too.

The upgrade process does not require you to use export and import: you can do an in-place upgrade, which wouldn't require very much extra disk space at all, and would be much quicker than a full export. So downtime would be required, but not as much as with export. But whether 3 hours is possible... as I say, its impossible to say for sure, but I doubt it.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Tim Smith" <timasmith_at_hotmail.com> wrote in message
news:a7234bb1.0203210839.5f697d86_at_posting.google.com...


> Hi,

>   I have an intel box running RH 5.2 with Oracle 7.3.2 (archive log

> mode).

> I have another intel box running RH 6.2 and Oracle 7.3.2.

>

> Can I copy archived redo logs from RH 5.2 to RH 6.2 and have that

> database in a constant recovery mode, thus synchronizing the data?

>

> I do not want to stop the database and do exports as it would take too

> long (60GB db, 10 Mb ethernet) and I have limited disk space left!

>

> I then want to upgrade RH 6.2 from Oracle 7.3.2 to Oracle 8.1.7 - all

> with a minimum (1-3 hrs?) of downtime - is it possible?

>

> I guess this is where a Oracle DBA really shows her colours but it is

> hard to justify the cost for this low funded project.

>

> thanks!

>

> Tim