[oracle@jszg ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 24 12:46:58 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/NINVOICE/system01.dbf'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 6330749 generated at 09/09/2013 11:32:46 needed for thread 1
ORA-00289: suggestion : /u01/oracle/product/9.2.0/dbs/arch1_29.dbf
ORA-00280: change 6330749 for thread 1 is in sequence #29
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u01/oracle/product/9.2.0/dbs/arch1_29.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/u01/oracle/product/9.2.0/dbs/arch1_29.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oracle/oradata/NINVOICE/system01.dbf'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 35 104857600 1 NO INACTIVE
8425221 16-SEP-13
2 1 36 104857600 1 NO INACTIVE
8767741 17-SEP-13
3 1 37 104857600 1 NO CURRENT
9112821 18-SEP-13
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> create pfile='/tmp/pfile' from spfile;
File created.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@jszg ~]$ vi /tmp/pfile
*._allow_resetlogs_corruption=TRUE
*.aq_tm_processes=1
*.background_dump_dest='/u01/oracle//admin/NINVOICE/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/oracle/oradata/NINVOICE/control01.ctl','/u01/oracle/oradata/NINVOICE/control02.ctl','/u01/oracle/oradata/NINVOICE/control03.ctl'
*.core_dump_dest='/u01/oracle//admin/NINVOICE/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='NINVOICE'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='NINVOICE'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
[oracle@jszg ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 24 13:14:35 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/tmp/pfile' mount;
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
[root@jszg bdump]# vi alert_NINVOICE.log
Thu Aug 22 13:20:25 2013
alter database rename global_name to NINVOICE
Completed: alter database rename global_name to NINVOICE
Thu Aug 22 13:20:25 2013
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/NINVOICE/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/or
Thu Aug 22 13:20:25 2013
alter database character set INTERNAL_CONVERT AL32UTF8
Updating character set in controlfile to AL32UTF8
SYS.SNAP$ (REL_QUERY) - CLOB representation altered
SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered
XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
ODM.ODM_PMML_DTD (DTD) - CLOB representation altered
OE.WAREHOUSES (SYS_NC00003$) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation altered
PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation altered
PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation altered
PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation altered
Completed: alter database character set INTERNAL_CONVERT AL32
Thu Aug 22 13:20:35 2013
alter database national character set INTERNAL_CONVERT AL16UTF16
alter database open resetlogs
RESETLOGS is being done without consistancy checks. This may result
in a corrupted database. The database should be recreated.
RESETLOGS after incomplete recovery UNTIL CHANGE 6330749
Resetting resetlogs activation ID 0 (0x0)
Tue Sep 24 13:20:05 2013
Assigning activation ID 3433913633 (0xccad5d21)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/NINVOICE/redo03.log
Successful open of redo thread 1.
Tue Sep 24 13:20:05 2013
SMON: enabling cache recovery
Tue Sep 24 13:20:05 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30056.trc:
ORA-00600: internal error code, arguments: [2662], [0], [6330754], [0], [9196449], [8388617], [], []
Tue Sep 24 13:20:10 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30056.trc:
ORA-00600: internal error code, arguments: [2662], [0], [6330754], [0], [9196449], [8388617], [], []
Tue Sep 24 13:20:10 2013
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 30056
ORA-1092 signalled during: alter database open resetlogs...
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter session set events '10015 trace name ADJUST_SCN level 1';
Session altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
[root@jszg bdump]# vi alert_NINVOICE.log
Tue Sep 24 13:58:22 2013
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo02.log
Tue Sep 24 13:58:22 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30240.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 30240
ORA-1092 signalled during: alter database open...
Tue Sep 24 14:00:49 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
:$
Successfully onlined Undo Tablespace 1.
Tue Sep 24 14:09:53 2013
SMON: enabling tx recovery
Tue Sep 24 14:09:54 2013
Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.trc:
ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []
Tue Sep 24 14:09:54 2013
Database Characterset is AL32UTF8
Tue Sep 24 14:09:54 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:
ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []
Tue Sep 24 14:09:53 2013
SMON: enabling cache recovery
Tue Sep 24 14:09:53 2013
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 24 14:09:53 2013
SMON: enabling tx recovery
Tue Sep 24 14:09:54 2013
Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.trc:
ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []
Tue Sep 24 14:09:54 2013
Database Characterset is AL32UTF8
Tue Sep 24 14:09:54 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:
ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []
Tue Sep 24 14:10:09 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log
Tue Sep 24 14:10:10 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log
Tue Sep 24 14:10:10 2013
Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.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: [4193], [221], [224], [], [], [], [], []
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log
Tue Sep 24 14:10:10 2013
Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Instance terminated by USER, pid = 30264
ORA-1092 signalled during: alter database open ...
[oracle@jszg ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 25 11:11:15 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> create pfile='/tmp/pfile' from spfile;
File created.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
[root@jszg bdump]# vi /tmp/pfile
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='NINVOICE'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='NINVOICE'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='MANUAL'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/NINVOICE/udump'
~
"/tmp/pfile" 31L, 1057C written
SQL> startup pfile='/tmp/pfile' mount;
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database open;
Database altered.
SQL> create undo tablespace undotbs2 datafile '/u01/oracle/oradata/NINVOICE/udotbs02.dbf' size 100m;
Tablespace created.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1
SQL> alter system set undo_management=AUTO;
alter system set undo_management=AUTO
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
[root@jszg bdump]# vi /tmp/pfile
*._allow_resetlogs_corruption=TRUE
*.aq_tm_processes=1
*.background_dump_dest='/u01/oracle/admin/NINVOICE/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/oracle/oradata/NINVOICE/control01.ctl','/u01/oracle/oradata/NINVOICE/control02.ctl','/u01/oracle/oradata/NINVOICE/control03.ctl'
*.core_dump_dest='/u01/oracle/admin/NINVOICE/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='NINVOICE'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='NINVOICE'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS2'
"/tmp/pfile" 31L, 1055C written
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile=/tmp/pfile mount;
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database open;
Database altered.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 10800
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS2
SQL> drop tablespace undotbs1 including contents and datafiles;
Tablespace dropped.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
转载于:http://blog.itpub.net/16381228/viewspace-773362/