-
Disable archive log mode for 11g
Hi,
I want to disable archive log mode for my 11g database.
The steps I think should be followed are:
1. shutdown immediate;
2. Change the init.ora parameter related to the instance
In pfile:
log_archive_start = false
3. startup mount pfile='';
4. alter database noarchivelog;
5. alter database open;
What should the step 2 be, in case I have an SPFILE???? Please suggest.
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|