Menu de navegação

[Anônimo]

Amigos,

Ontem por volta das 11 horas, fiz algumas alterações na base de dados… inclusão de dados… alteração… etc… etc…

Por volta das 12, tirei alguns relatórios e tudo ok…

Depois, acho que as 13… e hoje pela manhã… ao acessar a base, vi que tudo que fiz havia sumido… nada estava lá.

Alguem pode me dar uma ajudinha????

Vejam o ALERT_XE

Mon May 28 10:20:30 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 2214K exceeds notification threshold (2048K)
Details in trace file d:oraclexeapporacleadminxeudumpxe_ora_1836.trc
KGL object name :XDB.XD7DujEWKdQzCT1MWnFJ6WfA==

Dump file d:oraclexeapporacleadminxebdumpalert_xe.log
Tue May 29 11:02:59 2007
ORACLE V10.2.0.1.0 – Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 – type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:346M/510M, Ph+PgF:1111M/1249M, VA:1945M/2047M
Tue May 29 11:02:59 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 = 62914560
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 146800640
control_files = D:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 71303168
compatible = 10.2.0.1.0
db_recovery_file_dest = D:oraclexeapporacleflash_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:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = D:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = D:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = D:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41943040
PMON started with pid=2, OS id=1120
PSP0 started with pid=3, OS id=1412
MMAN started with pid=4, OS id=1868
DBW0 started with pid=5, OS id=1332
LGWR started with pid=6, OS id=884
CKPT started with pid=7, OS id=1060
SMON started with pid=8, OS id=1368
RECO started with pid=9, OS id=1396
CJQ0 started with pid=10, OS id=1436
MMON started with pid=11, OS id=480
Tue May 29 11:03:00 2007
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
MMNL started with pid=12, OS id=312
Tue May 29 11:03:00 2007
starting up 4 shared server(s) …
Oracle Data Guard is not available in this edition of Oracle.
Tue May 29 11:03:01 2007
alter database mount exclusive
Tue May 29 11:03:05 2007
Setting recovery target incarnation to 2
Tue May 29 11:03:06 2007
Successful mount of redo thread 1, with mount id 2504981285
Tue May 29 11:03:06 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue May 29 11:03:06 2007
alter database open
Tue May 29 11:03:06 2007
Beginning crash recovery of 1 threads
Tue May 29 11:03:06 2007
Started redo scan
Tue May 29 11:03:07 2007
Completed redo scan
1060 redo blocks read, 250 data blocks need recovery
Tue May 29 11:03:07 2007
Started redo application at
Thread 1: logseq 14, block 25919
Tue May 29 11:03:08 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
Mem# 0 errs 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_34P3O0KL_.LOG
Tue May 29 11:03:08 2007
Completed redo application
Tue May 29 11:03:08 2007
Completed crash recovery at
Thread 1: logseq 14, block 26979, scn 602566
250 data blocks read, 250 data blocks written, 1060 redo blocks read
Tue May 29 11:03:09 2007
Thread 1 advanced to log sequence 15
Thread 1 opened at log sequence 15
Current log# 2 seq# 15 mem# 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_34P3O389_.LOG
Successful open of redo thread 1
Tue May 29 11:03:10 2007
SMON: enabling cache recovery
Tue May 29 11:03:14 2007
Successfully onlined Undo Tablespace 1.
Tue May 29 11:03:14 2007
SMON: enabling tx recovery
Tue May 29 11:03:14 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=3412
Tue May 29 11:03:27 2007
Completed: alter database open
Tue May 29 11:03:35 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.
Dump file d:oraclexeapporacleadminxebdumpalert_xe.log
Tue May 29 12:14:30 2007
ORACLE V10.2.0.1.0 – Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 – type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:348M/510M, Ph+PgF:1113M/1249M, VA:1945M/2047M
Tue May 29 12:14:30 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 = 62914560
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 146800640
control_files = D:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 71303168
compatible = 10.2.0.1.0
db_recovery_file_dest = D:oraclexeapporacleflash_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:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = D:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = D:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = D:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41943040
PMON started with pid=2, OS id=1148
PSP0 started with pid=3, OS id=1284
MMAN started with pid=4, OS id=1788
DBW0 started with pid=5, OS id=1820
LGWR started with pid=6, OS id=612
CKPT started with pid=7, OS id=1036
SMON started with pid=8, OS id=1308
RECO started with pid=9, OS id=1500
CJQ0 started with pid=10, OS id=1656
MMON started with pid=11, OS id=1836
Tue May 29 12:14:32 2007
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
MMNL started with pid=12, OS id=224
Tue May 29 12:14:32 2007
starting up 4 shared server(s) …
Oracle Data Guard is not available in this edition of Oracle.
Tue May 29 12:14:33 2007
alter database mount exclusive
Tue May 29 12:14:37 2007
Setting recovery target incarnation to 2
Tue May 29 12:14:37 2007
Successful mount of redo thread 1, with mount id 2504993001
Tue May 29 12:14:37 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue May 29 12:14:37 2007
alter database open
Tue May 29 12:14:38 2007
Beginning crash recovery of 1 threads
Tue May 29 12:14:38 2007
Started redo scan
Tue May 29 12:14:39 2007
Completed redo scan
78 redo blocks read, 31 data blocks need recovery
Tue May 29 12:14:39 2007
Started redo application at
Thread 1: logseq 15, block 1526
Tue May 29 12:14:39 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0
Mem# 0 errs 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_34P3O389_.LOG
Tue May 29 12:14:39 2007
Completed redo application
Tue May 29 12:14:39 2007
Completed crash recovery at
Thread 1: logseq 15, block 1604, scn 624300
31 data blocks read, 31 data blocks written, 78 redo blocks read
Tue May 29 12:14:41 2007
Thread 1 advanced to log sequence 16
Thread 1 opened at log sequence 16
Current log# 1 seq# 16 mem# 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_34P3O0KL_.LOG
Successful open of redo thread 1
Tue May 29 12:14:41 2007
SMON: enabling cache recovery
Tue May 29 12:14:47 2007
Successfully onlined Undo Tablespace 1.
Tue May 29 12:14:47 2007
SMON: enabling tx recovery
Tue May 29 12:14:47 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=3792
Tue May 29 12:15:03 2007
Completed: alter database open
Tue May 29 12:15:07 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.
Dump file d:oraclexeapporacleadminxebdumpalert_xe.log
Wed May 30 09:06:18 2007
ORACLE V10.2.0.1.0 – Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 – type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:347M/510M, Ph+PgF:1112M/1249M, VA:1945M/2047M
Wed May 30 09:06:18 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 = 62914560
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:ORACLEXEAPPORACLEPRODUCT10.2.0SERVERDBSSPFILEXE.ORA
sga_target = 146800640
control_files = D:ORACLEXEORADATAXECONTROL.DBF
__db_cache_size = 71303168
compatible = 10.2.0.1.0
db_recovery_file_dest = D:oraclexeapporacleflash_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:ORACLEXEAPPORACLEADMINXEADUMP
background_dump_dest = D:ORACLEXEAPPORACLEADMINXEBDUMP
user_dump_dest = D:ORACLEXEAPPORACLEADMINXEUDUMP
core_dump_dest = D:ORACLEXEAPPORACLEADMINXECDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 41943040
PMON started with pid=2, OS id=1168
PSP0 started with pid=3, OS id=1360
MMAN started with pid=4, OS id=1820
DBW0 started with pid=5, OS id=236
LGWR started with pid=6, OS id=824
CKPT started with pid=7, OS id=1064
SMON started with pid=8, OS id=1352
RECO started with pid=9, OS id=1392
CJQ0 started with pid=10, OS id=1672
MMON started with pid=11, OS id=1640
Wed May 30 09:06:20 2007
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
MMNL started with pid=12, OS id=536
Wed May 30 09:06:20 2007
starting up 4 shared server(s) …
Oracle Data Guard is not available in this edition of Oracle.
Wed May 30 09:06:21 2007
alter database mount exclusive
Wed May 30 09:06:25 2007
Setting recovery target incarnation to 2
Wed May 30 09:06:25 2007
Successful mount of redo thread 1, with mount id 2505083469
Wed May 30 09:06:25 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed May 30 09:06:25 2007
alter database open
Wed May 30 09:06:26 2007
Beginning crash recovery of 1 threads
Wed May 30 09:06:26 2007
Started redo scan
Wed May 30 09:06:27 2007
Completed redo scan
1123 redo blocks read, 269 data blocks need recovery
Wed May 30 09:06:27 2007
Started redo application at
Thread 1: logseq 16, block 31803
Wed May 30 09:06:28 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 16 Reading mem 0
Mem# 0 errs 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_1_34P3O0KL_.LOG
Wed May 30 09:06:28 2007
Completed redo application
Wed May 30 09:06:28 2007
Completed crash recovery at
Thread 1: logseq 16, block 32926, scn 651204
269 data blocks read, 269 data blocks written, 1123 redo blocks read
Wed May 30 09:06:30 2007
Thread 1 advanced to log sequence 17
Thread 1 opened at log sequence 17
Current log# 2 seq# 17 mem# 0: D:ORACLEXEAPPORACLEFLASH_RECOVERY_AREAXEONLINELOGO1_MF_2_34P3O389_.LOG
Successful open of redo thread 1
Wed May 30 09:06:30 2007
SMON: enabling cache recovery
Wed May 30 09:06:36 2007
Successfully onlined Undo Tablespace 1.
Wed May 30 09:06:36 2007
SMON: enabling tx recovery
Wed May 30 09:06:36 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=3336
Wed May 30 09:06:47 2007
Completed: alter database open
Wed May 30 09:06:53 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.

[Anônimo]

Complementando…

Oracle 10 Xe

[Marcio68AlmeidaParticipante]

algo me dize que o flash back recover foi acionado…

[Anônimo]

[quote=”Marcio68Almeida”:1mrxfvqn]algo me dize que o flash back recover foi acionado…[/quote]

Mas porque acionou??? quem acionou???
Isso não poderia ter acontecido… e os dados que foram perdidos???

[Marcio68AlmeidaParticipante]

Bom…
Quem acionou ??? Qualquer um com direitos de DBA.
Por que acionou ??? Vai saber o que se passa na cabeça de cada um…
Uma vez perdidos, não havendo backup, já era…

Mas…
Como disse, é uma suspeita, não uma certeza…

[Anônimo]

Marcio… perguntei isso pois o único que tem privilégios de DBA sou eu.
E inclusive quem operou com essa base nesses dias foi só eu mesmo.

[Autor]

Posts