sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 15 14:07:21 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size
2280904 bytes
Variable Size
593048120 bytes
Database Buffers
1006632960 bytes
Redo Buffers
8650752 bytes
Database mounted.
SQL> alter database open;
Database altered.
SQL> select file_name from dba_data_files where file_id=2;
select file_name from dba_data_files where file_id=2
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 3
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [26188], [26197], [], [],
[], [], []
SQL> alter system set undo_management=manual scope=spfile sid='dqb1';
System altered.
SQL> alter system set undo_tablespace='' scope=spfile sid='dqb1';
System altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup force;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size
2280904 bytes
Variable Size
593048120 bytes
Database Buffers
1006632960 bytes
Redo Buffers
8650752 bytes
Database mounted.
Database opened.
SQL> create undo tablespace UNDOTBS3 datafile '+DG/dqb/datafile/undotbs301.dbf' size 4096M;
Tablespace created.
SQL> alter system set undo_management=auto scope=spfile sid='dqb1';
System altered.
SQL> alter system set undo_tablespace=UNDOTBS3 scope=spfile sid='dqb1';
System altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size
2280904 bytes
Variable Size
593048120 bytes
Database Buffers
1006632960 bytes
Redo Buffers
8650752 bytes
Database mounted.
Database opened.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1
1
15159 104857600
1 NO CURRENT
1.3883E+13 15-MAY-14
2
1
15158 104857600
1 YES INACTIVE
1.3883E+13 15-MAY-14
3
2
12015 104857600
1 YES ACTIVE
1.3883E+13 15-MAY-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4
2
12016 104857600
1 NO CURRENT
1.3883E+13 15-MAY-14
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DG/dqb/datafile/system.278.803844945
+DG/dqb/datafile/undotbs1.277.803844945
+DG/dqb/datafile/sysaux.273.803844945
+DG/dqb/datafile/users.276.803844945
+DG/dqb/datafile/example.269.803844997
+DG/dqb/datafile/undotbs2.267.803845065
+DG/dqb/datafile/undotbs11.dbf
+DG/dqb/datafile/undotbs21.dbf
+DG/dqb/datafile/info_dw_01.dbf
+DG/dqb/datafile/info_dw_02.dbf
+DG/dqb/datafile/info_dw_03.dbf
NAME
--------------------------------------------------------------------------------
+DG/dqb/datafile/info_dw_04.dbf
+DG/dqb/datafile/info_dw_05.dbf
+DG/dqb/datafile/info_index_01.dbf
+DG/dqb/datafile/info_index_02.dbf
+DG/dqb/datafile/info_lob_01.dbf
+DG/dqb/datafile/ts_portal_conf_01.dbf
+DG/dqb/datafile/ts_portal_data_01.dbf
+DG/dqb/datafile/ts_portal_idx_01.dbf
+DG/dqb/datafile/ts_portal_log_01.dbf
+DG/dqb/datafile/ts_qbcj_data_01.dbf
+DG/dqb/datafile/ts_gk_rl_data_01.dbf
NAME
--------------------------------------------------------------------------------
+DG/dqb/datafile/ts_gaqjk_data_01.dbf
+DG/dqb/datafile/ts_gaqjk_index_01.dbf
+DG/dqb/datafile/ts_gaqjk_data_02.dbf
+DG/dqb/datafile/ts_gaqjk_data_03.dbf
+DG/dqb/datafile/ts_gaqjk_data_04.dbf
+DG/dqb/datafile/ts_qbjck_data_01.dbf
+DG/dqb/datafile/ts_qbjck_data_02.dbf
+DG/dqb/datafile/ts_qbjck_data_03.dbf
+DG/dqb/datafile/ts_qbjck_data_04.dbf
+DG/dqb/datafile/ts_qbjck_index_01.dbf
+DG/dqb/datafile/ts_qbjck_index_02.dbf
NAME
--------------------------------------------------------------------------------
+DG/dqb/datafile/ts_xxhc_data_01.dbf
+DG/dqb/datafile/ts_disa_data_01.dbf
+DG/dqb/datafile/ts_disa_index_01.dbf
+DG/dqb/datafile/ts_drm_data_01.dbf
+DG/dqb/datafile/ts_drm_sys_01.dbf
+DG/dqb/datafile/ts_drm_meta_01.dbf
+DG/dqb/datafile/ts_zngj_fxk_01.dbf
+DG/dqb/datafile/ts_prs_conf_01.dbf
+DG/dqb/datafile/ts_prs_idx_01.dbf
+DG/dqb/datafile/ts_prs_log_01.dbf
+DG/dqb/datafile/ts_yst_01.dbf
NAME
--------------------------------------------------------------------------------
+DG/dqb/datafile/ts_zngj_tangram.dbf
+DG/dqb/datafile/ts_yjfb_data_01.dbf
+DG/dqb/datafile/users2.dbf
+DG/dqb/datafile/undotbs401.dbf
+DG/dqb/datafile/undotbs301.dbf
49 rows selected.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1
1
15165 104857600
1 NO CURRENT
1.3883E+13 15-MAY-14
2
1
15164 104857600
1 YES ACTIVE
1.3883E+13 15-MAY-14
3
2
12035 104857600
1 NO CURRENT
1.3883E+13 15-MAY-14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4
2
12034 104857600
1 YES ACTIVE
1.3883E+13 15-MAY-14
SQL>
Connection closed by foreign host.