| Database [message #152343] |
Thu, 22 December 2005 11:13  |
chintu001
Messages: 1
Registered: December 2005
|
Junior Member |
|
|
Hello there,
I have created a database with noarchivelog. Once database is created I did following.
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
So now its change from Noarchivelog to Archivelog. Now my question is Do I need to alter databse whenever I shutdown and startup?
Please advise.
Thanks,
Chin
|
|
|
|
| Re: Database [message #152361 is a reply to message #152343] |
Thu, 22 December 2005 12:59  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I think you are good to go, although I'm sure the administrative guide describes for sure:
MYDBA > select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
MYDBA > shutdown immediate;
ORA-01031: insufficient privileges
MYDBA > connect sys as sysdba
Enter password:
Connected.
SYS AS SYSDBA> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS AS SYSDBA> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248600 bytes
Variable Size 155189928 bytes
Database Buffers 130023424 bytes
Redo Buffers 2945024 bytes
Database mounted.
SYS AS SYSDBA> alter database archivelog;
Database altered.
SYS AS SYSDBA> alter database open;
Database altered.
SYS AS SYSDBA> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
SYS AS SYSDBA> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS AS SYSDBA> startup;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248600 bytes
Variable Size 155189928 bytes
Database Buffers 130023424 bytes
Redo Buffers 2945024 bytes
Database mounted.
Database opened.
SYS AS SYSDBA> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
