Copy cntrl and redo logs for standby & reports db

Greetings All,

I am proposing to create a hot standby and reports server (in one). To keep this database synconised with the production box I will copy the redo logs and control files and then recover the database. I am running Oracle 7.3 on NT4. This server will be used to run the reports and, if disaster strikes, to take over from the production server.

Questions:

1. Is it valid to have differnet directory structures on the two boxes, e.g. can the SYSTEM tablespace datafile live on c:\db\system on the prod box and d:\rep\system on the replication box? And can the underlying structure be different, e.g. RAID5 on production and RAID1 on the standby?
2. To use the replication method I have said I assume that I the standby db cannot be updated because this will change the transaction numbers and thus the next recovery would fail, how can I open the database read only?
3. Is this a viable / workable solution to create a standby server and a reports server? If not any suggestions?

Thanks in advance
Tony

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 17 1999 - 09:52:57 CDT