Home » RDBMS Server » Server Administration » ArchiveLog Mode
ArchiveLog Mode [message #51856] Tue, 18 June 2002 07:36 Go to next message
Eddy Confer
Messages: 17
Registered: January 2002
Junior Member
My database was created as NOARCHIVELOG. The LOGGING option on individual tables is selected. Is it true that no logging is happening as long as NOARCHIVELOG is set?

Report message to a moderator

Re: ArchiveLog Mode [message #51862 is a reply to message #51856] Tue, 18 June 2002 11:31 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No. It is not true. The two events are not linked in any way.

To clarify this issue and learn more about LOGGING/NOLOGGING option read This Information

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

Report message to a moderator

Re: ArchiveLog Mode [message #51870 is a reply to message #51856] Tue, 18 June 2002 19:46 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Hello Eddy,

Archieving is a process where ARCH background process makes copies of Redo Log files at a loction specified in the parameter file,it may be a different hard disk or even a Tape drive.

While loging is a complete different process where LGWR is writing the redo log files.

Hence in NoArchieveLog Mode, the ARCH process is not making copies, but LGWR is still doing its work, and logging is taking place.

Regards,

Vikas.

Report message to a moderator

Previous Topic: Re: ora-27101
Next Topic: ORA-01089 Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:28:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.