What is the mandatory step for a media recovery of RAC 12cR1 database with encrypted tablespaces?

What is the mandatory step for a media recovery of RAC 12cR1 database with encrypted
tablespaces?

What is the mandatory step for a media recovery of RAC 12cR1 database with encrypted
tablespaces?

A.
You must close the Oracle Wallet after database mount and before opening the database.

B.
You must open the Oracle Wallet after database nomount and before opening the database.

C.
You must relocate the sqlnet.ora file and remove it from $ORACLE_HOME/network/admin.

D.
You must open the Oracle Wallet after database mount and before opening database.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Prabhat

Prabhat

>>> D >>>

Restrictions

The following are restrictions for encrypted tablespaces:

You cannot encrypt an existing tablespace with an ALTER TABLESPACE statement. However, you can use Data Pump or SQL statements such as CREATE TABLE AS SELECT or ALTER TABLE MOVE to move existing table data into an encrypted tablespace.

Encrypted tablespaces are subject to restrictions when transporting to another database.

When recovering a database with encrypted tablespaces (for example after a SHUTDOWN ABORT or a catastrophic error that brings down the database instance), you must open the keystore after database mount and before database open, so the recovery process can decrypt data blocks and redo.

https://docs.oracle.com/database/121/ADMIN/tspaces.htm#ADMIN011