OraFAQ Forum: Data Guard » Archive Gap Script

Home » Server Options » Data Guard » Archive Gap Script (redhat 5.5 )

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

Archive Gap Script [message #546313]

Tue, 06 March 2012 02:34

ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE

Member

Dear All,

I am working on Data Guard concepts. I have configured Data Guard which is working fine.

Now I am trying to work on script which can give me output on OS prompt if there are any archive gaps..

I tried to use few commands on a script archgap.sh as

archgap.sh
sqlplus "/ as sysdba"
select * from v$archive_gap;

I am trying to run above script on OS prompt as

ABC:/home/oracle>sh archgap.sh

but I am not getting output ... I want it a way that this script should run within interval of 5 min and give output on OS prompt.

Can anyDear one pls suggest/guide me??

Thanks.
Ganesh

Report message to a moderator

Re: Archive Gap Script [message #546318 is a reply to message #546313]

Tue, 06 March 2012 02:40

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Something like:

Code: [Select all] [Show/ hide]

while :
do
  date
  sqlplus "/ as sysdba" <<EOF
select * from v$archive_gap;
exit;
EOF
  echo '----------------------'
  sleep 300
done

Regards
Michel

Report message to a moderator

Re: Archive Gap Script [message #546337 is a reply to message #546318]

Tue, 06 March 2012 03:52

ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE

Member

Thanks Michel... I am trying to use above logic in my script...

Report message to a moderator

Previous Topic:	changing redo log folder on primary database
Next Topic:	stopping log shipping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:01:34 CDT 2025