Home » SQL & PL/SQL » SQL & PL/SQL » howto activate archive log on W2K?
howto activate archive log on W2K? [message #7960] Fri, 18 July 2003 12:57 Go to next message
Ingo Hochmuth
Messages: 1
Registered: July 2003
Junior Member
Hello,
howto activate archive log on W2K - Server with Oracle 8.1.7.4 EE runtime version?

In my init.ora file I have set:

LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST_1 = 'LOCATION=d:arch1 MANDATORY REOPEN=60'
LOG_ARCHIVE_DEST_2 = 'SERVICE=backup OPTIONAL REOPEN=60'
LOG_ARCHIVE_DEST_STATE_1 = ENABLE
LOG_ARCHIVE_DEST_STATE_2 = DEFER
LOG_ARCHIVE_FORMAT = log%t_%s.arc

- direcory d:arch1 exist.
What must I do also for proper operation?

Report message to a moderator

Re: howto activate archive log on W2K? [message #7971 is a reply to message #7960] Fri, 18 July 2003 19:03 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
shutdown immediate
startup mount
alter database archivelog;
alter database open;

Report message to a moderator

Previous Topic: Setting relations between tables
Next Topic: ora-06502 when printing long varchar
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 23:52:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.