I have a test instance just upgraded to 10.2.0.4. Production is at 10.2.0.3 and will not be upgraded for a month whie users test changes. I need to clone fresh data from production to test. Using RMAN I get the error message "PLS-00302: component 'LOGTERMINAL_OBJ' must be declared" and it seems that this is becuase RMAN detects the verison incompatiblity. Has anyone successfully duplicated between versions using RMAN?
I believe I can use our UserManaged backup to clone if necessary. I copy all datafiles to test, then rebuild test control file, but stop before opening database and resetting logs. Then run DBUA to bring the clone up to 10.2.0.4. I will be attempting this but really would rather use RMAN if possible.
I am using the control file not a catalog database. I copy the 10.2.0.3 backups to the 10.2.0.4 test server in the same directory. I have the convert parameters set up in the test pfile. Then I run the duplicate db script on the linux server after starting the test database in "nomount"mode:
connect target sys/password@prod
connect auxiliary sys/password@test
DUPLICATE TARGET DATABASE TO test
PFILE = /u01/app/oracle/product/10.2.0/dbs/inittest.ora
LOGFILE GROUP 1 ('/u02/oradata/test/redo01.log') SIZE 102400K,
GROUP 2 ('/u02/oradata/test/redo02.log') SIZE 102400K,
GROUP 3 ('/u02/oradata/test/redo03.log') SIZE 102400K;
This works fine across the servers when the versions match.
Am I missing something here?
Edited by: Ozark DBA on Jul 29, 2009 8:52 AM
Edited by: Ozark DBA on Jul 29, 2009 8:53 AM