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
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