Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ideas?
Wow, they have come a long way with the Cygwin project AND made it free
since the last I looked in on it.
Thanks Galen
Barry
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:uy9e07ox7.fsf_at_hotpop.com...
> On Thu, 30 May 2002, bgt0990_at_trim.net wrote:
>
> > I'm a little rusty with my scripting, can someone give me a push in
> > the right direction. (I need to implement on an ver 8.1.5 NT4.0
> > server). What I need to do is fairly simple IE remove log files after
> > I know they have been applied in this manual standby server.
> > Basically;
> >
> > select sequence# from v$log_history
> >
> > delete any 'arcSEQ.001' from the d:\oracle\archcopy directory
> >
> > where SEQ is the sequence found from the v$log_history query.
> >
> > We don't have any programming tools to work with here other than
> > DOS/SHELL and SQL/PL/SQL
>
> Download the cygwin toolset, www.cygwin.com and write a "#!/bin/sh" file.
>
> #!/bin/sh
> echo "#!/bin/ksh" > runthis.sh
> sqlplus user/pass_at_instance <<EOF >> runthis.sh
> select 'rm d:\oracle\archcopy\arc' || sequence# || 'SEQ.001' from
v$log_history;
> EOF
>
> chmod 777 runthis.sh
> runthis.sh
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri May 31 2002 - 07:11:59 CDT