Hi all,
Good Morning. We are in 18C db on win 2016R2. I am testing db restore where a tablespce is encrypted. Before i restore db, i made sure the encryption wallet is open. I backup the database is catalog and once the backup finish, i made sure that encrypted TS backup is there too. To test , i drop the TS and then tried to restore with following commnd from media:
C:\Windows\system32>RMAN TARGET / CATALOG rcvcat/xxxxxxx@CATDB
RMAN> run {
2> allocate channel CH1 type 'SBT_TAPE'
3> send 'NSR_ENV=(NSR_CLIENT=xxxxxxx-xx.xx.xx,NSR_SERVER=xxxxx.xxxxx.u,NSR_DATA_VOLUME_POOL=xxxxxxxxxxx)';
4> startup mount;
5> restore database;
6> recover database until SCN xxxxxxxxx;
7> alter database open;
8> RELEASE CHANNEL CH1;
9>
I am getting below error
Starting recover at 02/03/20 10:39:35
released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/03/2020 10:39:35
RMAN-06094: datafile 6 must be restored
TS 6 is the encrypted TS. I would appreciate if someone can help me out on this. Thanks.