OraFAQ Forum: Data Guard » How to clear this Data Guard alert message in EM?

Home » Server Options » Data Guard » How to clear this Data Guard alert message in EM?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to clear this Data Guard alert message in EM? [message #210886]

Fri, 22 December 2006 23:27

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 1407 times)

Report message to a moderator

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

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

backup and remove any dr*.dat files from O_H/dbs directory from primary.

Sandeep

Report message to a moderator

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

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 1310 times)

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Physical standby failover
Next Topic:	decrease physical standby failover time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 06:20:37 CST 2024