nagarjuna, thank you for your reply... but listen to what I have to say...

the db is in archivelog mode with automatic archiving for the past 6 months. ...got this error all of a sudden...only now..