-
We've got two instances on the same server so I've set the archive log format to contain the name of the sid to avoid confusion, but the archive log file does not have the right format. - %opcflivo%67_1.ARC.
Parameter in init.ora
log_archive_format = %%opcflivo%%%s_%t.arc
Do I have too many % ?
Thanks.
-
-
-
joyce_ank,
Use only:
log_archive_format = opcflivo_%s_%t.arc
You can not have % in the file names.
Check the latest Oracle DBA forums:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
Hope that helps,
--clio_usa
Senior Oracle DBA
-
To access the OTN link you need valid account and password there.
It is free so go and create one. A bunch of goodies could be found there.
Cheers,
--clio_usa
Senior Oracle DBA
-
Hi,
If you want to create the filenames along with the sid then give like this:
log_archive_format=%%ORACLE_SID%%S.ARC.
Vijay.
Say No To Plastics
-
Thanks all for your help.
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
|