Video Screencast Help

Rman policy/schedule creation best practice question

Created: 08 Jan 2014 • Updated: 24 Jan 2014 | 1 comment
This issue has been solved. See solution.

I have a meeting coming up about rman jobs and the DBA's are asking up to change our policies.

This is what they want different policies for FULL INCR and ARCH

 

Full backup policy name for prod

Incr backup policy name for prod

Arch backup policy name for prod

Full backup policy name for non-prod

Incr backup policy name for non-prod

Arch backup policy name for non-prod

What I have setup currently

Policies:

Production

                Policy: P-A31-BE-ORA

                                Schedules:

                                                Weekly-database-backup

                                                Default-database-backup

                                                Archivelog_backup

 

None-Production

                Policy: N-A31-BE-ORA

                                Schedules:

                                                Weekly-database-backup

                                                Default-database-backup

                                                Archivelog_backup

 

 

what way would you go with, I have a meeting coming up soon so I hope someone can chim in :)

 

Operating Systems:

Comments 1 CommentJump to latest comment

Riaan.Badenhorst's picture

Hi,

 

With strategies there is no right or wrong. If your DBA feels he wants so many policies then sure, you can configure them. You can however ask whether its really required to run a full AND an incremental. These days we have dedupe so doing an incremental to save on storage media is not required. You might want to do incrementals if its very big.

 

Then on the transaction log side it really just depends on how much the logs grow and how fine the RPO has to be. That would determine the schedule and frequency that you'd run these backups with.

 

No use running something every 15 minutes just because the DBA asks for it. There has to be data or you're just spinning your wheels ( I've seen customers ask for crazy frequencies on tiny databases)

Regards,

Riaan Badenhorst

You need an OpenVision to see the truth about Backups. Restores are a plus. But that's just Semantics ;)

ITs easy :)

SOLUTION