In Rman i have restored the whole database successfully. whenever and Rename the all redo logs then it shows this issues. and i again create 2,3 redologs newly create. but i can't drop redolog01 and my database is in mount Stage..., if run this query alter system switch logfile..., it shows the database is not open THEN WHAT WILL DO
SQL> SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
3 YES UNUSED
2 YES UNUSED
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUp 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUp 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance cent (thread 1)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/cent/redo01.log'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery