ora-00900 [message #50335] |
Mon, 11 March 2002 19:14 |
krishna
Messages: 141 Registered: October 1998
|
Senior Member |
|
|
I mounted my database(did not open it).
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
Database mounted.
SVRMGR> alter database archivelog;
Statement processed.
SVRMGR> log archive start
2> ;
log archive start
*
ORA-00900: invalid SQL statement
Why am I getting ora-00900. What's wrong with giving 'log archive start' ?
|
|
|
Re: ora-00900 [message #50337 is a reply to message #50335] |
Mon, 11 March 2002 22:21 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
After alter databse archivelog. This means your database is in archive mode.
SVRMMGR archive log list; -- will show the archive log file.
Starting archive mode, you have two method.
1. Shutdown the database and set these parameter in initSID.ora
log_archive_start= TRUE;
log_archive_dets = destinatino of archive file;
log_archive_format = archived format file;
2. to automatic starting archive more. please use this command
SVRMGRALTER SYSTEM archive log start; -- or archive log start;
Hope this is helping.
|
|
|