.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RMAN V8.1.7 to V10.2.0

RMAN V8.1.7 to V10.2.0

2005-11-23       - By sol beach

I am trying to clone a V8.1.7 DB to a different system running V10.2
Below is the output from RMAN:
=================================================
RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel aux1: starting datafile backupset restore
RMAN-08502: set_count=13 set_stamp=533064604 creation_time=01-AUG-04
RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to /u01/oradata/dbx1/system01.dbf
RMAN-08523: restoring datafile 00002 to /u01/oradata/dbx1/rbs01.dbf
RMAN-08523: restoring datafile 00004 to /u01/oradata/dbx1/tools01.dbf
RMAN-08523: restoring datafile 00007 to
/u02/oradata/dbx1/security_data01.dbf
RMAN-10030: RPC call appears to have failed to start on channel aux1
RMAN-10036: RPC call ok on channel aux1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command:
IRESTORE
RMAN-07004: unhandled exception during command execution on channel aux1
RMAN-10032: unhandled exception during execution of job step 1: ORA-04062 (See ORA-04062.ora-code.com):
signature of package "SYS.X$DBMS_BACKUP_RESTORE" has been changed
ORA-06512 (See ORA-06512.ora-code.com): at line 144
RMAN-10035: exception raised in RPC: ORA-04062 (See ORA-04062.ora-code.com): signature of package "
SYS.X$DBMS_BACKUP_RESTORE" has been changed
RMAN-10031: ORA-4062 (See ORA-4062.ora-code.com) occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

Recovery Manager complete.
==================================================================
I'm using the following command file.
connect auxiliary sys/password@(protected)
run {
  allocate auxiliary channel aux1 type disk;
  duplicate target database to dbx1
  nofilenamecheck;
}
exit
=================================================
What am I doing wrong & what needs to be changed to allow the cloned DB to
actually get created?
FWIW - I never see any new datafiles on the 10g system for this instance.
I am keeping the SID the same & the directory structure is identical.
Any assistance would be greatly appreciate

TIA!

I am trying to clone a V8.1.7 DB to a different system running V10.2<br>
Below is the output from RMAN:<br>
=================================================<br>
RMAN-03022: compiling command: restore<br>
<br>
RMAN-03022: compiling command: IRESTORE<br>
RMAN-03023: executing command: IRESTORE<br>
RMAN-08016: channel aux1: starting datafile backupset restore<br>
RMAN-08502: set_count=13 set_stamp=533064604 creation_time=01-AUG-04<br>
RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set<br>
RMAN-08523: restoring datafile 00001 to /u01/oradata/dbx1/system01.dbf<br>
RMAN-08523: restoring datafile 00002 to /u01/oradata/dbx1/rbs01.dbf<br>
RMAN-08523: restoring datafile 00004 to /u01/oradata/dbx1/tools01.dbf<br>
RMAN-08523: restoring datafile 00007 to /u02/oradata/dbx1/security_data01.dbf
<br>
RMAN-10030: RPC call appears to have failed to start on channel aux1<br>
RMAN-10036: RPC call ok on channel aux1<br>
RMAN-00571: ===========================================================<br>
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br>
RMAN-00571: ===========================================================<br>
RMAN-03002: failure during compilation of command<br>
RMAN-03013: command type: Duplicate Db<br>
RMAN-03015: error occurred in stored script Memory Script<br>
RMAN-03002: failure during compilation of command<br>
RMAN-03013: command type: restore<br>
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
<br>
RMAN-07004: unhandled exception during command execution on channel aux1<br>
RMAN-10032: unhandled exception during execution of job step 1:
ORA-04062 (See ORA-04062.ora-code.com): signature of package &quot;SYS.X$DBMS_BACKUP_RESTORE&quot; has been
changed<br>
ORA-06512 (See ORA-06512.ora-code.com): at line 144<br>
RMAN-10035: exception raised in RPC: ORA-04062 (See ORA-04062.ora-code.com): signature of package &quot;SYS
.X$DBMS_BACKUP_RESTORE&quot; has been changed<br>
RMAN-10031: ORA-4062 (See ORA-4062.ora-code.com) occurred during call to DBMS_BACKUP_RESTORE
.RESTOREBACKUPPIECE<br>
<br>
Recovery Manager complete.<br>
==================================================================<br>
I'm using the following command file.<br>
connect auxiliary sys/password@(protected) <br>
run {<br>
&nbsp;&nbsp; allocate auxiliary channel aux1 type disk;<br>
&nbsp;&nbsp; duplicate target database to dbx1<br>
&nbsp;&nbsp; nofilenamecheck;<br>
}<br>
exit<br>
=================================================<br>
What am I doing wrong &amp; what needs to be changed to allow the cloned DB to
actually get created?<br>
FWIW - I never see any new datafiles on the 10g system for this instance.<br>
I am keeping the SID the same &amp; the directory structure is identical.<br>
Any assistance would be greatly appreciate<br>
<br>
TIA!<br>