Subject: Re: What Happens if...
Newsgroups: comp.databases.oracle.server
References: <19970731233501.TAA00701@ladder02.news.aol.com>
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
SatarNag (satarnag@aol.com) wrote:
: Hi Again ;)
: If I was archiving to a tape device, what would happen if I changed the
: tape without turning the archiver off? does it stay in a buffer till
: another tape is replaced? If so, what is the name of the buffer? or does
: the transactions that I am updateing/deleting/ect...spew to nowhere?
:
: Satar Naghshineh
:
Satar,
What will happen is that your database will function normally until it
attempts a redo log switch. At that point, it will try to archive the redo log
to tape. Since there is no tape available, the database FREEZES (except for
SELECT statements) until it can properly archive to tape.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 90+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page