Oracle Errors , ORA-

ORA-00270: error creating archive log

ARC1: FAL archive, error 270 creating remote archivelog file '<tns of dr>'
 
This error occurs when there is some problem in reaching of archived redo logs to the destination i.e DR server
Check whether valid directory is specified and there is enough space for the new archived to get copied to
 
Additional Info :
 
RFS process on the standby database server is used to received the archived redo log from primary database
 
__________________________________________________________________________________________________________________ 
 
 
ORA-00054: resource busy and acquire with NOWAIT specified
 
, this meand someone has acquired  lock on the table,
TRUNCATE is a DDL and required exclusive lock  on the table, since someone is having
shared lock on the table it is not able to acquire exclusive lock on the table to perform its
activity.
 
In short some session is performing DML activity, due to which you cannot perform truncate DDL
activity
 
 
 
Comments