Home » Server Options » Data Guard » How to clear this Data Guard alert message in EM?
How to clear this Data Guard alert message in EM? [message #210886] Fri, 22 December 2006 23:27 Go to next message
wxfjordan
Messages: 92
Registered: December 2006
Member
Please see the Data Guard alert message in the upload picture, it is my oracle database status.

I ever built this server as primary database in Data Guard environement.

And then I have canceled the standby database long time ago.

Initialized parameter file as following:

primary1.__db_cache_size=184549376
primary1.__java_pool_size=4194304
primary1.__large_pool_size=4194304
primary1.__shared_pool_size=92274688
primary1.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0/admin/primary1/adump'
*.background_dump_dest='C:\oracle\product\10.2.0/admin/primary1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0\oradata\primary1\control01.ctl','C:\oracle\product\10.2.0\oradata\primary1\control02.ctl',' C:\oracle\product\10.2.0\oradata\primary1\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0/admin/primary1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='primary1'
*.db_recovery_file_dest='C:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=primary1XDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=C:\oracle\product\10.2.0\archivelog'
*.open_cursors=300
*.pga_aggregate_target=95420416
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=287309824
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0/admin/primary1/udump'

and the listener.ora file as following:

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = webtest2)(PORT = 1521))
)
)


Why still display Data Guard alert message in EM?

How to clear this Data Guard alert message in EM?


Give me some directions

Thanks

Jordan
  • Attachment: dataguard.JPG
    (Size: 191.16KB, Downloaded 1127 times)
Re: How to clear this Data Guard alert message in EM? [message #210928 is a reply to message #210886] Sat, 23 December 2006 07:20 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
backup and remove any dr*.dat files from O_H/dbs directory from primary.

Sandeep
Re: How to clear this Data Guard alert message in EM? [message #210948 is a reply to message #210886] Sun, 24 December 2006 01:05 Go to previous messageGo to next message
wxfjordan
Messages: 92
Registered: December 2006
Member

But there are two file pfile and spfile in directory oracle_home\dbs.

And now the EM can't be startuped.

I found a file in directory oracle_home\database.

The file is core_primary1_pid_2028_tid_xC0_2006_12_24_14_14_46.log
and the content is

An Unhandled Exception Occurred,
Exception Number : 0xc0000005
Exception Address : 0x60af2cc4


Please see the attachment picture.

( Wow... The problem will become bigger. )


Thanks
  • Attachment: emproblem.JPG
    (Size: 91.20KB, Downloaded 1036 times)
Re: How to clear this Data Guard alert message in EM? [message #210967 is a reply to message #210886] Sun, 24 December 2006 06:49 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
correct. on NT it would be O_H\database

Open a tar with oracle to see if they can figure out exact problem in your environment.

Sandeep
Previous Topic: Physical standby failover
Next Topic: decrease physical standby failover time
Goto Forum:
  


Current Time: Thu Mar 28 03:46:33 CDT 2024