| ARCH files extension [message #59332] |
Wed, 12 November 2003 08:48  |
Mark K
Messages: 18
Registered: October 2003
|
Junior Member |
|
|
Not a major issue, but I turned on ARCHIVELOVE mode yesterday, and today expected to see a bunch of <file>.arc files in the ARCH destination directory.
There are files there (and they are the size of the redo logs), but the extension is <file>.dbf.
How dit that come about? Can the extension be set somewhere? I guess I like .arc only because it's familiar, and there will be no confusion with datafiles with the .dbf extension.
Running on RedHat Linux Enterprise Edition.
Thoughts?
-- Mark K.
|
|
|
|
| TYPO! [message #59333 is a reply to message #59332] |
Wed, 12 November 2003 08:49  |
Mark K
Messages: 18
Registered: October 2003
|
Junior Member |
|
|
LOL! Obviously, I switched *ARCHIVELOG* mode on, not ARCHIVELOVE.... don't know what that slip of the keyboard means, but it must mean something....
-- Mark K.
|
|
|
|
| Re: TYPO! [message #59336 is a reply to message #59333] |
Wed, 12 November 2003 09:18 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Good for you ;) You turned on something good, but dont archive it too soon ;)
Use log_archive_format to set your format. say "dbname_%t_%s.arc"
where dbname is your database name
%s log_sequence number
%t thread number
-Thiru
|
|
|
|
| Re: ARCH files extension [message #59348 is a reply to message #59332] |
Thu, 13 November 2003 00:21 |
Novin
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
hi,
modify your init<ORACLE_SID>.ora file. set log_archive_format = "your desire format"
ex. log_archive_format = "%S.ARC"
Norvin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
