asked on

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?

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Pau Lo

ASKER

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?

Guy Hengel [angelIII / a3]

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)

Pau Lo

ASKER

Thanks.

Is the query just

REPORT NEED BACKUP

Pau Lo

ASKER

Also is it definately