urgent..how to disable archiving [message #51133] |
Thu, 02 May 2002 00:37 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
In the init.ora i have given as
log_archive_start = false and disabled other parameters such as path and format.
log_archive_start = false
#log_archive_dest_1 = "location=/opt/oracle/admin/test/arch"
#log_archive_format = arch_%t_%s.arc
I have stopped the database and restarted the database.
svrmgrl> shutdown
after the database was shutdown normally
svrmgrl> startup
Now the database has started
When i issue
SVRMGR> select dbid,name,log_mode from v$database;
DBID NAME LOG_MODE
---------- --------- ------------
2123006614 test ARCHIVELOG
1 row selected.
The database is not showing as noarchivelog.
Is it that when the database is getting started i should issue
svrmgrl> alter database noarchivelog;
and then open the database.
|
|
|
Re: urgent..how to disable archiving [message #51190 is a reply to message #51133] |
Mon, 06 May 2002 11:28 |
jyothi_babub@yahoo.com
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
The parameter that u have changed in the init.ora tells oracle to stop all the back ground processes related to archiving. But it doesn't mean that u have the database is in no archive log mode. Untill and unless u issue alter database noarchivelog, while the database is in mount state, it will continue to be in the archive log mode.
Jyothi
|
|
|