OraFAQ Forum: Data Guard » ORA-00270 error creating archive log

Home » Server Options » Data Guard » ORA-00270 error creating archive log (oracle 10g r2 RHEL4)

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

ORA-00270 error creating archive log [message #383033]

Tue, 27 January 2009 00:36

kashi24
Messages: 10
Registered: January 2009
Location: pakistan

Junior Member

how can we resolve this error
on data guard

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383035 is a reply to message #383033]

Tue, 27 January 2009 00:37

kashi24
Messages: 10
Registered: January 2009
Location: pakistan

Junior Member

Alter system set Log_archive_dest_state_2=ENABLE scope=both;

System altered.

SQL> Archive Log List;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/backup
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 2
SQL>
SQL> Alter system switch logfile;

System altered.

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

STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-00270: error creating archive log

this is the whole secnario

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383038 is a reply to message #383033]

Tue, 27 January 2009 00:43

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00270: error creating archive log %s
 *Cause:  An error was encountered when either creating or opening
          the destination file for archiving.
 *Action: Check that the archive destination is valid and that there
          is sufficient space on the destination device.

Regards
Michel

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383039 is a reply to message #383033]

Tue, 27 January 2009 00:45

kashi24
Messages: 10
Registered: January 2009
Location: pakistan

Junior Member

how can i check wetherthe destination is valid and there is enough disk sapce

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383041 is a reply to message #383039]

Tue, 27 January 2009 00:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ls -l
df -k
...

Regards
Michel

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383042 is a reply to message #383033]

Tue, 27 January 2009 00:55

kashi24
Messages: 10
Registered: January 2009
Location: pakistan

Junior Member

on standby it returns
df -kh
Filesystem Size Used Avail Use% Mounted on
/dev/hda2 63G 8.4G 51G 15% /
/dev/hda1 99M 8.5M 86M 9% /boot
none 252M 0 252M 0% /dev/shm
/dev/hda3 9.7G 2.4G 6.8G 27% /oracle

an on primary
df -kh
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 7.6G 6.7G 576M 93% /
/dev/hda1 190M 144M 37M 80% /boot
none 252M 0 252M 0% /dev/shm
/dev/hda2 9.7G 2.9G 6.3G 32% /oracle

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383046 is a reply to message #383033]

Tue, 27 January 2009 01:26

kashi24
Messages: 10
Registered: January 2009
Location: pakistan

Junior Member

it found the solution the stanby db was in mount stage it was not open thats why it is returning this error

Report message to a moderator

Re: ORA-00270 error creating archive log [message #383047 is a reply to message #383046]

Tue, 27 January 2009 01:32

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If the standby database is open then it is no more a standby database (above all if it is open in read/write mode).

Regards
Michel

Report message to a moderator

Previous Topic:	Deletion oft Archive log on standby database
Next Topic:	performing switch over

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:40:48 CST 2025