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>


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

Original text of this message