Re: How to start ARCHIVELOG ?

From: Matt Myers <mmyers_at_plano.net>
Date: 1995/07/29
Message-ID: <3ve9bf$sul_at_dns.plano.net>#1/1


Since an archive log isn't generated until a log switch occurs, try forcing a log switch.

	sqldba lmode=y
	connect internal
	alter system archive log current;
	exit

Now check your log directory. You should see a file there now.

Additionally, I'd change a couple of parameters as follows:

	log_archive_dest	= /users/oracle7/dbs/test7/arch/test7
	log_archive_format	= '_%s.arc'

The reason being is that the way you have it defined, you'll wind up with archive log files that look like 'arch.loglog123_1.arc'. The %t also isn't really necessary unless you're running Oracle Parallel Server. If you're not, %t will always be 1(assuming you don't set the THREAD init.ora parameter). With this new format, you should get archive log files that look like 'test7_123.arc'. This is also assuming that 'test7' is you're instance name. Received on Sat Jul 29 1995 - 00:00:00 CEST

Original text of this message