Skip to main content

ORA-00392: log 4 of thread 2 is being cleared, operation not allowed

Error ORA-00312 and ORA-00312

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 4 of thread 2 is being cleared, operation not allowed
ORA-00312: online log 4 thread 2: '+DB1_RECO/prod12/onlinelog/log04a.log'
ORA-003122: '+DB1_RECO/prod12/onlinelog/log04b.log'

SQL> select group#,thread#,status from v$log;
    GROUP#    THREAD# STATUS
---------- ---------- ----------------
         5          1 CLEARING_CURRENT
         6          1 CLEARING
         3          2 CLEARING
         4          2 CLEARING_CURRENT

SQL>  alter database clear unarchived logfile group 5;
 alter database clear unarchived logfile group 5
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+DB1_RECO/prod12/onlinelog/log05a.log'
ORA-15001: diskgroup "DB1_RECO" does not exist or is not mounted
ORA-15001: diskgroup "DB1_RECO" does not exist or is not mounted

SQL> alter database clear logfile group 5;
alter database clear logfile group 5
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+DB1_RECO/prod12/onlinelog/log05a.log'
ORA-15001: diskgroup "DB1_RECO" does not exist or is not mounted
ORA-15001: diskgroup "DB1_RECO" does not exist or is not mounted


Above error because still logfile  ponting to old logfile location so rename the logfile in mount state.
SQL> select group#,status,member from v$logfile;
    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
         6
+DB1_RECO/prod12/onlinelog/log06a.log

use spool file with below query to rename all logfiles in DB
select 'alter database rename file '''||member||''' to '||'''+DATA/oradata/testr12/'|| REGEXP_REPLACE(''||member||'','.*/') ||''';' from v$logfile;


SQL> select group#,thread#,status from v$log;
    GROUP#    THREAD# STATUS
---------- ---------- ----------------
         5          1 CLEARING_CURRENT
         6          1 CLEARING
         3          2 CLEARING
         4          2 CLEARING_CURRENT
SQL> alter database clear unarchived logfile group 5;
Database altered.
SQL>  alter database clear unarchived logfile group 4;
Database altered.
SQL>  select group#,thread#,status from v$log;
    GROUP#    THREAD# STATUS
---------- ---------- ----------------
         5          1 CURRENT
         6          1 CLEARING
         3          2 CLEARING
         4          2 CURRENT

SQL>  alter database open resetlogs;
Database altered.
SQL>


 

Comments

Popular posts from this blog

EBS R12 “Unable to Authenticate Session”

Oracle E-Business Suite environment with IE8 and higher, When  cloning the EBS envitorment or you are logging out from your DEV Instance and want to login to  PROD-Instance it happens “Unable to authenticate session” Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging (shown below) 1)  Start -> Program Files 2)  Right click on the Internet Explorer icon and select Properties 3)  Add -nomerge to the end of the link in the Target field i.e. “C:\Program Files\Internet Explorer\ iexplore.exe ” -noframemerging 4)  Click the OK button to close the window 5) Stop all Browser sessions. 6) Start a new Browser session and logon to the Instance

19c ORACLE HOME Cloning -Linux/Solaris

  Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone the Oracle home, the new Oracle home has the patch updates which is already applied on oracle home. Steps to clone an Oracle home step 1 : Stop Services Stop all processes related to the Oracle home. Step 2 : Create a ZIP or TAR file with the Oracle home (/u01/app/oracle/product/19.0.0/dbhome_1)    Use ROOT user for ZIP and UNZIP  # zip -r dbhome_1.zip /u01/app/oracle/product/19.0.0/dbhome_1 TAR option: # tar -cvf dbhome_1.tar /u01/app/oracle/product/19.0.0/dbhome_1 Step 3: s cp zip/tar to target s...

EBS R12.2.4 AutoConfig could not successfully execute the following scripts followed by error "txkGenADOPWrapper.pl INSTE8_APPLY 1"

issue:txkGenADOPWrapper.pl    INSTE8_APPLY       1 WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:       <filename>  <phase>  <return code where appropriate>   [APPLY PHASE]   AutoConfig could not successfully execute the following scripts:     Directory: /u01/applprod/fs2/FMW_Home/webtier/perl/bin/perl -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/5.10.0 -I /u01/applprod/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /u01/applprod/fs2/EBSapps/appl/au/12.0.0/perl -I /u01/applprod/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/applprod/fs2/inst/apps/PRODDB_epc-apps12-node41v/admin/install       txkGenADOPWrapper.pl    ...