Datafile Rename Problem
From: Yvonne Dishon <dishonty_at_ucmail.uc.edu>
Date: 1 Apr 2003 11:46:33 -0800
Message-ID: <3ecbbd9d.0304011146.30e37132_at_posting.google.com>
Date: 1 Apr 2003 11:46:33 -0800
Message-ID: <3ecbbd9d.0304011146.30e37132_at_posting.google.com>
Using 8.17 on Red Hat 7.2
Shutdown immediate
alter database rename file 'fred/data.dbf' to 'newfred/data.dbf'
(moved all files)
alter database open
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/test-ora/data/system01.dbf'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors ORA-00322: log 2 of thread 1 is not current copy ORA-00312: online log 2 thread 1: '/test-ora/redologs/redo02.log'
Tried recover database until cancel then alter database open resetlogs
Still run into redolog issues.
Any suggestions would be appreciated. Received on Tue Apr 01 2003 - 21:46:33 CEST