Menu de navegação

[Anônimo]

Amigos,

Instalei o oracle 10xe sem problema e tudo mais…
Funciona 100% durante todo o dia… a noite, por volta das 00:30 efetuo um backup atraves do EXP, desmonto a base e monto novamente.
Acesso a base depois e esta tudo ok… então, por volta das 8:00 quando tento acessar pelo client a base esta parada.
Tenho que startar novamente para que ela funcione normalmente.

O que pode estar acontecendo????
Para a versão 10Xe, onde encontro um LOG que possa me ajudar a encontrar esse problema?

[Marcio68AlmeidaParticipante]

você derruba o banco e reinicia para tirar backup ???
você usa o EXP ou EXPBP ???
O que está parado ? O banco, o listener, a web ???

se você seguir o PATH onde o banco está instalado encontrará um diretório ADMIN/BDUMP onde está o ALERT do banco…

[Anônimo]

Marcio,
Obrigado por sua atenção.

Bem.. o banco é iniciado sem problemas… no inicio do dia.
Funciona tudo sem problemas durante todo o dia…
A noite, as 00:30 faço um backup automáticamente atraves do EXP…

Pela manhã ao abrir o sistema, a base esta parada e tenho que montar ela novamente.

Então alterei o bat para que ele fizesse o EXP… desmontasse a base… e depois montasse.
Mas mesmo assim o erro continuou…

Olha o LOG como esta…

Tue Apr 24 00:31:09 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 2267K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Tue Apr 24 00:31:17 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 2324K exceeds notification threshold (2048K)
Details in trace file d:appssixxoracleexeapporacleadminxeudumpxe_ora_2236.trc
KGL object name :XDB.XD7DujEWKdQzCT1MWnFJ6WfA==

Tue Apr 24 00:33:10 2007
Shutting down instance: further logons disabled
Tue Apr 24 00:33:12 2007
Stopping background process CJQ0
Tue Apr 24 00:33:12 2007
Stopping background process QMNC
Tue Apr 24 00:33:14 2007
Stopping background process MMNL
Tue Apr 24 00:33:15 2007
Stopping background process MMON
Tue Apr 24 00:33:16 2007
Shutting down instance (immediate)
License high water mark = 4
Tue Apr 24 00:33:16 2007
Stopping Job queue slave processes
Tue Apr 24 00:33:16 2007
Job queue slave processes stopped
Waiting for dispatcher ‘D000’ to shutdown
All dispatchers and shared servers shutdown
Tue Apr 24 00:33:20 2007
alter database close normal
Tue Apr 24 00:33:23 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Apr 24 00:33:27 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 22
Successful close of redo thread 1
Tue Apr 24 00:33:29 2007
Completed: alter database close normal
Tue Apr 24 00:33:29 2007
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:appssixxoracleexeapporacleadminxebdumpalert_xe.log
Tue Apr 24 00:33:53 2007
ORACLE V10.2.0.1.0 – Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 2 – type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:149M/511M, Ph+PgF:881M/1257M, VA:1944M/2047M
Tue Apr 24 00:33:53 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 75497472
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:APPSSIXXORACLEEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 146800640
control_files = D:APPSSIXXORACLEEXEORADATAXECONTROL.DBF
__db_cache_size = 54525952
compatible = 10.2.0.1.0
db_recovery_file_dest = D:APPSSIXXOracleExeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEADUMP
background_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEBDUMP
user_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEUDUMP
core_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41943040
PMON started with pid=2, OS id=3504
MMAN started with pid=4, OS id=2788
DBW0 started with pid=5, OS id=3668
CKPT started with pid=7, OS id=2896
RECO started with pid=9, OS id=2164
MMON started with pid=11, OS id=3768
Tue Apr 24 00:33:57 2007
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
Tue Apr 24 00:33:57 2007
starting up 4 shared server(s) …
Oracle Data Guard is not available in this edition of Oracle.
Tue Apr 24 00:33:58 2007
alter database mount exclusive
LGWR started with pid=6, OS id=3568
SMON started with pid=8, OS id=3964
CJQ0 started with pid=10, OS id=2784
MMNL started with pid=12, OS id=3820
PSP0 started with pid=3, OS id=3040
Tue Apr 24 00:34:03 2007
Setting recovery target incarnation to 2
Tue Apr 24 00:34:04 2007
Successful mount of redo thread 1, with mount id 2501840054
Tue Apr 24 00:34:04 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Apr 24 00:34:04 2007
alter database open
Tue Apr 24 00:34:06 2007
Thread 1 opened at log sequence 22
Current log# 1 seq# 22 mem# 0: D:APPSSIXXORACLEEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_32D88N1Y_.LOG
Successful open of redo thread 1
Tue Apr 24 00:34:06 2007
SMON: enabling cache recovery
Tue Apr 24 00:34:14 2007
Successfully onlined Undo Tablespace 1.
Tue Apr 24 00:34:14 2007
SMON: enabling tx recovery
Tue Apr 24 00:34:15 2007
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=988
Tue Apr 24 00:34:26 2007
Completed: alter database open
Tue Apr 24 00:34:30 2007
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Apr 24 00:34:31 2007
Starting ORACLE instance (normal)
Tue Apr 24 02:08:10 2007
KCF: write/open error block=0x79 online=1
file=2 D:APPSSIXXORACLEEXEORADATAXEUNDO.DBF
error=27072 txt: ‘OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.’
Tue Apr 24 02:08:11 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_dbw0_3668.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 2 (block # 121)
ORA-01110: data file 2: ‘D:APPSSIXXORACLEEXEORADATAXEUNDO.DBF’
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

DBW0: terminating instance due to error 1242
Tue Apr 24 02:08:12 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_q001_1048.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:12 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_psp0_3040.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:12 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_lgwr_3568.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:13 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_mman_2788.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:13 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_ckpt_2896.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:14 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_j000_1028.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:15 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_pmon_3504.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:25 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_reco_2164.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:25 2007
Errors in file d:appssixxoracleexeapporacleadminxebdumpxe_smon_3964.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

Tue Apr 24 02:08:28 2007
Instance terminated by DBW0, pid = 3668
Dump file d:appssixxoracleexeapporacleadminxebdumpalert_xe.log
Tue Apr 24 08:23:03 2007
ORACLE V10.2.0.1.0 – Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 2 – type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:111M/511M, Ph+PgF:895M/1257M, VA:1945M/2047M
Tue Apr 24 08:23:03 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 79691776
__large_pool_size = 8388608
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:APPSSIXXORACLEEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 146800640
control_files = D:APPSSIXXORACLEEXEORADATAXECONTROL.DBF
__db_cache_size = 50331648
compatible = 10.2.0.1.0
db_recovery_file_dest = D:APPSSIXXOracleExeapporacleflash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEADUMP
background_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEBDUMP
user_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXEUDUMP
core_dump_dest = D:APPSSIXXORACLEEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41943040
PSP0 started with pid=3, OS id=388
PMON started with pid=2, OS id=1620
MMAN started with pid=4, OS id=3448
DBW0 started with pid=5, OS id=4024
CKPT started with pid=7, OS id=2504
RECO started with pid=9, OS id=2380
MMON started with pid=11, OS id=2056
LGWR started with pid=6, OS id=372
SMON started with pid=8, OS id=2160
CJQ0 started with pid=10, OS id=292
MMNL started with pid=12, OS id=3896
Tue Apr 24 08:23:17 2007
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 4 shared server(s) …
Oracle Data Guard is not available in this edition of Oracle.
Tue Apr 24 08:23:23 2007
alter database mount exclusive
Tue Apr 24 08:23:28 2007
Setting recovery target incarnation to 2
Tue Apr 24 08:23:29 2007
Successful mount of redo thread 1, with mount id 2501862075
Tue Apr 24 08:23:29 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue Apr 24 08:23:30 2007
alter database open
Tue Apr 24 08:23:32 2007
Beginning crash recovery of 1 threads
Tue Apr 24 08:23:32 2007
Started redo scan
Tue Apr 24 08:23:35 2007
Completed redo scan
1455 redo blocks read, 309 data blocks need recovery
Tue Apr 24 08:23:35 2007
Started redo application at
Thread 1: logseq 22, block 64485
Tue Apr 24 08:23:36 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 22 Reading mem 0
Mem# 0 errs 0: D:APPSSIXXORACLEEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_32D88N1Y_.LOG
Tue Apr 24 08:23:40 2007
Completed redo application
Tue Apr 24 08:23:40 2007
Completed crash recovery at
Thread 1: logseq 22, block 65940, scn 1291010
309 data blocks read, 307 data blocks written, 1455 redo blocks read
Tue Apr 24 08:23:45 2007
Thread 1 advanced to log sequence 23
Thread 1 opened at log sequence 23
Current log# 2 seq# 23 mem# 0: D:APPSSIXXORACLEEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_32D89JPY_.LOG
Successful open of redo thread 1
Tue Apr 24 08:23:46 2007
SMON: enabling cache recovery
Tue Apr 24 08:23:54 2007
Successfully onlined Undo Tablespace 1.
Tue Apr 24 08:23:54 2007
SMON: enabling tx recovery
Tue Apr 24 08:23:55 2007
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=3848
Tue Apr 24 08:24:08 2007
Completed: alter database open
Tue Apr 24 08:24:15 2007
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Apr 24 08:24:21 2007
Starting ORACLE instance (normal)

[chduarteParticipante]

Verifique este erro: db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

No banco 10g alguns conceitos mudaram.

Vc utiliza archive?

[]

[Anônimo]

Não… fiz a instalação basica do Oracle 10Xe…
Converti a base de dados que era em Access para Oracle e importei os dados.
Como falei, funciona tudo perfeitamente bem durante o dia… ai a noite ele dá o erro.
Vi as msg de erro… Você poderia me ajudar a retificar esse erro?

[Autor]

Posts