cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN Backedup file

Mitesh_Nandu
Level 4
Partner Accredited

Hi,

We have done oracle rman configuration, also tested the backup using rman script.

want to know, how to check which files are backedup & from where i can see?

NBU 7.6

Master Server - Windows 2008

Agent - AIX

1 ACCEPTED SOLUTION

Accepted Solutions

Amol_Nair
Level 6
Employee

You can run the below command and get the list of backup pieces available in NetBackup for the RMAN backup taken

bplist -C <client_name> -S <master_name> -t 4 -l -R /

 

The name of the client and the master server must the same as it was used in the policy configuration. If the policy has the name as FQDN and you run the above command with the short name you would get a 227 error stating that no entity found.

 

If you have taken Proxy backups (default when you use OIP and deduplication STU) then the above command will list the .dbf files that were backed up. Else the command will list only backup pieces.

 

Once you have the backup piece name you need to go to RMAN and run

RMAN> list backup;

OR

RMAN> list backup summary;

This will tell you which files are associated with which backup piece.

View solution in original post

5 REPLIES 5

Amol_Nair
Level 6
Employee

You can run the below command and get the list of backup pieces available in NetBackup for the RMAN backup taken

bplist -C <client_name> -S <master_name> -t 4 -l -R /

 

The name of the client and the master server must the same as it was used in the policy configuration. If the policy has the name as FQDN and you run the above command with the short name you would get a 227 error stating that no entity found.

 

If you have taken Proxy backups (default when you use OIP and deduplication STU) then the above command will list the .dbf files that were backed up. Else the command will list only backup pieces.

 

Once you have the backup piece name you need to go to RMAN and run

RMAN> list backup;

OR

RMAN> list backup summary;

This will tell you which files are associated with which backup piece.

Mitesh_Nandu
Level 4
Partner Accredited

Hi Amol,

Thanks for the reply.

bplist command we have run from master server or from client system.

And it will show last backedup files or how it is?

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

The rman catalog is the place to query backed up databases.

If you have logging enabled, the rman output files and NBU dbclient logs should contain the names of dbs.

When Oracle db's are backed up using rman, the actual db names are not recorded, but names that are hardcoded in the rman scripts. For example:
FORMAT 'bk_u%%u_s%%s_p%%p_t%%t'   (for database)
FORMAT 'arch-s%%s-p%%p-t%%t'  (for Archive log)

So, when listing backups from within NBU using bplist, it will display names similar to the format string in the script.

See if this posts helps you: https://www-secure.symantec.com/connect/forums/netbackup-rman-database-restores
 

Amol_Nair
Level 6
Employee

The bplist command should run successfully from both the master server and the client machine.

The bplist command has switches that you can use to specify the date range and it will list all the backups taken during that particular date range.

I guess by default it shows the last 1 month backups. But as mentioned this command will list the backup-pieces and dbf files if you have taken proxy backups.
 

rk1074
Level 6
Partner

I often use bpflist  from master to have more detail output

bpflist -client <c> -d <date> -L|U