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