-
Hello,
i need to perminantly turn archive log mode on?
any suggestions?
thanks
Jigar
-
suggestions for...? just do it
-
Good Idea, go ahead an do it!
Thanks
Kishore Kumar
-
i actually needed the syntax and the know how on how to do it.
thanks
-
Ok, what do you do is set the parameter for
log_archive_start
log_archive_dest_1 or log_archive_dest
log_archive_format
in init.ora found in oracle_home\admin\sid\pfile
Log_archive_start should be true
log_archive_dest_1 or log_archive_dest, whichever version you are using. Here you should indicate the dir, in which you are going to store the archive files, mention the full path.
log_archive_format usually the format in which you want to store the archive files, something like arch%t%s.log. Here %t refers to the redo log thread number and %s refers to the log sequence number.
Shut down the database with immediate or normal option.
connect to sqlplus as internal
startup the database with MOUNT option
issue
alter database archivelog
then open the database
this will enable archiving of the database permanently.
Rama
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|