| urgent..how to disable archiving [message #51136] |
Thu, 02 May 2002 02:50  |
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 #51137 is a reply to message #51136] |
Thu, 02 May 2002 03:19  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
First Make sure your database is in mount stage.
Then give this command:
svrmgr> alter database noarchivelog;
svrmgr>
There is no need to comment out the following:
log_archive_dest_1
log_archive_format = arch_%t_%s.arc
Regards,
Vikas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
