I have a close db backup. no redo logs.
Originally, the redo logs were located in /dbms/oracle/LSC67/redo, I need to recover the database in /dbms/oracle/LSC66/redo
Problem 1 : alter database rename file ... to .. does not work because file does not exist
SQL> startup force quiet mount
ORACLE instance started.
Database mounted.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/dbms/oracle/LSC67/redo/redo01aLSC67.dbf
/dbms/oracle/LSC67/redo/redo01bLSC67.dbf
/dbms/oracle/LSC67/redo/redo06aLSC67.dbf
/dbms/oracle/LSC67/redo/redo06bLSC67.dbf
SQL> alter database rename file '/dbms/oracle/LSC67/redo/redo01aLSC67.dbf' to '/dbms/oracle/LSC66/redo/redo01aLSC66.dbf';
alter database rename file '/dbms/oracle/LSC67/redo/redo01aLSC67.dbf' to '/dbms/oracle/LSC66/redo/redo01aLSC66.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01512: error renaming log file /dbms/oracle/LSC67/redo/redo01aLSC67.dbf -
new file /dbms/oracle/LSC66/redo/redo01aLSC66.dbf not found
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Problem 2: open resetlogs will not work, because /dbms/oracle/LSC67 does not exists
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/dbms/oracle/LSC67/redo/redo01aLSC67.dbf'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Is it possible to do that WITHOUT create controlfile ?
Thanks for your ideas :-)
Laurent