0

I want to back up my encrypted DB by TDE.

So, I run exp command. but I have an errors. because of encrypted table spaces.

is there any way to back up my DB encrypted by TDE??

I don't have a idea.

plz help me.

Double J
  • 37
  • 1
  • 2
  • 11
  • 1
    You can get start from Oracle documentation. http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmbackp.htm#BRADV72450 – atokpas Mar 27 '16 at 10:48
  • first of all you have to check whether your wallet was created with auto-login option. If yes then everything should work out of the box. If not you have to unlock TDE tbs. – ibre5041 Mar 27 '16 at 11:23

1 Answers1

1

Since you mentioned you have encrypted DB, you need to have Oracle Wallet open, if we assume db instance is up, is already open.

I do not think you can/should use "exp" utility. It's replaced by more powerful "expdp" and "impdp" utilities. These two utilities will allow you to successful backup/restore encrypted data.

Please look into Oracle Utilities guide for further command line reference. Generally for expdp you need to use ENCRYPTION and ENCRYPTION_PASSWORD and you may or may not use Oracle Wallet.

My preffered way though, to use RMAN.

Dhimant Patel
  • 23
  • 1
  • 5
  • You mean that if I use expdp utility with ENCRYPTION_PASSWORD option, then I can backup encrypted data? is it right? – Double J Mar 27 '16 at 13:38