OraFAQ Forum: Server Administration » How: Script archive log transfer to standby db

Home » RDBMS Server » Server Administration » How: Script archive log transfer to standby db

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How: Script archive log transfer to standby db [message #225180]

Sun, 18 March 2007 21:48

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: How: Script archive log transfer to standby db [message #225192 is a reply to message #225180]

Mon, 19 March 2007 01:10

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.

Report message to a moderator

Re: How: Script archive log transfer to standby db [message #225274 is a reply to message #225192]

Mon, 19 March 2007 08:28

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:35:55 CST 2024