Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!atl-c02.usenetserver.com!news.usenetserver.com!border1.nntp.ash.giganews.com!nntp.giganews.com!newsrout1.ntli.net!news-in.ntli.net!newsfeed01.sul.t-online.de!t-online.de!news.belwue.de!not-for-mail
From: Holger Baer <holger.baer@science-computing.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Object required for (Wscript.sleep 15000)
Date: Wed, 05 May 2004 10:19:26 +0200
Organization: InterNetNews at News.BelWue.DE (Stuttgart, Germany)
Lines: 41
Message-ID: <c7a82f$erj$1@news.BelWue.DE>
References: <35a97e60.0405042314.39ee6380@posting.google.com>
NNTP-Posting-Host: blackhole.science-computing.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.BelWue.DE 1083745168 15219 193.197.16.3 (5 May 2004 08:19:28 GMT)
X-Complaints-To: news@news.belwue.de
NNTP-Posting-Date: Wed, 5 May 2004 08:19:28 +0000 (UTC)
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040116
X-Accept-Language: en-us, en
In-Reply-To: <35a97e60.0405042314.39ee6380@posting.google.com>
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260810

benazir wrote:
> Dear Howard,
> 
>  I got your backup code from the Dizwell web site.
> It seems a very good way to perform backup via macro but it may
> contains some bug,which one can found initially when it run through
> the Excel.
> 
> For Example:
>  When we run the following macro in Excel, we got errors like:
> 
> 1.	Object required for (Wscript.sleep 15000)
> 2.	Object required for (Wscript.Echo "Not in Archivelog Mode! Hot
> Backups not possible! Aborting!")
> 3.	File Not found  (strArchive = "arcchk.txt)  (Set objArchive =
> objFS.OpenTextFile(strArchive, 1, 0)
> 

Benazir, I'm sorry to say that, but your mail shows that you don't
understand the tools you are using and I fear that may include the
database.

Please do yourself a favour and register at http://otn.oracle.com.
(Registration is free) You will find an overwhelming mass of documentation
including the Concepts Guide and several books targeted on backup
and recovery. Read and understand them (from cover to cover).

The funny thing is, that many people will somehow get a backup
skript going they grabbed off some website; but the will constantly
fail to ever test if they actually can recover *without* loss of
data.

The investment you do today is about 5 minutes, but it might help
help you to keep your job when disaster strikes in a few
weeks/months/years. It's even possible that you'll learn how to
prevent most disasters in the first place (by using that grey mass
that sits between your ears ;-) ).

Regards,

Holger