How
to disable archive log?
Question1:
I have a test instance, which
I am running in archive log mode.
But from time to time I have
to do a full import of one user which is owner of an application. So every
time I do the import, I get houndreds and houndreds of Archive log files.
I tried to disable archive
log for this situation, but I failed.
Neither alter database archive
log disable nor outsigning of the entrys in the init-file worked.
Ans1:
Shut the database, mount the
database issue alter database noarchivelog;
alter database open;
and also make sure it is in
restricted session mode, and you are really the only one working.
Only in that case the 'hole'
is acceptable.
Ans2:
One additional point.
When you put the instance back in archive log mode you will need to do
another backup as all previous became useless when you switched from archive
log -> no archive log -> archive log.
Kenny Gump
Question 2:
I am having a problem with the auto Archive on Oracle 8.0.4
on NT. I keep setting the log_archive_start to TRUE and for some reason
it
keeps going back to FALSE, forcing me to have to manually do archive
logging.
Does anyone know why this would be happening. I am not an expert
in this
area and maybe there is some step I am missing.
Ans1 to question2:
Is it possible that the database sometimes starts
automatically using the strt{SID}.cmd and init{SID}.ora
and that you start it from the instance manager at
other times using a stored set of parameters ?
Ans2 to question2:
You have to set both the init.ora parameter *and* the database to archivelog
mode
(with ALTER DATABASE ARCHIVELOG). See the Oracle docs for more details,
and the
other init parameters affecting the naming, sizing and location of
redo archive
logs. Read up! :-)
Steve Phelan.