Re: LOG_ARCHIVE_DEST_n

You can defer or enable archiving to a destination at the session level -and it makes sense to do so. For example, log_archive_dest_3 is mandatory, and becomes full.... that means the entire system will hang when ARCH can't successfully archive there, and the online logs loop round.

Hence, the DBA fires up a session, defers archiving to that destination, and the database springs back into life. DBA then fixes up the underlying problem, and re-enables archiving there.

Regards
HJR "Buck Turgidson" <remove-me_jc_va_at_hotmail.com> wrote in message news:bkWj6.4171$TD1.318685_at_bgtnsc05-news.ops.worldnet.att.net...
> I am reading up on 8i recovery. It says that the aforementioned parameter
 is
> session-modifiable. A query against V$PARAMETER confirms this. Maybe I
 don't have
> the whole context, but this doesn't make sense to me. I could understand
 being
> system-modifiable, but in what context is it session-modifiable?
>
> Thanks to anyone who could clear up my confusion.
>
>
Received on Mon Feb 19 2001 - 02:26:31 CST