SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 11 of thread 2 is being cleared, operation not allowed ORA-00312: online log 11 thread 2: '/ORAREDO1/WINSDB/redo11_01.log' ORA-00312: online log 11 thread 2: '/ORAREDO2/WINSDB/redo11_02.log' SQL> select group#,thread#,status from v$log; GROUP# THREAD# STATUS ---------- ---------- ---------------- 6 1 CLEARING 5 1 CLEARING 10 2 CLEARING 11 2 CLEARING_CURRENT 9 2 CLEARING SQL> alter database clear unarchived logfile group 6; alter database clear unarchived logfile group 6 * ERROR at line 1: ORA-19502: write error on file "/ORADATA5/WINSREDO/redo06_1.log", block number 7731201 (block size=512) ORA-27072: File I/O error Additional information: 4 Additional information: 7731201 Additional information: 368128 SQL> select group#,status,member from v$logfile; GROUP# STATUS MEMBER ---------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 9 /ORAREDO1/WINSDB/redo09_01.log 9 /ORAREDO2/WINSDB/redo09_02.log 10 /ORAREDO1/WINSDB/redo10_01.log 10 /ORAREDO2/WINSDB/redo10_02.log 11 /ORAREDO1/WINSDB/redo11_01.log 11 /ORAREDO2/WINSDB/redo11_02.log 5 /ORAREDO1/WINSDB/redo05.log 6 /ORAREDO2/WINSDB/redo06.log 5 /ORADATA5/WINSREDO/redo05_1.log 6 /ORADATA5/WINSREDO/redo06_1.log 10 rows selected. SQL> alter database rename file '/ORAREDO1/WINSDB/redo09_01.log' to '/data/redo/redo09_01.log'; Database altered. SQL> 1 1* alter database rename file '/ORAREDO1/WINSDB/redo09_01.log' to '/data/redo/redo09_01.log' SQL> c/redo09_01.log/redo10_01.log 1* alter database rename file '/ORAREDO1/WINSDB/redo10_01.log' to '/data/redo/redo09_01.log' SQL> / alter database rename file '/ORAREDO1/WINSDB/redo10_01.log' to '/data/redo/redo09_01.log' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01523: cannot rename data file to '/data/redo/redo09_01.log' - file already part of database SQL> alter database rename file '/ORAREDO1/WINSDB/redo10_01.log 2 ' 3 to 4 alter database rename file '/data/redo//redo10_01.log' 5 ; alter database rename file '/data/redo//redo10_01.log' * ERROR at line 4: ORA-02236: invalid file name SQL> 4 4* alter database rename file '/data/redo//redo10_01.log' SQL> c///redo10_01.log//redo10_01.log 4* alter database rename file '/data/redo//redo10_01.log' SQL> alter database rename file '/ORAREDO1/WINSDB/redo10_01.log' to '/data/redo/redo10_01.log' 2 ; Database altered. SQL> alter database rename file '/ORAREDO1/WINSDB/redo11_01.log' to '/data/redo/redo11_01.log'; Database altered. SQL> alter database rename file '/ORAREDO1/WINSDB/redo05.log' to '/data/redo/redo05.log'; Database altered. SQL> commit; Commit complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database rename file '/ORAREDO2/WINSDB/redo09_02.log' to '/data/redo/redo09_02.log'; Database altered. SQL> alter database clear logfile group 9; Database altered. SQL> alter database rename file '/ORAREDO1/WINSDB/redo10_01.log' to '/data/redo/redo10_01.log'; alter database rename file '/ORAREDO1/WINSDB/redo10_01.log' to '/data/redo/redo10_01.log' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data file, or temporary file "/ORAREDO1/WINSDB/redo10_01.log" SQL> alter database rename file '/ORAREDO2/WINSDB/redo10_02.log' to '/data/redo/redo10_02.log'; Database altered. SQL> commit; Commit complete. SQL> alter database clear logfile group 10; Database altered. SQL> alter database rename file '/ORAREDO1/WINSDB/redo11_01.log' to '/data/redo/redo11_01.log'; alter database rename file '/ORAREDO1/WINSDB/redo11_01.log' to '/data/redo/redo11_01.log' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data file, or temporary file "/ORAREDO1/WINSDB/redo11_01.log" SQL> alter database rename file '/ORAREDO2/WINSDB/redo11_02.log' to '/data/redo/redo11_02.log'; Database altered. SQL> alter database clear logfile group 11; Database altered. SQL> commit; Commit complete. SQL> alter database rename file '/ORAREDO1/WINSDB/redo05.log' to '/data/redo/redo05.log'; alter database rename file '/ORAREDO1/WINSDB/redo05.log' to '/data/redo/redo05.log' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data file, or temporary file "/ORAREDO1/WINSDB/redo05.log" SQL> alter database rename file '/ORADATA5/WINSREDO/redo05_1.log' to '/data/redo/redo05_1.log'; Database altered. SQL> commit; Commit complete. SQL> alter database clear logfile group 5; Database altered. SQL> commit; Commit complete. SQL> alter database rename '/ORAREDO2/WINSDB/redo06.log' to /data/redo/redo06.log'; alter database rename '/ORAREDO2/WINSDB/redo06.log' to /data/redo/redo06.log' * ERROR at line 1: ORA-02231: missing or invalid option to ALTER DATABASE SQL> alter database rename file '/ORAREDO2/WINSDB/redo06.log' to /data/redo/redo06.log'; alter database rename file '/ORAREDO2/WINSDB/redo06.log' to /data/redo/redo06.log' * ERROR at line 1: ORA-02236: invalid file name SQL> alter database rename file '/ORAREDO2/WINSDB/redo06.log' to '/data/redo/redo06.log'; Database altered. SQL> commit; Commit complete. SQL> alter database rename file '/ORADATA5/WINSREDO/redo06_1.log' to '/data/redo/redo06_1.log'; Database altered. SQL> alter database clear logfile group 6; Database altered. SQL> commit; Commit complete. SQL> alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open resetlogs; Database altered. SQL> select status from v$instance; STATUS ------------ OPEN SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options