Re: hot backup offline db synch

Thanks, thats great info. So to get a standby database kicked off on another server do I have to make a mirror copy of all database files and then start manually recovering?

Are archive log files binary compatible across platforms - could I use a VMS box as the standby instead of another linux box?

thanks!

Tim

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7dbjg$djr$1_at_lust.ihug.co.nz>...
> 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
Received on Sun Mar 24 2002 - 12:22:50 CST