Solved

query control file backup piece

  • 20 December 2022
  • 3 replies
  • 103 views

Badge +6

Hello all,

 

Our DBAs are testing a disaster scenario where only Commvault would be available for restore and my question to you is if there is a query i can make to Commvault to give me the last control file backup piece available of a db.

I know you can check this on the job details, but is there a way i can see this from a command line?

Thank you

 

Kind regards,

João Amaral

icon

Best answer by Gowri Shankar 20 December 2022, 17:40

View original

3 replies

Userlevel 4
Badge +12

@jmiamaral  

Dont think its feasible because there could be multiple instance with the same name but running on different clients

Regards,

Gowri Shankar

 

 

 

Badge +6

@Gowri Shankar 

Thank you for your fast feedback, i got it to work as i wanted. One more question, is there a way to know the client name from only the instance name?

 

Kind regards,

João Amaral

Userlevel 4
Badge +12

Hi @jmiamaral 

 

You may use getbackuplist utility 

https://documentation.commvault.com/2022e/expert/20356_viewing_oracle_rman_backup_pieces.html

 

 

Regards,

Gowri Shankar

Reply