Re: ideas?

From: Sean M <smckeown_at_earthlink.net>
Date: Fri, 31 May 2002 05:18:37 GMT
Message-ID: <3CF7077F.306511A4@earthlink.net>

Galen Boyer wrote:
>
> 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

Your query might delete a file that is still needed for recovery. Even though a log appears in v$log_history on the standby, you are not guaranteed that it has been applied. You have to test further - see my other post in this thread for an example.

Regards,
Sean Received on Fri May 31 2002 - 00:18:37 CDT