Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Questions about applying archive logs

Questions about applying archive logs

From: Hub <hub_at_houston.rr.NOSPAM.com>
Date: Mon, 14 Oct 2002 05:31:25 GMT
Message-ID: <NEsq9.125210$8o3.3755846@twister.austin.rr.com>

Howdy ya'll.. I have some archive log questions. Oracle 9i, linux, standard edition.

Ok our main prod server spits out archive logs. On a seperate standby server I have copies of all the cold backup files.. tablespace, logs, control, redo, etc.. Every 15 minutes I cron job rsync the archive logs to the standby server. What should I do on the standby side to automatically apply these archive logs to the standby server as they arrive (or soon thereafter)? Then if for some reason we have to switch from the main prod server to the standby one.. what is the appropriate technique/syntax to take the latest archive/redo files, apply them to the standby box, bring the database up on the standby server.. etc.. does the main prod server have to be down to do this or can it still be running?

Also, how can i have this standby database be read-only, updated as the latest archive logs arrive, used for a report server..

Also these archive logs, can I apply them to another database somehow? Just pick an archive log file and say "try to apply all of these changes to this database"?

thx a bunch.. Hub

hub_at_houston.rr.NOSPAM.com Received on Mon Oct 14 2002 - 00:31:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US