Re: DATA GUARD CREATION ISSUE

Hi

i have created a physical standby database..


But the logs are not transmitted..



but i can able to ping one another



we are getting the following message


SQL> select message from v$dataguard_status where dest_id = 2;
 
MESSAGE
--------------------------------------------------------------------------------
LGWR: Error 12528 creating archivelog file 'std'


FAL[server, ARC1]: Error 12528 creating remote archivelog file 'std'
PING[ARC1]: Heartbeat failed to connect to standby 'std'. Error is 12514.
PING[ARC1]: Heartbeat failed to connect to standby 'std'. Error is 1031.


PING[ARC1]: Heartbeat failed to connect to standby 'std'. Error is 1031.

SQL> Select Status, Error

  2     from v$Archive_dest
  3    where dest_id=2;
 
STATUS
------------------------------------
ERROR
-----------------------------------------------------------------
ERROR
ORA-01031: insufficient privileges

On Fri, Oct 30, 2009 at 12:58 PM, Mohammed Mehraj Hussain <mhdmehraj@xxxxxxxxx> wrote:

Great...
Thankz its works ,,,


But i dint specify audit_dump_dest.

On Fri, Oct 30, 2009 at 12:53 PM, Ingrid Voigt <GiantPanda@xxxxxxx> wrote:

Hi,

something is wrong with your dump destinations:

You need to create all the directories on the standby side
before starting the instances. One (or more) of the dump
directories apparently does not exist.

Have you created
D:\oracle\product\10.2.0\admin\std\bdump
instead? Then you'll have to change it in the pfile.

I'm not sure if oracle works without an audit_dump_dest
or if you need to set that as well.


Regards
Ingrid

Hi listers ,

This is my pfile on the standby server..
Production db: PRD
standby db: STD

*.background_dump_dest='D:\oracle\product\10.2.0\admin\prd\bdump'

*.core_dump_dest='D:\oracle\product\10.2.0\admin\prd\cdump'

*.user_dump_dest='D:\oracle\product\10.2.0\admin\prd\udump'

SQL> startup nomount pfile='D:\oracle\product\10.2.0\oradata\std\initstd.ora';

ORA-02778: Name given *for* the log directory is invalid
|

Any idea what wrong with this?....

--
Regards,
H.Mohammed Mehraj Hussain
Oracle DBA,
Honeywell Technology Solutions,

--
//www.freelists.org/webpage/oracle-l

--
Regards,
H.Mohammed Mehraj Hussain
Oracle DBA,
Honeywell Technology Solutions,

--
Regards,
H.Mohammed Mehraj Hussain
Oracle DBA,
Honeywell Technology Solutions,

--
Regards,
H.Mohammed Mehraj Hussain
Oracle DBA,
Honeywell Technology Solutions,