Re: Standby database question

I am not sure what you mean by "import into the database, issue the command alter...."

Exporting from an existing database and importing into a new database is not a part of setting up standby databases. The pre-requisite for for a standby database is an online/hot backup of the existing database.

You can export from database A and import into database B and synchronize the two if you can set up replication (as opposed to standby).

In your case, both can be an option, it depends on which one you would want to go with. Setting up standby is much easier but you will not be able to reorg the tables (you can still re-arrange the datafiles) and setting up replication is complex but you can reorg the database in whatever way you may want to.

//tc

"Tim Kearsley" <tim.kearsley_at_milton-keynes.gov.uk> wrote in message news:725736ef.0304110314.5d90da6f_at_posting.google.com...
> Hi all,
>
> Environment:
>
> Oracle 8.1.7 on AIX 4.3.3 on RS6000 SP hardware
>
> I've got a production database of around 30 Gbytes which I want to
> completely re-organise to take advantage of LMTs as well as move to a
> disk structure which is a bit more like OFA (this is a legacy database
> I've taken over).
>
> I've created a new database and exported/imported the old one and had
> it tested and all seems OK. However, the problem is one of downtime.
> The total time to do the import, re-create indices and do some work on
> invalid packages was a couple of days and it's going to be very hard
> for me to convince the users of this database that I need at least a
> weekend to do maintenance.
>
> This is my question:
>
> Could I import into the new database, issue the command "ALTER
> DATABASE CREATE STANDBY CONTROLFILE AS <filename>", shut it down, then
> mount it as a standby and synchronise it with the old, current
> database? It seems to me that if I could, then I could simply switch
> the standby over to be the new database, rename it, and achieve this
> with a fairly small amount of downtime.
>
> Is my reasoning OK, or have I missed something?
>
> I'll experiment with this anyway, but wondered if this was a
> recognised procedure.
>
> Thanks.
>
> Regards,
>
> Tim Kearsley
> Database Manager
> Milton Keynes Council
Received on Fri Apr 11 2003 - 16:21:36 CEST