| archive logs don't appear [message #120525] |
Fri, 20 May 2005 05:55  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
I have a oracle 9.2 single instance database.
I wanted archivelogging so i did the following
SQL> connect sys/******@server as sysdba
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination D:\oracle\ora92\RDBMS
Oldest online log sequence 67
Current log sequence 69
SQL> Alter system set LOG_ARCHIVE_DEST = 'D:\oracle\archive' scope=SPFILE;
SQL> Alter system set LOG_ARCHIVE_FORMAT = 'arch_%t_%s_%r_%d.arc' scope=SPFILE;
SQL> ALTER SYSTEM SET log_archive_start=true SCOPE=spfile;
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\archive
Oldest online log sequence 67
Next log sequence to archive 69
Current log sequence 69
But there aren't files being created in the specified folder. Did i forget something? People are working on the database so changes are made to the data.
|
|
|
|
|
|
|
|
| Re: archive logs don't appear [message #120533 is a reply to message #120529] |
Fri, 20 May 2005 06:10  |
Frank Naude
Messages: 4593
Registered: April 1998
|
Senior Member |
|
|
No, it will not empty anything. It will switch the database to the next available redo log file and start archiving the previous one to the archive destination.
See the SQL Reference Guide for an exact description.
Best regards.
Frank
|
|
|
|
|
|
|
|
| Re: archive logs don't appear [message #120547 is a reply to message #120525] |
Fri, 20 May 2005 07:09 |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
I found the problem
SQL> Alter system set LOG_ARCHIVE_FORMAT = 'arch_%t_%s_%r_%d.arc' scope=SPFILE;
This format is not allowd. Changed the format to arch_%t_%s.arc and now it is working.
Frank thanks for helping
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
