Skip to content
April 4, 2013 / doganay

ORA-00604: error occurred at recursive SQL level when alter database register logfile


Problem:

SQL> alter database register logfile '/myarcdir/archMYDB_1_94603_757174333.arc';
alter database register or replace logfile '/myarcdir/archMYDB_1_94603_757174333.arc'
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level


Solution:

ALTER DATABASE REGISTER OR REPLACE LOGFILE '/arc_path/arc_file';

if it fails, run this:

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/arc_path/arc_file';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: