Sun Oct 9 16:19:48 2011
Errors in file /home/oracle/product/9.2.0/admin/dbjdsn/bdump/jdsn_dbw0_700600.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/home/oracle/oradata/dbjdsn/temp01.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Sun Oct 9 16:19:48 2011
Errors in file /home/oracle/product/9.2.0/admin/dbjdsn/bdump/jdsn_dbw0_700600.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/home/oracle/oradata/dbjdsn/temp01.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Sun Oct 9 16:19:48 2011
Errors in file /home/oracle/product/9.2.0/admin/dbjdsn/bdump/jdsn_dbw0_700600.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/home/oracle/oradata/dbjdsn/temp01.dbf'
Sun Oct 9 16:19:48 2011
File 201 not verified due to error ORA-01157
Sun Oct 9 16:19:48 2011
Errors in file /home/oracle/product/9.2.0/admin/dbjdsn/bdump/jdsn_lgwr_696498.trc:
ORA-00327: log 4 of thread 1, physical size 135167 less than needed 204800
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo08.log'
ORA-00327: log 4 of thread 1, physical size 158207 less than needed 204800
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo04.log'
Sun Oct 9 16:19:48 2011
Errors in file /home/oracle/product/9.2.0/admin/dbjdsn/bdump/jdsn_lgwr_696498.trc:
AIX Version 5
Copyright IBM Corporation, 1982, 2008.
login: root
root's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: Sun Oct 9 15:07:07 CDT 2011 on /dev/pts/2 from 10.0.1.97
Last login: Mon Oct 10 10:17:39 CDT 2011 on /dev/pts/2 from 10.0.1.97
# sqlplus /nolog
ksh: sqlplus: not found.
# su - oracle
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Oct 10 12:48:38 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> exit
$ export ORACLE_SID=jdsn
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Oct 10 12:48:49 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL>
SQL>
SQL> alter tablespace temp offline;
alter tablespace temp offline
*
ERROR at line 1:
ORA-01109: database not open
SQL> select file#,name from v$tempfile;
FILE#
----------
NAME
--------------------------------------------------------------------------------
1
/home/oracle/oradata/dbjdsn/temp01.dbf
SQL>
SQL> alter database tempfile '/home/oracle/oradata/dbjdsn/temp01.dbf' drop;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Oct 10 12:58:26 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount pfile=/home/oracle/product/9.2.0/dbs/initjdsn.ora
ORACLE instance started.
Total System Global Area 806846432 bytes
Fixed Size 741344 bytes
Variable Size 486539264 bytes
Database Buffers 318767104 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 0 104857600 2 NO UNUSED
0 23-SEP-11
2 1 59 104857600 2 NO INACTIVE
1098094171 24-SEP-11
3 1 60 104857600 2 NO INACTIVE
1098364225 25-SEP-11
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 0 104857600 2 NO CLEARING_CURRENT
1098634478 27-SEP-11
SQL>
SQL> alter database clear logfile group 1;
Database altered.
SQL> alter database clear logfile group 2;
Database altered.
SQL> c 2 3
SP2-0023: String not found.
SQL> c 2/3
SP2-0023: String not found.
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database clear logfile group 4;
alter database clear logfile group 4
*
ERROR at line 1:
ORA-00393: log 4 of thread 1 is needed for recovery of offline datafiles
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo04.log'
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo08.log'
ORA-01110: data file 14: '/home/oracle/oradata/dbjdsn/undo4.dbf'
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 0 104857600 2 NO UNUSED
0 23-SEP-11
2 1 0 104857600 2 NO UNUSED
1098094171 24-SEP-11
3 1 0 104857600 2 NO UNUSED
1098364225 25-SEP-11
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 0 104857600 2 NO CLEARING_CURRENT
1098634478 27-SEP-11
SQL> recovery databse until cancel;
SP2-0734: unknown command beginning "recovery d..." - rest of line ignored.
SQL> recover database until cancel;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 10 needs more recovery to be consistent
ORA-01110: data file 10: '/oradata/jddata.dbf'
SQL> recover datafile 10;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL>
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
alter system set "_allow_resetlogs_corruption"=true scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
SQL>
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount
ORA-00444: background process "PMON" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Oct 10 13:28:04 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORA-07446: sdnfy: bad value '/home/oracle/admin/dbjdsn/udump' for parameter user_dump_dest.
SQL> exit
Disconnected
$
$
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Mon Oct 10 13:28:16 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount pfile=/home/oracle/product/9.2.0/dbs/initjdsn.ora
ORACLE instance started.
Total System Global Area 806846432 bytes
Fixed Size 741344 bytes
Variable Size 486539264 bytes
Database Buffers 318767104 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL> create spfile from pfile;
File created.
SQL>
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 806846432 bytes
Fixed Size 741344 bytes
Variable Size 486539264 bytes
Database Buffers 318767104 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 806846432 bytes
Fixed Size 741344 bytes
Variable Size 486539264 bytes
Database Buffers 318767104 bytes
Redo Buffers 798720 bytes
Database mounted.
SQL>
SQL> recover database until cancel;
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 10 needs more recovery to be consistent
ORA-01110: data file 10: '/oradata/jddata.dbf'
SQL> recover datafile 10;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1098704043 generated at 09/27/2011 10:50:23 needed for thread
1
ORA-00289: suggestion : /home/oracle/product/9.2.0/dbs/arch1_61.dbf
ORA-00280: change 1098704043 for thread 1 is in sequence #61
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 10 needs more recovery to be consistent
ORA-01110: data file 10: '/oradata/jddata.dbf'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
Database altered.
SQL> alter database add logfile group 5 '/home/oracle/oradata/dbjdsn/redo5.log' size 100m;
Database altered.
SQL> alter database add logfile group 6 '/home/oracle/oradata/dbjdsn/redo6.log' size 100m;
Database altered.
SQL> alter database add logfile group 7 '/home/oracle/oradata/dbjdsn/redo7.log' size 100m;
Database altered.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01623: log 4 is current log for thread 1 - cannot drop
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo04.log'
ORA-00312: online log 4 thread 1: '/home/oracle/oradata/dbjdsn/redo08.log'
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter sytem switch logfile;
alter sytem switch logfile
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter system switch logfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 1 104857600 2 NO INACTIVE
1098704044 10-OCT-11
5 1 2 104857600 1 NO INACTIVE
1098704526 10-OCT-11
6 1 3 104857600 1 NO CURRENT
1098704596 10-OCT-11
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
7 1 0 104857600 1 YES UNUSED
0
SQL> alter database drop logfile group 4;
Database altered.