01 Copy Wallet to PADSTOW

References

Oracle® Data Guard Concepts and Administration 11g Release 1 (11.1)

• Appendix C, "Data Type and DDL Support on a Logical Standby Database"
  • Support for Transparent Data Encryption (TDE)
  • Support for Tablespace Encryption

Overview

Because I had set up TDE in 11G OCM Create and Manage encrypted tablespaces, I had to copy the Wallet from BANKSTOWN to PADSTOW.

Support for Transparent Data Encryption (TDE) says that:

To translate encrypted redo records, SQL Apply must have access to an open wallet containing the Transparent Data Encryption keys. Therefore, you must copy the wallet containing the keys from the primary database to the standby database after it has been created

Procedure

Set Up Wallet on PADSTOW

Using the zip file sent from BANKSTOWN, a duplicate wallet is created on PADSTOW after I had zipped the contents on BANKSTOWN:

[oracle@padstow ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/wallet [oracle@padstow ~]$ mv wallet.zip $ORACLE_BASE/admin/$ORACLE_SID/wallet/ [oracle@padstow ~]$ cd $ORACLE_BASE/admin/$ORACLE_SID/wallet/ [oracle@padstow wallet]$ unzip wallet.zip Archive: wallet.zip extracting: cwallet.sso extracting: ewallet.p12 [oracle@padstow wallet]$ rm wallet.zip [oracle@padstow wallet]$ pwd /u01/app/oracle/admin/example1/wallet

Create System Default Location

Create the System Default Location directory to stop owm complainig:

[oracle@padstow wallet]$ sudo mkdir -p /etc/ORACLE/WALLETS/oracle [oracle@padstow wallet]$ sudo chown -R oracle:oinstall /etc/ORACLE

Verify Wallet Using OWM

I used owm to verify that I could open the new wallet.

02 Set Up FLASHBACK on BANKSTOWN