Read and excerpt from the book: Oracle 10g/11g data and database management utilities - haven't got a chance to try:
---------------------------------------------------------------------------------
As you have seen, Oracle 10g required the database to have a backup, and some manual preparation must be done prior to the clone process execution. Starting with 11g the DBA is leveraged from some tasks. With 11g, it is no longer required to have the target spfle created, this can be created on the fly, and there is no need to have a pre-existing backup from the source database. RMAN reads the original database files the same way it reads the datafles for a backup operation and transfers the on-the fly backup to the auxiliary database using an inter-instance network connection. RMAN utilizes an in-memory rman script to perform the cloning tasks at the auxiliary location. Some preparation at the destination site must be still performed prior to the clone process; the cloned environment must be already identifed with a password file, which holds the same password as that defned at the source site.
DUPLI CATE TARGET DATABASE
TO CLONEDB
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT ' /u01' , ' /u02 '
SET LOG_FI LE_NAME_CONVERT ' /u01' , ' /u02 '
SET DB_FILE_NAME_CONVERT ' /u01' , ' /u02 '
SET SGA_MAX_SIZE 512M
SET SGA_TARGET 400M;
No comments:
Post a Comment