on 03-01-2011 11:53 AM
Hi,
I´ve found two types of archivelog, the system has been creating SIDARCHARXXXX files. After I´ve deactivate/activate the archive_log mode again, the archive logs are ARCXXXX.
Why?
More thanks
Check all the values of archive parameters and correct them(Format, location etc).
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I was reset a parameter of the log archive and after that the name of the file are ARC03076.
Jep,
and that is exactly the change you did!
You changed proably
log_archive_dest=/oracle/SID/oraarch/SIDARCH
to
log_archive_dest_1='LOCATION=/oracle/SID/oraarch/'
and that is where "SIDARCH" vanished.
Allthough the parameter suggests to be a directory, in fact it is a PATH-prefix and so
SIDARCH is added to the filename in the first case, allthough it is not obvious.
Volker
Dear Ruben,
Please check LOG_ARCHIVE_FORMAT DB parameter.
It seems that archive log is not stopped, a DB restart is neccesary.
Please provide the output of the following command (login to SQLPLUS with orasid user)
sql> archive log list;
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.