| Archive mode [message #51312] |
Wed, 15 May 2002 06:20  |
Nita
Messages: 34
Registered: March 2002
|
Member |
|
|
I have archive mode currently started. When I attempted to stop archive mode
alter datadase no archivelog
I get the error:
"ORA-01509 specified name 'string' does not match actual 'string'
Cause: The database name specified in ALTER DATABASE does not match the name of the currently mounted database.
Action: Correct the database name spelling or DISMOUNT the mounted database."
I don't specify the name of the database! How do I turn off archiving???
Thank you for any help!!
|
|
|
|
|
|
| Re: Archive mode [message #51316 is a reply to message #51312] |
Wed, 15 May 2002 08:52  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You can do this in sqlplus or svrmgr. You need to use "noarchivelog" (no space).
sqlplus internal
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog
SQL> alter database open
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
