Friday 3 July 2020

DUPLICATE DATABASE from backup location 11.2 and later

alter system set DB_FILE_NAME_CONVERT='/u01/oradata/psgprod/PSGPROD/datafile/','/u02/oradata/psgtest/' scope=spfile;
alter system set LOG_FILE_NAME_CONVERT='/u01/oradata/psgprod/PSGPROD/datafile/','/u02/oradata/psgtest/' scope=spfile;

run
{
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux4 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux11 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux12 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux13 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux14 DEVICE TYPE DISK;
DUPLICATE DATABASE TO psgtest
 BACKUP LOCATION '/u02/backup';
}




Number of Visitors