Activate Standby Database

From: <jay.connell_at_hexionchem.com>
Date: 17 Aug 2005 05:46:03 -0700
Message-ID: <1124282763.225653.9850@z14g2000cwz.googlegroups.com>

Hello,

I'm upgrading my database server hardware this weekend. On the new server, I've created a standby database and logs are being copied over and applied right away on the standby. I've scheduled a planned downtime
to shutdown my production database and then active the standby on the new hardware.

Question: Since all redo logs and control files are available, can I move the standby control files out of the way and copy

                    the old production server redo log files and

control files over to the new server? Then open the database

I don't want to do an alter database activate standby because this will do a resetlogs and invalidate all my previous backups. I could backup the control file to trace on old server and create new control file on new server with this script. Received on Wed Aug 17 2005 - 07:46:03 CDT