RMAN restores 32-bit database to 64-bit instance error handling, rman32-bit

RMAN restores 32-bit database to 64-bit instance error handling, rman32-bit

Restore the ORACLE 10g 32bit database to the database instance of ORACLE 10g 64bit on the test machine. After restoring and restoring the database, use open resetlogs to open the database, ORA-12012 and ORA-06553 errors found in the warning log:

Sun Mar  8 13:31:08 2015

LOGSTDBY: Validation complete

Starting control autobackup

Control autobackup written to DISK device

        handle '/u03/flash_recovery_area/backup/backupsets/ora_cfc-2179993557-20150308-00'

Completed: alter database open resetlogs

Sun Mar  8 13:31:09 2015

Errors in file /u01/app/oracle/admin/epps/bdump/epps_j000_14891.trc:

ORA-12012: error on auto execute of job 41

ORA-06553: PLS-801: internal error [56319]

Sun Mar  8 13:31:09 2015

Errors in file /u01/app/oracle/admin/epps/bdump/epps_j001_14893.trc:

ORA-12012: error on auto execute of job 21

ORA-06553: PLS-801: internal error [56319]

Sun Mar  8 13:31:09 2015

Errors in file /u01/app/oracle/admin/epps/bdump/epps_j006_14903.trc:

ORA-12012: error on auto execute of job 42567

ORA-06553: PLS-ORA-06553: PLS-801: internal error [56319]

This error occurs because the wordsize of the 32bit and 64bit databases is different. You need to perform the following steps to complete the wordsize conversion. For details, refer to How to Convert a 32-bit Database to 64-bit Database on Linux? (Documentation ID 341880.1)

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area 3590324224 bytes

Fixed Size                  2084296 bytes

Variable Size            1607467576 bytes

Database Buffers         1966080000 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

SQL> @?/rdbms/admin/utlip.sql

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 3590324224 bytes

Fixed Size                  2084296 bytes

Variable Size            1607467576 bytes

Database Buffers         1966080000 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

SQL>  @?/rdbms/admin/utlrp.sql

When executing the script, the following error is reported. The official explanation is Note: if you are changing wordsize for Oracle release10.1.x/10.2.x/11.1/11.2 32-Bit to 64-bit with OLAP enabled for DB then you may likely to see the error

Fri Jan 23 17:24:05 2015

Errors in file/u01/app/oracle/admin/epps/bdump/epps_smon_9027.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4194], [18], [13], [], [], [], [], [], []

Fri Jan 23 17:25:55 2015

Error 0 in kwqmnpartition (), aborting txn

Fri Jan 23 17:25:55 2015

Errors in file/u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:

ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], [], []

ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [], []

ORA-06553: PLS-801: internal error [56319]

Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30

Doing block recovery for file 122 block 939

No block recovery was needed

Fri Jan 23 17:25:56 2015

Errors in file/u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:

ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], [], []

ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [], []

ORA-06553: PLS-801: internal error [56319]

ORA-600 encountered when generating server alert SMG-3503

Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30

Doing block recovery for file 122 block 939

No block recovery was needed

Fri Jan 23 17:25:57 2015

Errors in file/u01/app/oracle/admin/epps/bdump/epps_mmon_9113.trc:

ORA-00600: internal error code, arguments: [4194], [38], [38], [], [], [], [], [], []

Flush retried for xcb 0x12c114e20, pmd 0x12cca2d30

Doing block recovery for file 122 block 939

No block recovery was needed

References:

Http://blog.itpub.net/23135684/viewspace-757172

Https://support.oracle.com/epmos/faces/SearchDocDisplay? _ Adf. ctrl-state = wo3y0s6qj_9 & _ afrLoop = 209150676970938 # GOAL