starting auto arch without an init file

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Thu, 09 Oct 2003 01:48:28 GMT
Message-ID: <M73hb.246728$mp.155190@rwcrnsc51.ops.asp.att.net>

Using Oracle 9.2, after installing it I noticed there is no init<SID>.ora file in \database. There is an spfile of course, and \admin\mysid\pfile has "init.ora.77200219445" in it. (What's that long number bit all about?) I have turned on archiving, no problem but I would like to make archiving automatic rather than manual. So, here is the question. Is there a way I can do this without creating an init.ora file? Don't get me wrong, I have no objection to creating an init.ora file, I just want to know if there is a way to do it without an init.ora file.

ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE; as you know does not work because it is not dynamic.

TIA,
Mike Received on Wed Oct 08 2003 - 20:48:28 CDT