RMAN configuration help!!!

[Former Member]

Hello Gurus,....

we configured RMAN in our SAP system, as per my knowledge ....follwoing is my understanding of RMAN..

>> RMAN mechanism of saving & deleting the log files.

a) Depends on the FS useage threshold value "br_archive" will trigger in the server.(normally)

b) as per the RMAN process , rman identify the "no.of offline log files in the directory"

c) First: it will start the "saving" archive log files

d) once the "saving" archive log files mechanism completes it start the "deleting " the archive log files.

e) In between any of the archive file has problems during "saving" process, archiver will terminate & again manually we have to "validate" the all the "archive log file" & BRarchiveer will start from beginning of the files.

i am tring to find is there any parameters which can adopt the file by file save & delete machanisam in "RMAN" configuration ..

Can any one please light on this Topic, which configuration parameter could do my needful,....??

we are running with Oracle 10.2.2 & SUN OS & SAP Netweaver 2004

Thanks in advance,....

Regards

mahi

[Former Member]

Any ideas..pls update....

[former_member204746]

you cannot overflow the file system above 100%. this does not make sense. Only in sports you can give your 110% !

[Former Member]

Hi guys,

Yes, you are right, we are using "BRARCIVE" only. process is that when ever "Oraarch" directory reaches to the threshold value BRarchive automatically starts & in turn it calls "RMAN".

Please go through the below log for the archlog file.

BR0280I BRARCHIVE time stamp: 2010-09-16 07.03.04

BR0008I Offline redo log processing for database instance: SID

BR0009I BRARCHIVE action ID: aeeddbra

BR0010I BRARCHIVE function ID: svd

BR0048I Archive function: save_delete

BR0011I 51 offline redo log files found for processing, total size 24745.470 MB

BR0112I Files will not be compressed

BR0130I Backup device type: rman_util

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRARCHIVE time stamp: 2010-09-16 07.03.04

BR0541I Starting offline redo log backup using RMAN...

BR0280I BRARCHIVE time stamp: 2010-09-16 07.03.24

BR0202I Saving /oracle/SID/oraarch/SIDarch1_158097_670937839.dbf

BR0280I BRARCHIVE time stamp: 2010-09-16 07.03.24

BR0202I Saving /oracle/SID/oraarch/SIDarch1_158098_670937839.dbf

BR0280I BRARCHIVE time stamp: 2010-09-16 07.06.14

BR0544I Saving offline redo log file save set piece - piece handle=SID_aeeddbra.29155_1 tag=AEEDDBRA comment=API Version 2.0,MMS

Version 5.5.0.2

#ARCHIVE.. /oracle/SID/oraarch/SIDarch1_158107_670937839.dbf

#SAVED.... aeeddbra 28996/29167

BR0522I 51 of 51 files/save sets processed by RMAN

BR0280I BRARCHIVE time stamp: 2010-09-16 07.27.06

BR0542I Offline redo log backup using RMAN successful

!!!! It has saved 51 files !!!!!

!!!!!!!!!!!Deletion process of 51 files started u2026!!!!!!!!!

BR0280I BRARCHIVE time stamp: 2010-09-16 07.27.07

BR0015I Offline redo log file /oracle/SID/oraarch/SIDarch1_158059_670937839.dbf deleted

BR0280I BRARCHIVE time stamp: 2010-09-16 07.27.07

BR0015I Offline redo log file /oracle/SID/oraarch/SIDarch1_158060_670937839.dbf deleted

BR0280I BRARCHIVE time stamp: 2010-09-16 07.27.07

BR0015I Offline redo log file /oracle/SID/oraarch/SIDarch1_158061_670937839.dbf deleted

My questions are:

1) Till the saving process completes & deleted process starts File system will not reduce the size. Here there is a possibility of u201Coverflow file systemu201D i.e file system can reach to 100%.

2) So, I wanted adopt the file by file save & delete mechanism in "RMAN" configuration ..

Regards

mahi

[Former Member]

Hi,

You can achieve this by OS level using the script.

Find the oldest Sequence number of archive log in the oraarch directory using script and provide the input to the below command. You can schedule this script frequently(according to your need). It will take the backup of one(oldest) archive file in oraarch directory and delete it.

BACKUP ARCHIVELOG SEQUENCE <Sequence_No> DELETE INPUT;

Rgds,

JP.

[lbreddemann]

>

> You can achieve this by OS level using the script.

>

> Find the oldest Sequence number of archive log in the oraarch directory using script and provide the input to the below command. You can schedule this script frequently(according to your need). It will take the backup of one(oldest) archive file in oraarch directory and delete it.

> BACKUP ARCHIVELOG SEQUENCE <Sequence_No> DELETE INPUT;

Sorry, but WHY SHOULD ANYBODY DO THAT?

This is 2010 - not the 80's, 90's or whenever scripts like those were acceptable to operate any important IT landscape!

Ok, so the requirement is to get back free filesystem space as soon as possibe.

You want to avoid problems like a full filesystem and the resulting archiver stuck.

Well in that case, why don't you just call brarchive more often?

Or why don't you simply use the -n option to limit the number of files handled in one brarchive run?

Set this to e.g. 10 and you'll have your file deletion after every 10 archive log files.

If this is not quick enough, you should really think of enlarging the storage space for your archive logs.

In fact, usually archive log files should be backed up at least twice and deleted only after at least one of those two backups had been testest to be corruption free...

regards,

Lars

[Former Member]

Hi,

I wouldnt do that.Why not use the SAP tools for the archived redo logs.As suggested by Lars please use BRarchive.

[lbreddemann]

Sorry, but why don't you just use the BR*Tools (BRARCHVE) ?

All you've to do is to setup BRARCHIVE to use RMAN and it will do all necessary RMAN configuration itself.

regards,

Lars