| Archivelog Mode in 8.1.6 [message #368265] |
Tue, 24 October 2000 07:20  |
Ralphie
Messages: 14
Registered: October 2000
|
Junior Member |
|
|
I am having problems shutting down the database and editing the init.ora file in 8.1.6 on Windows 2000. I can shutdown the DB, but I recieve an error when I try to do a startup or startup mount command after.
Can anyone tell me how to get the database into archivelog mode?
Thank you in advance,
Chris
|
|
|
|
| Re: Archivelog Mode in 8.1.6 [message #368266 is a reply to message #368265] |
Tue, 24 October 2000 08:00  |
Melissa
Messages: 65
Registered: January 2000
|
Member |
|
|
Edit your init.ora:
Set log_archive_dest.
Set log_archive_start = true.
Set log_archive_format = "{dbname}%t_%s.arc"
Shutdown your database.
Startup mount.
alter database archivelog;
archive log start;
alter database open;
|
|
|
|
| Re: Archivelog Mode in 8.1.6 [message #368267 is a reply to message #368265] |
Tue, 24 October 2000 08:06 |
Ralphie
Messages: 14
Registered: October 2000
|
Junior Member |
|
|
I have changed my init.ora to show:
log_archive_start = true
log_archive_dest_1= "location=C:\Oracle\oradata\cf2\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
After making these changes is when I attempt to do a shutdown and a startup mount and recieve the error the "feature in not available".
Am I missing something?
|
|
|
|
|
|
| Re: Archivelog Mode in 8.1.6 [message #368293 is a reply to message #368265] |
Thu, 02 November 2000 04:32 |
Frank Jørgensen
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
Hi there,
Do like this.
1. Shutdown your database
2. Set oracle_sid=<SID>
3. Start SVRMGRL and connect as INTERNAL
4. write: Startup nomount;
5. Write: alter database mount exclusive;
6. Write: alter database archivelog;
7. Write: alter system switch logfile;
8. Write: Startup force;
And your database is now running with archivelogging.
Yours Faithfully
Frank from Denmark.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
