Home » Server Options » Data Guard » ORA-00270 error creating archive log (oracle 10g r2 RHEL4)
ORA-00270 error creating archive log [message #383033] Tue, 27 January 2009 00:36 Go to next message
kashi24
Messages: 10
Registered: January 2009
Location: pakistan
Junior Member
how can we resolve this error
on data guard
Re: ORA-00270 error creating archive log [message #383035 is a reply to message #383033] Tue, 27 January 2009 00:37 Go to previous messageGo to next message
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
Re: ORA-00270 error creating archive log [message #383038 is a reply to message #383033] Tue, 27 January 2009 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-00270 error creating archive log [message #383039 is a reply to message #383033] Tue, 27 January 2009 00:45 Go to previous messageGo to next message
kashi24
Messages: 10
Registered: January 2009
Location: pakistan
Junior Member
how can i check wetherthe destination is valid and there is enough disk sapce
Re: ORA-00270 error creating archive log [message #383041 is a reply to message #383039] Tue, 27 January 2009 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ls -l
df -k
...

Regards
Michel
Re: ORA-00270 error creating archive log [message #383042 is a reply to message #383033] Tue, 27 January 2009 00:55 Go to previous messageGo to next message
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
Re: ORA-00270 error creating archive log [message #383046 is a reply to message #383033] Tue, 27 January 2009 01:26 Go to previous messageGo to next message
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
Re: ORA-00270 error creating archive log [message #383047 is a reply to message #383046] Tue, 27 January 2009 01:32 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Deletion oft Archive log on standby database
Next Topic: performing switch over
Goto Forum:
  


Current Time: Fri Mar 29 08:26:21 CDT 2024