| when to delete archive log file [message #118064] |
Mon, 02 May 2005 21:18  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
I want to know when should i delete my archive log file . i know most of will answer that delete archive log when the 90% space allocated to archive file is filled up and so on.
But i want to know that what if i delete the archive file after taking my hotback...
note during hotback more archive file is generated so i want to know is the change that are made in database will be there in redologfile that is been copied during hotback. so that after taking my hotback can i delete my archive file.
Please let me know when should delete my archive log file?
from :- sunil
|
|
|
|
| Re: when to delete archive log file [message #118073 is a reply to message #118064] |
Mon, 02 May 2005 23:24  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> i know most of will answer that delete archive log when the 90% space allocated to archive file is filled up and so on
That answer would be a twaddle.
Ideally speaking , archived logs should be deleted only after a hotbackup.
>>note during hotback more archive file is generated
Nothing MORE is specifically generated during backup.
the archive info is generated as usual.
>>so i want to know is the change that are made in database will be there in redologfile that is been copied during hotback. so that after taking my hotback can i delete my archive file.
For that very same reason, you need to archive the logfiles before starting the backup. RMAN does that internally for you.
RMAN backs up the archived logs as of THAT point.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
