First I think was some error with Database Backup To Cloud, when testing. Then I realized it was a simple mistake by myself.
Let me show you. First trying to restore datafile:
[oracle@mydbsrvr archivelogs]$ rman target / RMAN> restore datafile 6; Starting restore at 03-MAY-2016 20:00:30 using channel ORA_SBT_TAPE_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=178 device type=DISK channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 05/03/2016 20:00:34 ORA-19870: error while restoring backup piece 0sr4mdun_1_1 ORA-19913: unable to decrypt backup ORA-28365: wallet is not open
Ok, it might happen because I forgot to set encryption password:
RMAN> SET ENCRYPTION ON IDENTIFIED BY "matheusdba" only; executing command: SET encryption RMAN> restore datafile 6; Starting restore at 03-MAY-2016 20:00:30 using channel ORA_SBT_TAPE_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=178 device type=DISK channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 05/03/2016 20:00:34 ORA-19870: error while restoring backup piece 0sr4mdun_1_1 ORA-19913: unable to decrypt backup ORA-28365: wallet is not open
It hapen again?
This point I suspect some kind of bug… But it was my mistake and is not related to Cloud, but to Encryption use. To undestand:
For Backup: Use ENCRYPTION
For Restore/Recover: Use DECRYPTION
Obviously, but take me a minute to realize…
Setting decryption, and problem solved:
RMAN> set DECRYPTION identified by "matheusdba"; executing command: SET decryption RMAN> restore datafile 6; Starting restore at 03-MAY-2016 20:00:58 using channel ORA_SBT_TAPE_1 using channel ORA_DISK_1 channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00006 to /db/u1001/test/cloud_test/test_restore.dbf channel ORA_SBT_TAPE_1: reading from backup piece 0sr4mdun_1_1 channel ORA_SBT_TAPE_1: piece handle=0sr4mdun_1_1 tag=TAG20160503T193239 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:03 Finished restore at 03-MAY-2016 20:01:02
See ya!
Matheus.
Great! Thanks Matheus.