Monday, October 14, 2019

Restore/Clone database from RMAN Backup with wallet

Database restore test for <database name> : 


1.            Copy wallet files to wallet location and test if wallet is opening. 
2.            Set RMAN configuration parameters. 

RMAN> set dbid=139425645454
RMAN> set decryption identified by 'password';
RMAN> CONFIGURE ENCRYPTION ALGORITHM 'AES128';


run {
        set until sequence 520477 thread 1;
                                set until sequence 498092 thread 2;
        duplicate target database to <target db name>
        nofilenamecheck;




alter system set db_file_name_convert='+DATA/test1/DATAFILE/','+DATA/test2/DATAFILE/';
alter system set log_file_name_convert='+DATA/test1/DATAFILE/','+DATA/test2/DATAFILE/';


run {
                set until logseq 515519;
                duplicate target database to test2
                nofilenamecheck;
}

RMAN> 
set decryption identified by 'password';
set ENCRYPTION identified by 'password';

executing command: SET decryption

RMAN> show encryption algorithm;

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password";



$ ./rman catalog rmancat/passwd auxiliary sys/test@clone_db

No comments:

Post a Comment