Oracle Database Discussions

Hi,

I am trying to duplicate a database using a bmc tool. All the datafiles and control files are restored and the database is in mount state.

When I try open reset logs, I am getting the below error.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 3 thread 1: '/u03/oradata/pricperf/redo03.log'

And I tried clearing the log and got the below error.

SQL> alter database clear logfile group 3;
alter database clear logfile group 3
*
ERROR at line 1:
ORA-00336: log file size 200 blocks is less than minimum 8192 blocks

So I tried dropping the logfile and recreate it with a bigger size and got the below error.

SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance pricperf (thread 1) - cannot drop
ORA-00312: online log 3 thread 1: '/u03/oradata/pricperf/redo03.log'

How can we resolve this, the db is in mount state and db version is 11.2.0.2 and OS is AIX 6.1

Current log file status as below

SQL> select group#, status from v$log;

GROUP# STATUS
---------- ----------------
1 UNUSED
3 CLEARING_CURRENT
2 UNUSED