Hi
We are using the standby database approach for updating our reporting database. Each evening the archived redo logs are copied and applied. Currently we are doing this from one HP-UX11 server to another, with Oracle 8.1.6
What I would like to know is; although not recommended, is it possible to take these redo logs from our UNIX server, copy them across to a windows server (maybe Windows 2003) and apply them to an exact copy of the database held there. We do not wish to use this database for failover reasons, just for reporting (read only).
I guess what I need to know is, are redo logs operating system specific or Oracle specific, ie the same regardless of platform. Is block size an issue?
Has anyone tried to do this? All your comments are welcomed.
Thanks
We are using the standby database approach for updating our reporting database. Each evening the archived redo logs are copied and applied. Currently we are doing this from one HP-UX11 server to another, with Oracle 8.1.6
What I would like to know is; although not recommended, is it possible to take these redo logs from our UNIX server, copy them across to a windows server (maybe Windows 2003) and apply them to an exact copy of the database held there. We do not wish to use this database for failover reasons, just for reporting (read only).
I guess what I need to know is, are redo logs operating system specific or Oracle specific, ie the same regardless of platform. Is block size an issue?
Has anyone tried to do this? All your comments are welcomed.
Thanks