Re: What Happens if...

SatarNag (satarnag_at_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:                       <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->