Thursday, December 9, 2010

rman duplicate from active database -PARAMETER_VALUE_CONVERT

incorrect/incomplete PARAMETER_VALUE_CONVERT can crash your target database . my target database crashed as i missed
it from rman duplicate while just trying to create the database with init.ora having only db_name entry

my controlfile/datafile/online log file in asm so i had to do as below

DUPLICATE TARGET DATABASE
TO t11gdact
FROM ACTIVE DATABASE
DB_FILE_NAME_CONVERT '+DATA/t11gdb/','+DATA/t11gdact/'
SPFILE
PARAMETER_VALUE_CONVERT '/u03/arch/t11gdb/','/u03/arch/t11gdact/','+DATA/t11gdb/','+DATA/t11gdact/'
SET SGA_MAX_SIZE '300M'
SET SGA_TARGET '250M'
SET LOG_FILE_NAME_CONVERT '+DATA/t11gdb/',
'+DATA/t11gdact/';

No comments: