|
|
| Re: changing database from non-archieve to archieve mode [message #62381 is a reply to message #62379] |
Sun, 18 July 2004 22:11   |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Follow the following steps :
1) Add 2 initialization parameters in ur init/spfile
i) LOG_ARCHIVE_START=TRUE
ii) LOG_ARCHIVE_DEST='PATH FOR ARCHIVE LOGS'
2) shutdown the DB cleanly
3) Mount the DB and issue
ALTER DATABASE ARCHIVELOG;
4) Open the DB.
Now ur DB is running in archivelog mode. You can use LOG_ARCHIVE_DEST_1, LOG_ARCHIVE_DEST_2 to store archive logs on multiple locations.
Best of luck.
Daljit Singh
|
|
|
|
| Re: changing database from non-archieve to archieve mode [message #62429 is a reply to message #62379] |
Wed, 21 July 2004 07:03 |
Harish Shanbhag
Messages: 19
Registered: July 2004
|
Junior Member |
|
|
other way is to use Oracle Enterprise Manager called as OEM.
Log on to the database as sysuser or system,
chk in the navigation tree for configuration
and chk the chk box for archivelog mode and also
specify the path for arch log destination.
if successful, OEM prompts for database shutdown
choose the option, normal or immediate.
after shutdown and startup ur db is archivelog mode.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
