Re: Sounds good in theory, but will it work?

"TB" <chessgame_at_gmail.com> wrote in message news:1163026439.196750.280010_at_f16g2000cwb.googlegroups.com...
> We have Oracle 8.1.7 running on an IBM p615 single processor server.
> I'm an AIX admin, not an Oracle admin. We don't have an Oracle admin
> on staff.
>
> I need to ensure some level of recovery (somewhat quickly) in case of a
> total disaster; building burns down, tornado hits,... whatever. I'm
> not looking for anything fancy and costly like clusters or
> (a)synchronous replication. What I do have is a full hot backup every
> night with RMAN and an offsite DR facility.
>
> Here are my thoughts...
> Buy a second AIX server (I have a quote for a p520 dual proc) for our
> DR site. Backup the rootvg (mksysb). On the weekends shut down the
> Oracle database and do a savevg on the data vg's. Bring Oracle backup
> and continue to do full RMAN backups durring the week.
>
> Build the new server at the DR sight with the mksysb. If a disaster
> happens, then I could take the savevg(s) to the DR facility and restore
> those vgs. This should give me a fully functional Oracle server as of
> the weekend backup. Then I could use the RMAN backups to restore to
> the weekly full backup. With this process we could potentionally loose
> a full days work, but we are comfortable with this risk.
>
> Has anyone done anything like this? Think it will work? What are your
> thoughts?
>

Hi TB

Have you considered implementing an Oracle Standby database? It wasn't quite as flash and fancy as it now but it'll be a simpler solution to set-up and use in a disaster situation.

And you would only lose the current online redo log at worse ...

See
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76995/toc.htm for all the necessary doco.

Cheers

Richard Received on Thu Nov 09 2006 - 06:19:51 CST