Re: standby - copy database

I believe this is possible. The problem is that the database on server B has no knowledge of the 'new' archivelog files from server a. This information is stored in the control files. If everything is exactly the same on both servers, it should be easy enough to grab a copy of the current control files from server A and put them on server B. The database on server B must be shutdown before you do this.

So:

1. Shutdown database on server B.
2. Copy control files from server A to server B.
3. Copy necessary archived redo-logs from server A to server B
4. Startup mount database on server B 5 Do required recovery type on database on server B (Complete, PIT)

This is the process I used back in the dark ages when moving a copy of our production database to our Y2K test server. It's not the best, but it fit with our needs and lack of tape drives on the Y2K server.

I believe I have covered all the steps, but I won't gaurantee it. Use common sense to see if this fits your needs.

HTH,
Patrick

--
Posted via http://dbforums.com