1832506 Members
4736 Online
110043 Solutions
New Discussion

Rman & Redo Logs

 
SOLVED
Go to solution
SSP_1
Regular Advisor

Rman & Redo Logs

Hi Experts,

We have RMAN , veryday after backup it usually deletes the redo log files. What is the settings required if I have to turn off deletion of redo log files.
Obstacles exist to challenge you to keep going. Not to quit.
2 REPLIES 2
Massimo Bianchi
Honored Contributor

Re: Rman & Redo Logs

Hi,
well i hope it deletes the archived log, not the online redo log.

Besides this, you shall find in your script a line similar to

"archivelog all delete input".

If you trim out the "delete input", rman will save your archive withput deleting them.

Rememeber that if you don't delete them, sooner or later you will have an archive stuck.

If you want to have a second copy, think of using the "duplex channel" option.

If you want more detail on these second option, just ask :)

HTH,
Massimo
Yogeeraj_1
Honored Contributor
Solution

Re: Rman & Redo Logs

hi,

if you have something like:
==============================================
run {
allocate channel fs1 type disk format='/backup/rman/al/al1_t%t_s%s_p%p';
set limit channel fs1 kbytes=100000;
backup filesperset 10 archivelog all delete input;
release channel fs1;
}
===============================================

you just have to remove the "delete input"!

btw, why would you want to do this?

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)