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