Re: Datafile Rename Problem

If you're moving all of your files, bring the DB up into mount stage. Then perform your renames, then open. Your welcome for doing your homework.

Pete's

dishonty_at_ucmail.uc.edu (Yvonne Dishon) wrote in message news:<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 Mon Apr 07 2003 - 16:26:21 CEST