Ora-01033 Error Rectifiation (Oracle 8i) [message #229998] |
Tue, 10 April 2007 08:51 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Hi all
i am in trouble due to ORA-01033.
The documentation says about this error to wait few minutes, so i waited for many minutes.
But my problem is not solved.
I searched the forum but could not do the step-2 for the solution
Step-1: run from cmd sqlplus /nolog
Stept-2 connect / as sysdba (which i beleive is system/manager@mos as sysdba)
Please help me
I am using Oracle 8i.
[Updated on: Tue, 10 April 2007 15:46] Report message to a moderator
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230066 is a reply to message #229998] |
Tue, 10 April 2007 15:55 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Dear Michel
I can not find alert.log on my PC.
Still Looking for help.
Additional Information:
1) I am using Windowns 2000 Professional
2) ORA-01033 means: Oracle Initialization or Shutdown in progress
3) I am successfully running other database named CHA on my same machine. (My machine has two databases one is CHA while other is MOS)
4) With refernce to my above post, in step-2, when i type
connect system/********@mos as sysdba
The error comes in front is ORA-01031: insufficient priviliges
Please help!
-Dude
[Updated on: Tue, 10 April 2007 15:56] Report message to a moderator
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230068 is a reply to message #230066] |
Tue, 10 April 2007 16:03 |
|
Michel Cadot
Messages: 68686 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
alert.log is on the server.
alert.log is a shortcut for alert<SID>.log or alert_<SID>.log or <SID>ALRT.LOG or... depending on your version.
It is in the background_dump_dest directory.
Check in this file why the instance is always in "Initialization or Shutdown in progress" state.
SYSTEM is not granted SYSDBA by default hence the "insufficent privilege" error.
Regards
Michel
[add the last sentence]
[Updated on: Tue, 10 April 2007 16:05] Report message to a moderator
|
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230074 is a reply to message #229998] |
Tue, 10 April 2007 16:17 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
ok i got the file. It was <sid>ALRT.log
But i am not capable enough to anaylyze it. So here are last few lines of this file
Wed Apr 11 01:03:05 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 11 01:03:06 2007
alter database mount exclusive
Wed Apr 11 01:03:10 2007
Successful mount of redo thread 1, with mount id 2831777550.
Wed Apr 11 01:03:10 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 11 01:03:10 2007
alter database open
ORA-1122 signalled during: alter database open...
Dump file d:\oracle\admin\mos\bdump\mosALRT.LOG
Wed Apr 11 01:39:21 2007
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Wed Apr 11 01:39:21 2007
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 15728640
java_pool_size = 20971520
nls_date_format = DD-MON-YYYY
control_files = d:\oracle\oradata\mos\control01.ctl, d:\oracle\oradata\mos\control02.ctl
db_block_buffers = 8192
db_block_size = 2048
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
service_names = mos
instance_name = mos
mts_dispatchers = (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=mos))))(PRE=oracle.aurora.server.SGiopServer)
mts_servers = 1
open_links = 4
db_name = mos
os_authent_prefix =
job_queue_processes = 2
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = d:\oracle\admin\mos\bdump
user_dump_dest = d:\oracle\admin\mos\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
CKPT started with pid=5
SMON started with pid=6
LGWR started with pid=4
DBW0 started with pid=3
RECO started with pid=7
SNP0 started with pid=8
Wed Apr 11 01:39:53 2007
starting up 1 shared server(s) ...
SNP1 started with pid=9
Wed Apr 11 01:39:58 2007
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 11 01:40:20 2007
alter database mount exclusive
Wed Apr 11 01:40:50 2007
Successful mount of redo thread 1, with mount id 2831772891.
Wed Apr 11 01:40:50 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 11 01:40:51 2007
alter database open
Wed Apr 11 01:41:04 2007
ORA-1122 signalled during: alter database open...
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230076 is a reply to message #230071] |
Tue, 10 April 2007 16:22 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
anacedent wrote on Wed, 11 April 2007 02:06 | >Check in this file why the instance is always in "Initialization or Shutdown in progress" state.
IMO, it does not matter why/how it got into this state.
AFAIK, the (only) solution is to
sqlplus
SQL> / as sysdba
SQL> shutdown abort
SQL> startup
SQL> exit
|
How to connect as sysdba? what is the default password?
Who has sysdba priviliges by default (i mean when a database is created who has sysdba privilges)
|
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230079 is a reply to message #230077] |
Tue, 10 April 2007 16:34 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 11 April 2007 02:24 | ora-01122: database file %s failed verification check
*Cause: The information in this file is inconsistent with information
from the control file. See accompanying message for reason.
*Action: Make certain that the db files and control files are the correct
files for this database.
Seems there should be something else in your alert.log file.
Check if disk is not full.
Check if all control files are there.
Check if all data files are there.
Regards
Michel
|
-1- Disk has ample space. 3 GB in current partition where Oracle is installed.
-2- Control files? data files? I am very poor at DBA.
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230083 is a reply to message #230078] |
Tue, 10 April 2007 16:42 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
anacedent wrote on Wed, 11 April 2007 02:25 | >How to connect as sysdba?
As the OS user who owns the oracle directory/software tree
>what is the default password?
There is none.
Who has sysdba priviliges by default (i mean when a database is created who has sysdba privilges)
See answer #1 above
try it, you'll like it.
|
Your answer is leading me to the thinking that in my case OS administator has created the directory.
Hence it OS's administrator will be entered as sysdba in oracle?
My thinking does not sounds good.
Anyhow i have done this:
Step-1: After click start>Run, i typed SQLPLUS /nolog
Step-2: connect administrator/admin_password as sysdba
and i got the error ORA-12203 TNS: Unable to connect to destination
Please help me to align my thinking
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230091 is a reply to message #229998] |
Tue, 10 April 2007 20:01 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
I apologize for being less than 100% crystal clear for those who are clue resistant.
$ sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 10 17:58:48 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Does this cut & paste example make things clearer & more understandable?
[Updated on: Tue, 10 April 2007 20:02] by Moderator Report message to a moderator
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230138 is a reply to message #230091] |
Wed, 11 April 2007 00:54 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
anacedent wrote on Wed, 11 April 2007 06:01 | I apologize for being less than 100% crystal clear for those who are clue resistant.
$ sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 10 17:58:48 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Does this cut & paste example make things clearer & more understandable?
|
Dear anacedent
i am stuck at step-2 again. After typing SQLPLUS in start>Run Box, i have the following thing
SQL*Plus: Release 8.0.6.0.0 - Production on Wed Apr 11 10:53:13 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-12203: TNS:unable to connect to destination
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230179 is a reply to message #230165] |
Wed, 11 April 2007 02:46 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 11 April 2007 12:14 | Don't you have LOCAL environment parameter set?
Check in your registry HKLM/Software/Oracle/...
Btw, is your database local or remote?
Regards
Michel
|
I have admitted before that i am very weak at DBA. So, i prefer to use the default Values in the registry. Only sting which i used to edit is "PATH" one. Hence HKLM/Software/Oracle/... is full of strings having defualt values.
My database is local and i am using only one single machine. (having two different databases)
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230183 is a reply to message #230126] |
Wed, 11 April 2007 02:54 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 11 April 2007 09:48 | I meant disk containing database files and the one containing the alert.log and trace files.
Check if you don't have any trace files from the last startup (in the same directory as alert.log).
Control files are listed in alert.log (and you posted them).
Data files can be gotten by querying v$datafile when connected "as sysdba". Check alsio status and enabled columns in v$datafile and v$datafile_header views.
Regards
Michel
|
Thanks for your guidence.
My mosalrt.log file has the following line in begining
control_files = d:\oracle\oradata\mos\control01.ctl, d:\oracle\oradata\mos\control02.ctl
Thus i have check the presence of these ctl files in the above specified path and they seems to be ok. The database files are also present in the same directory.
i am still unable to connected "as sysdba" so can not see the status of the views
Still looking for the solution
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230204 is a reply to message #230192] |
Wed, 11 April 2007 03:42 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 11 April 2007 13:10 | What about LOCAL environment variable?
Either in Oracle part of registry or in "Environment Variables" in "System properties"/"Advanced" tab.
Regards
Michel
|
well, about Local Variable, i have never set them as i have no knowledge about its settings.
Environment Variables in System properties/ Advance Tab are at their normal/default values (as i have never touched them).
What i can see their is two blocks.
Block 1: user variables for admin
It has two variables, TEMP and TMP
Block 2: System variables
It has many variables like:Path, processors, Temp, TMP, wv_gateway_cfg etc
Please guide me if you feel some discripency
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230392 is a reply to message #230321] |
Wed, 11 April 2007 14:18 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
anacedent wrote on Wed, 11 April 2007 19:26 | 12203, 00000, "TNS:unable to connect to destination"
// *Cause: Invalid address specified or destination is not listening.
// This error can also occur because of underlying network or network
// transport problems.
// *Action: Verify that the net service name you entered was correct.
// Verify that the ADDRESS portion of the connect descriptor which
// corresponds to the net service name is correct. Ensure that the
// destination process (for example the listener) is running at the
// remote node.
To me this implies that the connection is trying to use SQL*Net,
when it should NOT be doing so.
Bring up "command window" (cmd) & issue the command :
$ SET
post results back here.
|
Now i am not getting ORA-012203 error as i am procedding as follow:
1) Started Listener manually by running D:\oracle\BIN\TNSLSNR.EXE
2) Entering CMD at run
3) Issuing command at C:\>set oracle_sid=mos
4) Issuing command at C:\>SQLPLUS /nolog
5) a new window is appered with SQL>
6) entering connect / as sysdba giving me insufficient priviliges message. Even i have checked that the OS administrator is memmber of ORA_DBA too.
But if i proceed as follow then i am getting ORA-012203.
1) Started Listener manually by running D:\oracle\BIN\TNSLSNR.EXE
2) Issuing command at Run... SQLPLUS
3) a new window is appered with asking username
6) entering connect / as sysdba giving me ORA-012203 error
The set command has given me
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SJMOS-GKIB94DFF
ComSpec=C:\WINNT\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\
LOGONSERVER=\\SJMOS-GKIB94DFF
NUMBER_OF_PROCESSORS=1
oracle_sid=mos
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=d:\orant\bin;d:\oracle\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\s
ystem32;C:\WINNT;C:\WINNT\System32\Wbem;d:\orant\jdk\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 7 Stepping 3, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0703
ProgramFiles=C:\Program Files
PROMPT=$P$G
SystemDrive=C:
SystemRoot=C:\WINNT
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=SJMOS-GKIB94DFF
USERNAME=administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINNT
wv_gateway_cfg=d:\orant\listener\cfg\wdbsvr.app
|
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230978 is a reply to message #229998] |
Fri, 13 April 2007 10:57 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Somehow i have managed to contact with the help of "internal" user.
The session was as follow:
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> connect internal/p as sysdba
Connected.
SQL> select user from dual;
USER
------------------------------
SYS
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 36437964 bytes
Fixed Size 65484 bytes
Variable Size 19521536 bytes
Database Buffers 16777216 bytes
Redo Buffers 73728 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
SQL> exit
Disconnected from Oracle8i Personal Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
C:\>
But my problem is not solved as i am still getting ORA-01033
So requesting you all to analyze my above findings.
Thanks
|
|
|
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230979 is a reply to message #230126] |
Fri, 13 April 2007 11:00 |
dude4084
Messages: 222 Registered: March 2005 Location: Mux
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 11 April 2007 09:48 | I meant disk containing database files and the one containing the alert.log and trace files.
Check if you don't have any trace files from the last startup (in the same directory as alert.log).
Control files are listed in alert.log (and you posted them).
Data files can be gotten by querying v$datafile when connected "as sysdba". Check alsio status and enabled columns in v$datafile and v$datafile_header views.
Regards
Michel
|
The ouput by quering v$datafile and v$datafile_header is as follow: (sorry as i could not format it)
SQL> select * from v$datafile ;
FILE# CREATION_CHANGE# CREATION_TI TS# RFILE# STATUS ENABLED CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
1 4 01-MAR-1999 0 1 SYSTEM READ WRITE
1177407
09-APR-2007 0
137638
137639 10-MAR-2007 146800640 71680 0 2048
D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF
0
2 4385 01-MAR-1999 1 2 ONLINE READ WRITE
1177407
09-APR-2007 0
137638
137639 10-MAR-2007 3145728 1536 0 2048
D:\ORACLE\ORADATA\MOS\USERS01.DBF
0
3 4394 01-MAR-1999 2 3 ONLINE READ WRITE
1177407
FILE# CREATION_CHANGE# CREATION_TI TS# RFILE# STATUS ENABLED CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
09-APR-2007 0
137638
137639 10-MAR-2007 26214400 12800 0 2048
D:\ORACLE\ORADATA\MOS\RBS01.DBF
0
4 4403 01-MAR-1999 3 4 ONLINE READ WRITE
1177407
09-APR-2007 0
137638
137639 10-MAR-2007 2097152 1024 0 2048
D:\ORACLE\ORADATA\MOS\TEMP01.DBF
0
5 4413 01-MAR-1999 4 5 ONLINE READ WRITE
1177407
09-APR-2007 0
137638
FILE# CREATION_CHANGE# CREATION_TI TS# RFILE# STATUS ENABLED CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME BYTES BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
137639 10-MAR-2007 5242880 2560 0 2048
D:\ORACLE\ORADATA\MOS\OEMREP01.DBF
0
6 4422 01-MAR-1999 5 6 ONLINE READ WRITE
1177407
09-APR-2007 0
137638
137639 10-MAR-2007 2097152 1024 0 2048
D:\ORACLE\ORADATA\MOS\INDX01.DBF
0
6 rows selected.
SQL> select * from v$datafile_header;
FILE# STATUS ERROR
FORMAT REC
--------- ------- --------------------------------------------------------------
--- --------- ---
FUZ CREATION_CHANGE# CREATION_TI TABLESPACE_NAME TS# RFI
LE#
--- ---------------- ----------- ------------------------------ --------- ------
---
RESETLOGS_CHANGE# RESETLOGS_T CHECKPOINT_CHANGE# CHECKPOINT_ CHECKPOINT_COUNT
BYTES BLOCKS
----------------- ----------- ------------------ ----------- ---------------- --
------- ---------
NAME
--------------------------------------------------------------------------------
--------------------
1 ONLINE OLD CONTROLFILE
8
4 01-MAR-1999 SYSTEM 0
1
137639 10-MAR-2007 1198736 10-APR-2007 1050 14
6800640 71680
D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF
2 ONLINE OLD CONTROLFILE
8
4385 01-MAR-1999 USERS 1
2
137639 10-MAR-2007 1198736 10-APR-2007 1042
3145728 1536
D:\ORACLE\ORADATA\MOS\USERS01.DBF
3 ONLINE OLD CONTROLFILE
8
4394 01-MAR-1999 RBS 2
3
137639 10-MAR-2007 1198736 10-APR-2007 1042 2
6214400 12800
D:\ORACLE\ORADATA\MOS\RBS01.DBF
FILE# STATUS ERROR
FORMAT REC
--------- ------- --------------------------------------------------------------
--- --------- ---
FUZ CREATION_CHANGE# CREATION_TI TABLESPACE_NAME TS# RFI
LE#
--- ---------------- ----------- ------------------------------ --------- ------
---
RESETLOGS_CHANGE# RESETLOGS_T CHECKPOINT_CHANGE# CHECKPOINT_ CHECKPOINT_COUNT
BYTES BLOCKS
----------------- ----------- ------------------ ----------- ---------------- --
------- ---------
NAME
--------------------------------------------------------------------------------
--------------------
4 ONLINE OLD CONTROLFILE
8
4403 01-MAR-1999 TEMP 3
4
137639 10-MAR-2007 1198736 10-APR-2007 1042
2097152 1024
D:\ORACLE\ORADATA\MOS\TEMP01.DBF
5 ONLINE OLD CONTROLFILE
8
4413 01-MAR-1999 OEM_REPOSITORY 4
5
137639 10-MAR-2007 1198736 10-APR-2007 1042
5242880 2560
D:\ORACLE\ORADATA\MOS\OEMREP01.DBF
6 ONLINE OLD CONTROLFILE
8
4422 01-MAR-1999 INDX 5
6
137639 10-MAR-2007 1198736 10-APR-2007 1042
2097152 1024
D:\ORACLE\ORADATA\MOS\INDX01.DBF
6 rows selected.
SQL>
|
|
|