RMAN backup queries

Are there any useful queries that would provide some assurance on oracle database backups? This gives some information but I wondered if there was a query that would list say all recent backups from the last month?:

http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmquery.htm#450996 

I also wondered if  theres any query to list where the backup file is being written to? Any pointers in that area?
LVL 4
pma111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
> would list say all recent backups from the last month?:

LIST BACKUPS COMPLETED BETWEEN '01-AUG-2013' AND '01-SEP-2013';
or more generically
LIST BACKUPS COMPLETED BETWEEN TRUNC(TRUNC(SYSDATE, 'MM') -1 , 'MM') AND TRUNC(SYSDATE, 'MM');

in the backup set, you can see where the backup was written to.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Not being an oracle admin myself (doing this as a risk assesment) when you say:

>in the backup set, you can see where the backup was written to.

is there a query to see where it was written to?

Also in that link above it states the "Reporting on Objects Needing a Backup" - would that be worth running? What kind of objects would these be?
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the output of the LIST shows the backup sets, see :
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
Piece Name: /oracle/work/RDBMS/backupset/2003_11_04/o1_mf_nnndf_TAG20031104T195949_ztjxfvgz_.bkp 

Open in new window


>Also in that link above it states the "Reporting on Objects Needing a Backup" - would that be worth running? What kind of objects would these be?
"needing a backup" means that all object that have not been backed up since the expiry of previous backup (if any), or in case there was never a backup yet.

object refers to all files that RMAN can backup, which is mainly the database files, but also the config file (pfile / spfile)
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

pma111Author Commented:
Thanks.

Is the query just

REPORT NEED BACKUP
0
pma111Author Commented:
Also is it definately

LIST BACKUPS

or LIST BACKUP (minus the S)
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sorry, that was a typo.
it's LIST BACKUP   (or LIST BACKUPSET)
0
pma111Author Commented:
Last one:

Is the query just

REPORT NEED BACKUP (for the missing backups)
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, it's as short as that
0
pma111Author Commented:
be useful to get your input into this question too:

http://www.experts-exchange.com/Database/Oracle/Q_28250209.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.