Home » RDBMS Server » Server Administration » How: Script archive log transfer to standby db
How: Script archive log transfer to standby db [message #225180] Sun, 18 March 2007 21:48 Go to next message
Nabil_Lueeny
Messages: 1
Registered: March 2007
Junior Member
Hi,

I’m implementing disaster recovery right now. For some special reason, the only option for me is to implement non-managed standby (manual recovery) database.

The following is what I’m trying to do using shell script:
1. Compress archive logs and copy them from Primary site to Standby site every hour. ( I have a very low network )
2. Decompress archive logs at standby site
3. Check if there are missed archive logs. If no, then do the manual recovery

Did I miss something above? And I’m not skill in to build shell scripts, is there any sample scripts I can follow? Thanks.

Nabil

[Updated on: Sun, 18 March 2007 21:51]

Report message to a moderator

Re: How: Script archive log transfer to standby db [message #225181 is a reply to message #225180] Sun, 18 March 2007 21:57 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>And I’m not skill in to build shell scripts,

Does your manager realize that you are not qualified for this task?

Might the desired scripts be Operating System (yet unspecified) dependent & very site specific?



Re: How: Script archive log transfer to standby db [message #225192 is a reply to message #225180] Mon, 19 March 2007 01:10 Go to previous messageGo to next message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

You can use rsync utility to transfer the archive log with "-z" option, it will compress it to save network band width, so you do not need to compress it first and then extract it on standby.
Re: How: Script archive log transfer to standby db [message #225274 is a reply to message #225192] Mon, 19 March 2007 08:28 Go to previous message
bhanu11
Messages: 6
Registered: March 2007
Junior Member
No Message Body

[Updated on: Mon, 19 March 2007 08:28]

Report message to a moderator

Previous Topic: LOB's and Disk SPace
Next Topic: How can i Increase the RollBack
Goto Forum:
  


Current Time: Fri Dec 02 14:17:49 CST 2016

Total time taken to generate the page: 0.13892 seconds