rman catalog cat_user
RMAN> run
2> {
3> set newname for datafile 1 to 'd:\ORACLE10\REDIKQA\REDIKQA\SYSTEM01.DBF';
4> set newname for datafile 2 to 'd:\ORACLE10\REDIKQA\REDIKQA\UNDOTBS01.DBF';
5> set newname for datafile 3 to 'd:\ORACLE10\REDIKQA\REDIKQA\SYSAUX01.DBF';
6> set newname for datafile 4 to 'd:\ORACLE10\REDIKQA\REDIKQA\USERS01.DBF';
7> set newname for tempfile 1 to 'd:\ORACLE10\REDIKQA\REDIKQA\TEMP01.dbf';
8> duplicate target database to redikqa;
9> }
In case this is environment that will be refreshing often, to make it simpler, you can do this like this:
1. In init.ora of REDIKQA added two parameters:
DB_FILE_NAME_CONVERT = 'path_on_redik','
LOG_FILE_NAME_CONVERT =
2.Run:
duplicate target database to redikqa;
No comments:
Post a Comment