ERROR ORA-00270: error creating archive log

[Former Member]

Hi all,

Configured DR between two sap systems and when i try tnsping it connects fine..

When i check stmt it returns the following error below

SQL> select status, Error from v$archive_dest where dest_id=2;

STATUS ERROR

-

---

-

---

ERROR ORA-00270: error creating archive log

How do i rectify this as i have read/write permission on target mount points and enough free space.

PRIMARY -- DB in rpimary is running on virtual host eccdb

epeccdb:oraeep 26> tnsping eep_prim.world

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 21-SEP-2011 19:46:55

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/EEP/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

)GLOBAL_NAME = EEP.WORLD)

OK (10 msec)

STANDBY

eccprddr:oraeep 1> tnsping eep_prim.world

TNS Ping Utility for HPUX: Version 10.2.0.2.0 - Production on 21-SEP-2011 19:42:01

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/oracle/EEP/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

)GLOBAL_NAME = EEP.WORLD)

OK (50 msec)

Thanks,

rahul

[Former Member]

It i permission problem with oraarch directory..mount point of oraarch is increaed to some extent and permisi changed to root root , therefore it couldn't write over there.

I have also tried to run rlogin command from

as follows but did not connect.I could ping ipadress from target to standby not hostname.

epeccdb:oraeep 3> rlogin oraeep@eccprddr_192.168.30.23

rcmd_af: oraeep@eccprddr_192.168.30.23: Unknown host

epeccdb:oraeep 4> ping eccprddr

ping: Command not found.

epeccdb:oraeep 5> rlogin oraeep@192.168.30.23

rcmd_af: oraeep@192.168.30.23: Unknown host

[Former Member]

Hi Rahul,

as follows but did not connect.I could ping ipadress from target to standby not hostname.
epeccdb:oraeep 3> rlogin oraeep@eccprddr_192.168.30.23

Assuming that there is no connectivity issues between 2 hosts (network and ports)...

First make sure that both server has configured with host entries for each other in "/etc/hosts" file.

You are using wrong hostname for DR server in rlogin command.

Seems you put both hostname and IP address...

Try putting either hostname or IP address...

For example.

epeccdb:oraeep 3> rlogin oraeep@192.168.30.23

OR

epeccdb:oraeep 3> rlogin oraeep@eccprddr

You will be connected to DR server.

PING command will work under ROOT user only not ora<sid> user.

Regards.

Rajesh Narkhede

[Former Member]

Hi,

How do i rectify this as i have read/write permission on target mount points and enough free space.

You can test by log in to the DR server from Primary server using "rlogin" as ora<sid> user.

Just do as follow:

From Primary Server.

# rlogin ora<sid>@drserver_ip
#drserver:ora<sid>> cd /path/to/oraarch_directory
# touch test.txt

If you able to create file then there is no permission issue.

You can check free space using "bdf" command.

Again Check the archive_dest_2 path in parameter files.

Regards.

Rajesh Narkhede

[Former Member]

Hi,

Check alert<SID>.log under /oracle/<SID>/saptrace/background on both systems

Best regards,

Orkun Gedik