I would like to know if it is possible given a certain backup made with RMAN in Oracle 12c is encrypted without having to restore said backup, is there any or some queries that verify if an RMAN backup is encrypted or not?

To launch the backup I use the option SET ENCRYPTION ON IDENTIFIED BY qazwsx ONLY;

Thank you very much.

  • Are you using an RMAN Catalog server? Sep 26, 2018 at 19:14

1 Answer 1


Sure, you can query V$BACKUP_PIECE in target database or RC_BACKUP_PIECE in RMAN catalog:

SQL> select encrypted, tag from v$backup_piece;

--- --------------------------------
NO  TAG20180926T211157
NO  TAG20180926T211159
YES TAG20180926T211224
YES TAG20180926T211227

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.