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

EBS Standby Role Tranistion using standby database and standby application Tier

 Role Transitions A database can operate in either a primary or standby role - these roles are mutually exclusive. Oracle Data Guard enables you to change these roles dynamically by issuing SQL commands, and supports the following transitions: Switchover Allows the primary database to switch roles with one of its standby databases. There is no data loss during a switchover. After a switchover, each database continues to participate in the Oracle Data Guard configuration with its new role. Failover Changes a standby database to the primary role in response to a primary database failure. The following role transitions are discussed: 6.1 Performing a Switchover 6.2 Performing a Failover 6.3 Performing a Switchback to the Primary Following A Switchover/Failover Each of these three transitions requires some application configuration to be performed. Most of the application configuration step...

adgrants issue with 19c PDB database

 adgrant - system.fnd_oracle_userid ORA-06550: line 1094, column 17 SP2-0625: Error printing variable "result_set" adgrants issue with 19c PDB database  Connect to a multitenant 19c database and follow below steps to resolve ORA error 1- source the cdb env file  2-set the  ORACLE_PDB_SID=<PDB_NAME>   3- connect as  sqlplus / as sysdba 4- go to location of adgrant and execute cd /u01/app/oracle/product/19.0.0/dbhome_1/appsutil/sql    SQL>  @adgrants.sql APPS Note: ignore warnings during adgrant session a d.plsql.ad_zd_sys.GIVE_PRIVILEGE