How to rename a redo logfile.
While Opening the database with resetlogs option post incomplete media recovery (Migrated database to another server), receiving the following error: SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00349: failure obtaining block size for '/oracle/app/oracle/oradata/ORCL/redo01.log' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 9 SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper], [0x080010003], [], [], [], [], [], [], [], [], [], [] SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2; ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2 * ERROR at line 1: ORA-00349: failure obtaining block size for '/oracle/app/oracle/oradata/ ORCL /redo02.log' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Ad...