Saturday, February 7, 2009

RMAN-03009 ORA-19602 while taking rman backup

we may face errors like this while taking rman backup:

RMAN-03009: failure of backup command on ORA_DISK_1 channel
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Reason : if you want to take online backup using rman , you need to make sure your database is in archive log mode. otherwise you will receive this errors.

HOW TO CHECK WHETHER MY DATABASE IS IN ARCHIVE LOG MODE OR NOT

HOW TO ENABLE OR DISABLE ARCHIVE LOG MODE
thanks,
have a nice day...........

Nothing great was ever achieved without enthusiasm.
Ralph Waldo Emerson

No comments: