/oracle/SID/sapbackup/bedksrwy.spa

[Former Member]

Dear All,

We are using Aix and Oracle 10.2 as our DB. As i found during monitoring /oracle/SID/sapbackup one folder bedksrwy.spa

is found and all sapdat1 to sapdat4 files structure found here.

root@CILECCDB:/oracle/PDR/sapbackup/bedksrwy.spa#

root@CILECCDB:/oracle/PDR/sapbackup/bedksrwy.spa#ls

sr3.data1 sr3.data17 sr3.data6 sr3700.data13 sr3700.data6

sr3.data10 sr3.data18 sr3.data7 sr3700.data14 sr3700.data7

sr3.data11 sr3.data19 sr3.data8 sr3700.data15 sr3700.data8

sr3.data12 sr3.data2 sr3.data9 sr3700.data16 sr3700.data9

sr3.data13 sr3.data20 sr3700.data1 sr3700.data2 sr3usr.data1

sr3.data14 sr3.data3 sr3700.data10 sr3700.data3 sysaux.data1

sr3.data15 sr3.data4 sr3700.data11 sr3700.data4 system.data1

sr3.data16 sr3.data5 sr3700.data12 sr3700.data5 undo.data1

root@CILECCDB:/oracle/PDR/sapbackup/bedksrwy.spa#ls -ltr

total 3840

-rw-rr 1 orapdr sapsys 8556388352 Jun 11 09:19 sr3.data4

-rw-rr 1 orapdr sapsys 8325701632 Jun 11 09:19 sr3.data3

-rw-rr 1 orapdr sapsys 7927242752 Jun 11 09:19 sr3.data2

with last date 11 jun. When i took monthly offline backup time and size gets atmost double. I m new with oracle DB.

Pl. guide what to do in such cases.

Thanks in advanced

Naik Diptesh

[Former Member]

Hi Diptesh,

Its very clear that the backup has been taken on disk and the backup location (parameter backup_root_dir) has been set as /oracle/SID/sapbackup in the init<sid>.sap (backup profile).

If you like to change the backup location, change the parameter value to appropriate path and the databse will be backed up in the new location.

Regards,

Varadharajan M

[volker_borowski2]

>

> Hi Diptesh,
> 
> Its very clear that the backup has been taken on disk and the backup location (parameter backup_root_dir) has been set as  /oracle/SID/sapbackup in the init<sid>.sap (backup profile).
> 
> If you like to change the backup location, change the parameter value to appropriate path and the databse will be backed up in the new location.
> 
> Regards,
> Varadharajan M

Sorry to correct you, but your assumtion is wrong!

The *.spa subdirectories are created when doing FULL Backups to enable RMAN later to catalog the backup.

The files in sapbackup are sparse file copys of the datafiles and do not actually allocate the space they show,

allthough tools not being aware of this may do a faulty non-sparse read (resulting in the seen behavior).

If the backup to disk would have been configured, the directory would not carry the .spa extension.

You can check this with doing

ls -l /oracle/SID/sapbackup/bedksrwy.spa

vs.

du -k /oracle/SID/sapbackup/bedksrwy.spa.

and you should see the difference in space allocation.

If the backup where these files belong to is finished or aborted, these files can be deleted.

To be sure, verify that the backup bedksrwy was a full backup. There should be a log bedksrwy.f* which you can consult.

To verify that these files are not accidently created files, crosscheck table V$DATAFILE, that these files do not

belong to your active database.

Best regards

Volker

[Former Member]

Dear All,

Thanks for updating me.

Some more clarity on same issue.

On 11th June my offline backup failed (thr. DB13 at 3am) .

IN db13 log file of 11th June where bedksrwy file is there with .lst extension.

PL. check and guide me.Now what to do with bedksrwy.spa directory.

remove or continue with the same. Any risk.

Thank you.

Naik DIptesh

[volker_borowski2]

Well, the risk seems close to zero to me right now, but let's make sure.

Can you please post list of all files from June 11th ("grep" them)

ls -lad /oracle/SID/sapbackup/*

there have to be a couple of files and directories

In addition, crosscheck with sqlplus

select * from v$datafile where name like '%sapbackup%'

... should return nothing

BTW, if you are not doing incremental backups, there is no need to use RMAN, so you can

change your DB13 backups from "FULL" to "WHOLE" you will not use RMAN then and avoid

the creation of spares files.

Volker

[Former Member]

It depends on your backup strategy (if you have one)... Could it be that the offline backup is being made to disk and after that is written to tape? Are you keeping only one version on the file system or several? Is this backup overwritten after a certain retention period?

Just a couple of things to think about..

Kind regards,

Mark