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 _.____.__ |