Re: HELP!ARC files

Go to my web site, find the Backup and Recovery page, and download the 70-page introduction to backup and recovery concepts. Oh, and then read it. You do *not* start deleting archives because you need space: in the process you make your database unrecoverable to the point of failure, and guarantee loss of committed transactions.

What should you do now? Take a new, closed, entire database backup. You can then get rid of all prior archives ('cos with a gap in the sequence, they're not that much use to you anyway).

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Ho" <kowho_at_singnet.com.sg> wrote in message
news:8rqgks$d00$1_at_coco.singnet.com.sg...


> I have deleted some of the arc files in c:\database\archive folder due

> to disk space constraints.

>

> My concern is how does it affect the future recovery ?

>

> What actions do I need to take ?

>

> How can I tell the system to start recover from the 1st arc in the

> folder since I have deleted some of them?

>

> Many thanks for your help.

>

>

>