Hi,
Recover the instance. if you can't, you will need to restore backup agai... or your initial backup was invalid.
| | | ---------------Original Message---------------
From: João Miguel Dimas
Sent: Thursday, February 24, 2011 2:09 PM
Subject: SAPInst error - Backup/Restore database
Hello gurus,
I am facing an error during a sap copy. I used the oracle specific procedure, this is, the generatiing of the control file structure (control.sql) and I already copied all datafiles from source server to the new server (destination server) then after all that specific tasks then I proceed with SAPinst. The database is an Oracle 11.2.0.1 on Linux X86_64.
Now I´m facing with an error in phase Backup/Restore database.
I checked sapinst.log:
...
INFO 2011-02-24 15:31:36.217
Creating file /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTR AL/AS-ABAP/run_control.sql.
ERROR 2011-02-24 15:32:29.532
CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Control file created.
Database altered.
Tablespace altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Database mounted.
Database altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.
ERROR 2011-02-24 15:32:29.536
MUT-03025 Caught ESAPinstException in module call: .
ERROR 2011-02-24 15:32:30.717
FCO-00011 The step RunControlScript with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_Sys tem|ind|ind|ind|ind|onehost|0|NW_CreateDBandLoad|ind| ind|ind|ind|createdbandload|0|NW_CreateDB|ind|ind| ind|ind|createdb|0|NW_OraDBCheck|ind|ind|ind|ind|0 |0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|in d|ind|ind|ind|obr|0|NW_OraOBR|ind|ind|ind|ind|5|0|R unControlScript was executed with status ERROR ( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Control file created.
Database altered.
Tablespace altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Database mounted.
Database altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.).
INFO 2011-02-24 15:32:32.190
Creating file /tmp/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTR AL/AS-ABAP/__instana_tmp.xml
I also checked, and I will post here too, the ora_sql_results.log.
I also checked ora_sql_results.log:
2011-02-24, 15:31:36 SAPINST ORACLE start logging for
CONNECT / AS SYSDBA
SHUTDOWN ABORT
@CONTROL.SQL
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
SHUTDOWN IMMEDIATE
EXIT
exit;
Output of SQL executing program:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 24 15:31:37 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Control file created.
Database altered.
Tablespace altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2321686528 bytes
Fixed Size 2215464 bytes
Variable Size 1174405592 bytes
Database Buffers 1140850688 bytes
Redo Buffers 4214784 bytes
Database mounted.
Database altered.
Database altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SAPINST: End of output of SQL executing program /oracle/W01/112_64/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2011-02-24, 15:32:29 SAPINST ORACLE stop logging
Can you help me please?
Thank you,
Joao Dimas - Portugal |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Snowy
SAP Basis Enthusiast
Contributed 1,000 posts in a group to earn a Gold Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
