Dados sumiram da base.

[Muricy 0]

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_XEMon May 28 10:20:30 2007Memory Notification: Library Cache Object loaded into SGAHeap size 2214K exceeds notification threshold (2048K)Details in trace file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_1836.trcKGL object name :XDB.XD7DujEWKdQzCT1MWnFJ6WfA== Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.logTue May 29 11:02:59 2007ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Windows XP Version V5.1 Service Pack 2CPU : 1 - type 586Process Affinity : 0x00000000Memory (Avail/Total): Ph:346M/510M, Ph+PgF:1111M/1249M, VA:1945M/2047MTue May 29 11:02:59 2007Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on. IMODE=BRILAT =10LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting 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:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA sga_target = 146800640 control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF __db_cache_size = 71303168 compatible = 10.2.0.1.0 db_recovery_file_dest = D:\oraclexe\app\oracle\flash_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:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP db_name = XE open_cursors = 300 os_authent_prefix = pga_aggregate_target = 41943040PMON started with pid=2, OS id=1120PSP0 started with pid=3, OS id=1412MMAN started with pid=4, OS id=1868DBW0 started with pid=5, OS id=1332LGWR started with pid=6, OS id=884CKPT started with pid=7, OS id=1060SMON started with pid=8, OS id=1368RECO started with pid=9, OS id=1396CJQ0 started with pid=10, OS id=1436MMON started with pid=11, OS id=480Tue May 29 11:03:00 2007starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...MMNL started with pid=12, OS id=312Tue May 29 11:03:00 2007starting up 4 shared server(s) ...Oracle Data Guard is not available in this edition of Oracle.Tue May 29 11:03:01 2007alter database mount exclusiveTue May 29 11:03:05 2007Setting recovery target incarnation to 2Tue May 29 11:03:06 2007Successful mount of redo thread 1, with mount id 2504981285Tue May 29 11:03:06 2007Database mounted in Exclusive ModeCompleted: alter database mount exclusiveTue May 29 11:03:06 2007alter database openTue May 29 11:03:06 2007Beginning crash recovery of 1 threadsTue May 29 11:03:06 2007Started redo scanTue May 29 11:03:07 2007Completed redo scan 1060 redo blocks read, 250 data blocks need recoveryTue May 29 11:03:07 2007Started redo application at Thread 1: logseq 14, block 25919Tue May 29 11:03:08 2007Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0 Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_34P3O0KL_.LOGTue May 29 11:03:08 2007Completed redo applicationTue May 29 11:03:08 2007Completed crash recovery at Thread 1: logseq 14, block 26979, scn 602566 250 data blocks read, 250 data blocks written, 1060 redo blocks readTue May 29 11:03:09 2007Thread 1 advanced to log sequence 15Thread 1 opened at log sequence 15 Current log# 2 seq# 15 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_34P3O389_.LOGSuccessful open of redo thread 1Tue May 29 11:03:10 2007SMON: enabling cache recoveryTue May 29 11:03:14 2007Successfully onlined Undo Tablespace 1.Tue May 29 11:03:14 2007SMON: enabling tx recoveryTue May 29 11:03:14 2007Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=19, OS id=3412Tue May 29 11:03:27 2007Completed: alter database openTue May 29 11:03:35 2007db_recovery_file_dest_size of 10240 MB is 0.98% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.logTue May 29 12:14:30 2007ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Windows XP Version V5.1 Service Pack 2CPU : 1 - type 586Process Affinity : 0x00000000Memory (Avail/Total): Ph:348M/510M, Ph+PgF:1113M/1249M, VA:1945M/2047MTue May 29 12:14:30 2007Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on. IMODE=BRILAT =10LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting 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:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA sga_target = 146800640 control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF __db_cache_size = 71303168 compatible = 10.2.0.1.0 db_recovery_file_dest = D:\oraclexe\app\oracle\flash_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:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP db_name = XE open_cursors = 300 os_authent_prefix = pga_aggregate_target = 41943040PMON started with pid=2, OS id=1148PSP0 started with pid=3, OS id=1284MMAN started with pid=4, OS id=1788DBW0 started with pid=5, OS id=1820LGWR started with pid=6, OS id=612CKPT started with pid=7, OS id=1036SMON started with pid=8, OS id=1308RECO started with pid=9, OS id=1500CJQ0 started with pid=10, OS id=1656MMON started with pid=11, OS id=1836Tue May 29 12:14:32 2007starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...MMNL started with pid=12, OS id=224Tue May 29 12:14:32 2007starting up 4 shared server(s) ...Oracle Data Guard is not available in this edition of Oracle.Tue May 29 12:14:33 2007alter database mount exclusiveTue May 29 12:14:37 2007Setting recovery target incarnation to 2Tue May 29 12:14:37 2007Successful mount of redo thread 1, with mount id 2504993001Tue May 29 12:14:37 2007Database mounted in Exclusive ModeCompleted: alter database mount exclusiveTue May 29 12:14:37 2007alter database openTue May 29 12:14:38 2007Beginning crash recovery of 1 threadsTue May 29 12:14:38 2007Started redo scanTue May 29 12:14:39 2007Completed redo scan 78 redo blocks read, 31 data blocks need recoveryTue May 29 12:14:39 2007Started redo application at Thread 1: logseq 15, block 1526Tue May 29 12:14:39 2007Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0 Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_34P3O389_.LOGTue May 29 12:14:39 2007Completed redo applicationTue May 29 12:14:39 2007Completed crash recovery at Thread 1: logseq 15, block 1604, scn 624300 31 data blocks read, 31 data blocks written, 78 redo blocks readTue May 29 12:14:41 2007Thread 1 advanced to log sequence 16Thread 1 opened at log sequence 16 Current log# 1 seq# 16 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_34P3O0KL_.LOGSuccessful open of redo thread 1Tue May 29 12:14:41 2007SMON: enabling cache recoveryTue May 29 12:14:47 2007Successfully onlined Undo Tablespace 1.Tue May 29 12:14:47 2007SMON: enabling tx recoveryTue May 29 12:14:47 2007Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=19, OS id=3792Tue May 29 12:15:03 2007Completed: alter database openTue May 29 12:15:07 2007db_recovery_file_dest_size of 10240 MB is 0.98% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.logWed May 30 09:06:18 2007ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Windows XP Version V5.1 Service Pack 2CPU : 1 - type 586Process Affinity : 0x00000000Memory (Avail/Total): Ph:347M/510M, Ph+PgF:1112M/1249M, VA:1945M/2047MWed May 30 09:06:18 2007Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on. IMODE=BRILAT =10LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting 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:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA sga_target = 146800640 control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF __db_cache_size = 71303168 compatible = 10.2.0.1.0 db_recovery_file_dest = D:\oraclexe\app\oracle\flash_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:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP db_name = XE open_cursors = 300 os_authent_prefix = pga_aggregate_target = 41943040PMON started with pid=2, OS id=1168PSP0 started with pid=3, OS id=1360MMAN started with pid=4, OS id=1820DBW0 started with pid=5, OS id=236LGWR started with pid=6, OS id=824CKPT started with pid=7, OS id=1064SMON started with pid=8, OS id=1352RECO started with pid=9, OS id=1392CJQ0 started with pid=10, OS id=1672MMON started with pid=11, OS id=1640Wed May 30 09:06:20 2007starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...MMNL started with pid=12, OS id=536Wed May 30 09:06:20 2007starting up 4 shared server(s) ...Oracle Data Guard is not available in this edition of Oracle.Wed May 30 09:06:21 2007alter database mount exclusiveWed May 30 09:06:25 2007Setting recovery target incarnation to 2Wed May 30 09:06:25 2007Successful mount of redo thread 1, with mount id 2505083469Wed May 30 09:06:25 2007Database mounted in Exclusive ModeCompleted: alter database mount exclusiveWed May 30 09:06:25 2007alter database openWed May 30 09:06:26 2007Beginning crash recovery of 1 threadsWed May 30 09:06:26 2007Started redo scanWed May 30 09:06:27 2007Completed redo scan 1123 redo blocks read, 269 data blocks need recoveryWed May 30 09:06:27 2007Started redo application at Thread 1: logseq 16, block 31803Wed May 30 09:06:28 2007Recovery of Online Redo Log: Thread 1 Group 1 Seq 16 Reading mem 0 Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_34P3O0KL_.LOGWed May 30 09:06:28 2007Completed redo applicationWed May 30 09:06:28 2007Completed crash recovery at Thread 1: logseq 16, block 32926, scn 651204 269 data blocks read, 269 data blocks written, 1123 redo blocks readWed May 30 09:06:30 2007Thread 1 advanced to log sequence 17Thread 1 opened at log sequence 17 Current log# 2 seq# 17 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_34P3O389_.LOGSuccessful open of redo thread 1Wed May 30 09:06:30 2007SMON: enabling cache recoveryWed May 30 09:06:36 2007Successfully onlined Undo Tablespace 1.Wed May 30 09:06:36 2007SMON: enabling tx recoveryWed May 30 09:06:36 2007Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=19, OS id=3336Wed May 30 09:06:47 2007Completed: alter database openWed May 30 09:06:53 2007db_recovery_file_dest_size of 10240 MB is 0.98% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.

[alphamek 2]

O alert.log acima está editado, poste os eventos do banco de dados entre o dia 29 a partir das 13 até dia 30 as 9. Abraços,

[Muricy 0]

O alert.log acima está editado, poste os eventos do banco de dados entre o dia 29 a partir das 13 até dia 30 as 9. Abraços,

Segue o arquivo na integra...Notei que tem um espaço em branco... mas não foi nada editado.E o problema aconteceu no dia 29 para o dia 30.Obrigado!Mon May 28 07:56:45 2007Completed redo scan 1085 redo blocks read, 226 data blocks need recoveryMon May 28 07:56:45 2007Started redo application at Thread 1: logseq 13, block 6221Mon May 28 07:56:46 2007Recovery of Online Redo Log: Thread 1 Group 2 Seq 13 Reading mem 0 Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_34P3O389_.LOGMon May 28 07:56:46 2007Completed redo applicationMon May 28 07:56:46 2007Completed crash recovery at Thread 1: logseq 13, block 7306, scn 574946 226 data blocks read, 226 data blocks written, 1085 redo blocks readMon May 28 07:56:48 2007Thread 1 advanced to log sequence 14Thread 1 opened at log sequence 14 Current log# 1 seq# 14 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_34P3O0KL_.LOGSuccessful open of redo thread 1Mon May 28 07:56:48 2007SMON: enabling cache recoveryMon May 28 07:56:52 2007Successfully onlined Undo Tablespace 1.Mon May 28 07:56:52 2007SMON: enabling tx recoveryMon May 28 07:56:52 2007Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=19, OS id=3776Mon May 28 07:57:02 2007Completed: alter database openMon May 28 07:57:07 2007db_recovery_file_dest_size of 10240 MB is 0.98% used. This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Mon May 28 10:20:28 2007Memory Notification: Library Cache Object loaded into SGAHeap size 2341K exceeds notification threshold (2048K)KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== Mon May 28 10:20:30 2007Memory Notification: Library Cache Object loaded into SGAHeap size 2214K exceeds notification threshold (2048K)Details in trace file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_1836.trcKGL object name :XDB.XD7DujEWKdQzCT1MWnFJ6WfA== Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.logTue May 29 11:02:59 2007ORACLE V10.2.0.1.0 - Production vsnsta=0vsnsql=14 vsnxtr=3Windows XP Version V5.1 Service Pack 2CPU : 1 - type 586Process Affinity : 0x00000000Memory (Avail/Total): Ph:346M/510M, Ph+PgF:1111M/1249M, VA:1945M/2047MTue May 29 11:02:59 2007Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 2Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DESTAutotune of undo retention is turned on. IMODE=BRILAT =10LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting 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:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA sga_target = 146800640 control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF __db_cache_size = 71303168 compatible = 10.2.0.1.0 db_recovery_file_dest = D:\oraclexe\app\oracle\flash_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:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP db_name = XE open_cursors = 300 os_authent_prefix = pga_aggregate_target = 41943040PMON started with pid=2, OS id=1120PSP0 started with pid=3, OS id=1412MMAN started with pid=4, OS id=1868