Home » RDBMS Server » Server Utilities » Archivelog Mode in 8.1.6
Archivelog Mode in 8.1.6 [message #368265] Tue, 24 October 2000 07:20 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #368268 is a reply to message #368265] Tue, 24 October 2000 10:45 Go to previous messageGo to next message
Melissa
Messages: 65
Registered: January 2000
Member
Change to:

log_archive_dest_1="C:\Oracle\oradata\cf2\archive"
log_archive_format = "%%ORACLE_SID%%T%TS%S.ARC"
Re: Archivelog Mode in 8.1.6 [message #368293 is a reply to message #368265] Thu, 02 November 2000 04:32 Go to previous message
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.
Previous Topic: Merging Fields with SQL*Loader
Next Topic: how to load data into oracle from a xml file..
Goto Forum:
  


Current Time: Sat May 21 05:17:44 CDT 2022