Menu de navegação

[HitotuziParticipante]

Tenho um banco de dados 9i

Foi desligado de forma incorreta (queda de energia)

quando fui abrir o banco aparece o erro ORA-01092:
ORACLE instance terminated. Disconnection forced

e não abre de jeito nenhum apenas inicia e monta, gostaria de uma ajuda

como faço para resolver.

Agradeço desde já a atenção

abs

Hitotuzi

[Regis AraujoParticipante]

Opa Hitotuzi..!!

Posta aqui a mensagem que aparece no Alert.log do seu banco..!!

Abraços..!

[HitotuziParticipante]

Dump file C:oracleadminsfdesbdumpsfdesALRT.LOG
Wed Mar 18 08:16:58 2009
ORACLE V9.0.1.1.1 – Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Mar 18 08:17:00 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Wed Mar 18 08:17:01 2009
Create controlfile reuse set database sfdes
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
‘C:oracleoradatasfdesCWMLITE01.DBF’ ,
‘C:oracleoradatasfdesDRSYS01.DBF’ ,
‘C:oracleoradatasfdesEXAMPLE01.DBF’ ,
‘C:oracleoradatasfdesINDX01.DBF’ ,
‘C:oracleoradatasfdesSYSTEM01.DBF’ ,
‘C:oracleoradatasfdesTOOLS01.DBF’ ,
‘C:oracleoradatasfdesUNDOTBS01.DBF’ ,
‘C:oracleoradatasfdesUSERS01.DBF’
LOGFILE GROUP 1 (‘C:oracleoradatasfdesREDO01.LOG’) SIZE 102400K,
GROUP 2 (‘C:oracleoradatasfdesREDO02.LOG’) SIZE 102400K,
GROUP 3 (‘C:oracleoradatasfdesREDO03.LOG’) SIZE 102400K RESETLOGS
Wed Mar 18 08:17:05 2009
Successful mount of redo thread 1, with mount id 3695428543.
Wed Mar 18 08:17:05 2009
Completed: Create controlfile reuse set database sfdes
MAXINS
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Wed Mar 18 08:17:09 2009
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL…
Wed Mar 18 08:17:09 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Wed Mar 18 08:17:14 2009
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Mar 18 08:17:16 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Wed Mar 18 08:17:18 2009
Create controlfile reuse set database sfdes
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
Datafile
‘C:oracleoradatasfdesCWMLITE01.DBF’ ,
‘C:oracleoradatasfdesDRSYS01.DBF’ ,
‘C:oracleoradatasfdesEXAMPLE01.DBF’ ,
‘C:oracleoradatasfdesINDX01.DBF’ ,
‘C:oracleoradatasfdesSYSTEM01.DBF’ ,
‘C:oracleoradatasfdesTOOLS01.DBF’ ,
‘C:oracleoradatasfdesUNDOTBS01.DBF’ ,
‘C:oracleoradatasfdesUSERS01.DBF’
LOGFILE GROUP 1 (‘C:oracleoradatasfdesREDO01.LOG’) SIZE 102400K,
GROUP 2 (‘C:oracleoradatasfdesREDO02.LOG’) SIZE 102400K,
GROUP 3 (‘C:oracleoradatasfdesREDO03.LOG’) SIZE 102400K RESETLOGS
Wed Mar 18 08:17:22 2009
Successful mount of redo thread 1, with mount id 3695464144.
Wed Mar 18 08:17:22 2009
Completed: Create controlfile reuse set database sfdes
MAXINS
Wed Mar 18 08:17:22 2009
alter database sfdes open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 267823
Resetting resetlogs activation ID 0 (0x0)
Wed Mar 18 08:17:37 2009
Assigning activation ID 3695464144 (0xdc444ed0)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:ORACLEORADATASFDESREDO03.LOG
Successful open of redo thread 1.
Wed Mar 18 08:17:38 2009
SMON: enabling cache recovery
Wed Mar 18 08:17:40 2009
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.
Dictionary check beginning
Tablespace ‘TEMP’ #6 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Wed Mar 18 08:17:41 2009
SMON: enabling tx recovery
Wed Mar 18 08:17:46 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database sfdes open resetlogs
Wed Mar 18 08:18:02 2009
alter database rename global_name to sfdes
Completed: alter database rename global_name to sfdes
Wed Mar 18 08:18:03 2009
ALTER TABLESPACE TEMP ADD TEMPFILE ‘C:oracleoradatasfdesTEMP01.DBF’ REUSE
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE ‘C:oracleorad
Wed Mar 18 08:18:03 2009
Restarting dead background process EMN0
EMN0 started with pid=14
Wed Mar 18 08:18:03 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Wed Mar 18 08:18:11 2009
ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:18:12 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Mar 18 08:18:13 2009
Thread 1 closed at log sequence 1
Wed Mar 18 08:18:13 2009
Completed: ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:18:13 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Wed Mar 18 08:18:17 2009
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Mar 18 08:18:19 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Wed Mar 18 08:18:20 2009
ALTER DATABASE MOUNT
Wed Mar 18 08:18:27 2009
Successful mount of redo thread 1, with mount id 3695472142.
Wed Mar 18 08:18:27 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Mar 18 08:18:27 2009
alter database open
Wed Mar 18 08:18:28 2009
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:ORACLEORADATASFDESREDO03.LOG
Successful open of redo thread 1.
Wed Mar 18 08:18:28 2009
SMON: enabling cache recovery
Wed Mar 18 08:18:28 2009
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.
Wed Mar 18 08:18:29 2009
SMON: enabling tx recovery
Wed Mar 18 08:18:32 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed Mar 18 08:18:37 2009
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Updating character set in controlfile to WE8MSWIN1252
Completed: alter database character set INTERNAL_CONVERT WE8M
Wed Mar 18 08:18:40 2009
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON
Wed Mar 18 08:18:43 2009
Restarting dead background process EMN0
EMN0 started with pid=12
Wed Mar 18 08:18:43 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Wed Mar 18 08:18:52 2009
ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:18:52 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Mar 18 08:18:52 2009
Thread 1 closed at log sequence 1
Wed Mar 18 08:18:53 2009
Completed: ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:18:53 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Wed Mar 18 08:18:57 2009
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Mar 18 08:19:00 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Wed Mar 18 08:19:01 2009
ALTER DATABASE MOUNT
Wed Mar 18 08:19:08 2009
Successful mount of redo thread 1, with mount id 3695482423.
Wed Mar 18 08:19:08 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Mar 18 08:19:08 2009
ALTER DATABASE OPEN
Wed Mar 18 08:19:08 2009
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:ORACLEORADATASFDESREDO03.LOG
Successful open of redo thread 1.
Wed Mar 18 08:19:08 2009
SMON: enabling cache recovery
Wed Mar 18 08:19:08 2009
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.
Wed Mar 18 08:19:08 2009
SMON: enabling tx recovery
Wed Mar 18 08:19:10 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Wed Mar 18 08:19:27 2009
Restarting dead background process EMN0
EMN0 started with pid=13
Wed Mar 18 08:19:27 2009
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Wed Mar 18 08:19:36 2009
ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:19:36 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Mar 18 08:19:36 2009
Thread 1 closed at log sequence 1
Wed Mar 18 08:19:36 2009
Completed: ALTER DATABASE CLOSE NORMAL
Wed Mar 18 08:19:36 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Wed Mar 18 08:19:41 2009
Starting ORACLE instance (normal)
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Wed Mar 18 08:19:43 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Wed Mar 18 08:19:45 2009
ALTER DATABASE MOUNT
Wed Mar 18 08:19:51 2009
Successful mount of redo thread 1, with mount id 3695470691.
Wed Mar 18 08:19:51 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Mar 18 08:19:51 2009
ALTER DATABASE OPEN
Wed Mar 18 08:19:52 2009
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:ORACLEORADATASFDESREDO03.LOG
Successful open of redo thread 1.
Wed Mar 18 08:19:52 2009
SMON: enabling cache recovery
Wed Mar 18 08:19:52 2009
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.
Wed Mar 18 08:19:52 2009
SMON: enabling tx recovery
Wed Mar 18 08:19:53 2009
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Wed Mar 18 10:40:49 2009
/* OracleOEM / ALTER TABLESPACE “INDX” ADD DATAFILE ‘C:ORACLEORADATASFDESINDX02.DBF.’ SIZE 5M
Wed Mar 18 10:40:49 2009
Completed: / OracleOEM / ALTER TABLESPACE “INDX” ADD DATAFI
Wed Mar 18 10:40:49 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESINDX01.DBF’ RESIZE 5000M
Wed Mar 18 10:43:47 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:43:47 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESINDX01.DBF’ AUTOEXTEND ON NEXT 1280M MAXSIZE UNLIMITED
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:44:16 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESINDX02.DBF’ RESIZE 5000M
Wed Mar 18 10:47:11 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:47:11 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESINDX02.DBF’ AUTOEXTEND ON
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:47:37 2009
/ OracleOEM / ALTER TABLESPACE “INDX” ADD DATAFILE ‘C:ORACLEORADATASFDESINDX03.DBF’ SIZE 5M
Wed Mar 18 10:47:38 2009
Completed: / OracleOEM / ALTER TABLESPACE “INDX” ADD DATAFI
Wed Mar 18 10:48:02 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESINDX03.DBF’ AUTOEXTEND ON NEXT 1024K MAXSIZE 5000M
Wed Mar 18 10:48:02 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:50:58 2009
/ OracleOEM / CREATE TABLESPACE “SIATE01” LOGGING DATAFILE ‘C:ORACLEORADATASFDESSIATE01.ora’ SIZE 5M EXTENT MANAGEMENT LOCAL
Wed Mar 18 10:50:58 2009
Completed: / OracleOEM / CREATE TABLESPACE “SIATE01” LOGGIN
Wed Mar 18 10:51:23 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESSIATE01.ORA’ RESIZE 500M
Wed Mar 18 10:51:38 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 10:51:52 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESSIATE01.ORA’ AUTOEXTEND ON NEXT 1024K
Wed Mar 18 10:51:52 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 11:09:19 2009
/ OracleOEM / CREATE TABLESPACE “SIATEDAT” LOGGING DATAFILE ‘C:ORACLEORADATASFDESSIATEDAT01.DBF’ SIZE 5000M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
Wed Mar 18 11:12:24 2009
Completed: / OracleOEM / CREATE TABLESPACE “SIATEDAT” LOGGI
Wed Mar 18 12:58:08 2009
/ OracleOEM / ALTER TABLESPACE “SIATEDAT” ADD DATAFILE ‘C:ORACLEORADATASFDESSIATEDAT02.DBF’ SIZE 6000M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED, ‘C:ORACLEORADATASFDESSIATEDAT03.DBF’ SIZE 6000M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
Wed Mar 18 13:05:21 2009
Completed: / OracleOEM / ALTER TABLESPACE “SIATEDAT” ADD DA
Wed Mar 18 13:05:21 2009
/ OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLEORADATASFDESSIATEDAT01.DBF’ RESIZE 6000M
Wed Mar 18 13:05:56 2009
Completed: / OracleOEM / ALTER DATABASE DATAFILE ‘C:ORACLE
Wed Mar 18 16:27:16 2009
/ OracleOEM / CREATE TABLESPACE “TS_NFE” LOGGING DATAFILE ‘C:ORACLEORADATASFDESTS_NFE.ora’ SIZE 700M EXTENT MANAGEMENT LOCAL
Wed Mar 18 16:27:41 2009
Completed: / OracleOEM / CREATE TABLESPACE “TS_NFE” LOGGING
Wed Mar 18 16:29:08 2009
/ OracleOEM / CREATE TABLESPACE “TS_NFE_TEMP” LOGGING DATAFILE ‘C:ORACLEORADATASFDESTS_NFE_TEMP.ora’ SIZE 200M EXTENT MANAGEMENT LOCAL
Wed Mar 18 16:29:16 2009
Completed: / OracleOEM / CREATE TABLESPACE “TS_NFE_TEMP” LO
Thu Mar 19 07:36:56 2009
/ OracleOEM / CREATE TABLESPACE “SISCAF” LOGGING DATAFILE ‘C:ORACLEORADATASFDESSISCAF01.DBF’ SIZE 50M EXTENT MANAGEMENT LOCAL
Thu Mar 19 07:36:58 2009
Completed: / OracleOEM / CREATE TABLESPACE “SISCAF” LOGGING
Thu Mar 19 07:48:01 2009
/ OracleOEM / DROP TABLESPACE “TS_NFE_TEMP”INCLUDING CONTENTS CASCADE CONSTRAINTS
Thu Mar 19 07:48:02 2009
Completed: / OracleOEM / DROP TABLESPACE “TS_NFE_TEMP”INCLU
Thu Mar 19 07:48:30 2009
/ OracleOEM / CREATE TEMPORARY TABLESPACE “TS_NFE_TEMP” TEMPFILE ‘C:ORACLEORADATASFDESTS_NFE_TEMP01.dbf’ SIZE 700M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
Thu Mar 19 07:48:30 2009
Completed: / OracleOEM / CREATE TEMPORARY TABLESPACE “TS_NF
Thu Mar 19 08:11:44 2009
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: C:ORACLEORADATASFDESREDO01.LOG
Thu Mar 19 08:11:50 2009
Restarting dead background process EMN0
EMN0 started with pid=13
Thu Mar 19 08:11:50 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Thu Mar 19 08:12:01 2009
ALTER DATABASE CLOSE NORMAL
Thu Mar 19 08:12:01 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Mar 19 08:12:01 2009
Thread 1 closed at log sequence 2
Thu Mar 19 08:12:01 2009
Completed: ALTER DATABASE CLOSE NORMAL
Thu Mar 19 08:12:01 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Thu Mar 19 08:14:32 2009
Starting ORACLE instance (normal)
Dump file C:oracleadminsfdesbdumpsfdesALRT.LOG
Sat Mar 21 12:40:53 2009
ORACLE V9.0.1.1.1 – Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = C:oracleoradatasfdesCONTROL01.CTL, C:oracleoradatasfdesCONTROL02.CTL, C:oracleoradatasfdesCONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = sfdes
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = C:oracleadminsfdesbdump
user_dump_dest = C:oracleadminsfdesudump
core_dump_dest = C:oracleadminsfdescdump
sort_area_size = 524288
db_name = sfdes
open_cursors = 300
ifile = C:oracleadminsfdespfileinit.ora
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sat Mar 21 12:40:55 2009
starting up 1 shared server(s) …
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Sat Mar 21 12:40:57 2009
alter database mount exclusive
Sat Mar 21 12:40:59 2009
ORA-214 signalled during: alter database mount exclusive…
Mon Mar 23 09:44:42 2009
/ OracleOEM / ALTER DATABASE MOUNT
Mon Mar 23 09:44:45 2009
ORA-214 signalled during: / OracleOEM */ ALTER DATABASE MOUNT…
Mon Mar 23 09:49:22 2009
Starting ORACLE instance (normal)
Mon Mar 23 09:49:53 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 2
Mon Mar 23 09:49:57 2009
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL…
Mon Mar 23 09:49:57 2009
ALTER DATABASE DISMOUNT
ORA-1507 signalled during: ALTER DATABASE DISMOUNT…
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
archiving is disabled
Archive process shutdown avoided: 0 active
Mon Mar 23 09:50:45 2009
Starting ORACLE instance (normal)

[jspaulonciParticipante]

Hitotuzi, você pegou a instância correta ? No seu log aparece refêrencia ao mês de março .

[HitotuziParticipante]

Caro,

      Eu já até desisti de corrigir esse erro, vc sabe uma maneira de eu fazer um export do meu banco, nessas condições

1- Conecto somente com o sys

2- O banco inicia e monta somente

tentei fazer um export com o sys mas ele traz as minhas tabelas zeradas

vc sabe outra maneira???

abs

Hitotuzi

[jspaulonciParticipante]

qual é comando que está utilizando para fazer o exp ?

[HitotuziParticipante]

exp sys/senha@instancia file=d:arquivo.dmp log=d:arquivo.log full=y feedback=100000 buffer=1000000 direct=n compress=n consistent=y

logo após a execução

dá uma mensagem de erro:

ORA – 01033 – ORACLE initialization or shutdown in progress

o banco está no estado mount apenas para leitura

depois disso pede o login e senha de um usuário, coloco os dados o sistema inicia a exportação porém só me traz tabelas com 0 linhas

[jspaulonciParticipante]

para fazer o exp , o banco precisa estar aberto

cara……conect com sys as sysdba e tente

shutdown immediate;
startup nomount;
alter database mount;
alter databae open;

se ele não abrir me passe umas 400 linhas do alert para eu analisar

[HitotuziParticipante]

o alert não está guardando os logs.

mas agora eu estou fazendo uma tentativa de fazer o backup pelo RMAN

vou ver se consigo,

obrigado pela atenção

At,

Hitotuzi

[Autor]

Posts