on 11-12-2015 10:14 AM
Hello all,
I would like to ask, who has experiance with reorg tablespace with errors:
oracle create a lot of core dumps and after that FS /oracle/X44 is full and reorg failed.
oracle trace file:
Errors in file /oracle/X44/saptrace/diag/rdbms/x44/X44/trace/X44_ora_1568.trc (incident=414377):
ORA-07445: exception encountered: core dump [pevm_MOVC_i()+737] [SIGSEGV] [ADDR:0xA] [PC:0x400000000642A2C1] [Invalid Permissions for object] []
brtools errors:
BR0301E SQL error -3113 in thread 3 at location tab_onl_reorg-39, SQL statement:
'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPX44"', ORIG_TABLE => '"/ASU/CONTENTNV"', INT_TABLE => '"/ASU/CONTENTNV#$"', OPTIONS_FLAG =>
DBMS_REDEFINITION.CONS_USE_PK); END;'
ORA-03113: end-of-file on communication channel
Process ID: 1572
Session ID: 282 Serial number: 33053
BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59
BR0301E SQL error -9945 in thread 3 at location thr_db_connect-4, SQL statement:
'CONNECT system/******* IN SYSDBA MODE'
ORA-09945: Unable to initialize the audit trail file
HPUX-ia64 Error: 28: No space left on device
BR0310E Connect to database instance X44 failed
BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59
BR1984I Aborting reorganization of table SAPX44./ASU/CONTENTNV ...
BR0280I BRSPACE thread 3 time stamp: 2015-11-11 14:55:59
My system:
OS: HP-UX B.11.23 ia64
DB: Oracle 11.2.0.3.0
Sap: BW system, kernel 721_REL, 64 BIT, non-unicode
brtools version: use 7.20 (42) and 7.40 (17), but same errors occure.
I've tried find some information from oracle.support but nothing.
Thanks for any replay
Jan Urban
Hi Urban,
As per the log it show there is no freespace left on the filesystem. could you check the filesystem "oracle/SID/orrach, sapbackup directory and the audit log directory and increase the same if necessary.
You can perform the following types of reorganization:
· Reorganize tables online
· Check tables for reorganization
· Clean up tables after aborted reorganization
· Convert LONG and LONG RAW fields to CLOB or BLOB online (Oracle 10g or higher)
· Stop reorganization (command-line mode only)
· Suspend reorganization (command-line mode only)
· Resume reorganization (command-line mode only)
for details follow the link.
Reorganizing Tables with BR*Tools - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library
Reorganization - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library
Thanks,
BM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.