-
Problem During Renaming
I have taken the coldbackup of a database from /u1/oracle/oradata/nebula/(all datafile), initnebula.ora,orapwnebula.ora,tnsnames.ora,listener.ora into a another test machine in /u2/backup.
now i m trying to up and restore this database in my test machine.
i have done the following in my test machine where already an instance was running :
setp #1 shutdown already running instance.
$svrmgrl
svrmgrl> connnect internal
svrmgrl> shutdown immediate
step #2
$vi /u2/backup/initnebula.ora
edit initnebula.ora
control_files = ("/u2/backup/control01.ctl", "/u2/backup/control02.ctl",
"/u2/backup/control03.ctl")
remote_login_passwordfile = shared
also i have added in the .profile
TNS_ADMIN=/u2/backup ; export TNS_ADMIN
so that oracle identify your testing database
listener.ora & tnsnames.ora
step #3
now i startup my testing database.
svrmgrl> startup mount pfile =/u2/backup/initnebula.ora
Database mounted.
step #4
At the time of renaming files, except two datafiles all files were renamed.
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/system01.dbf' to '/u2/backup/system01.dbf';
Statement processed.
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/redo01.log' to '/u2/backup/redo01.log';
Statement processed.
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/redo02.log' to '/u2/backup/redo02.log';
Statement processed.
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/redo03.log' to '/u2/backup/redo03.log';
Statement processed.
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/temp01.dbf' to '/u2/backup/temp01.dbf';
Statement processed.
and same goes to drsys01,users01.dbf
at this spot of renaming
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/nebula1.dbf' to '/u2/backup/nebula1.dbf';
*
ORA-01511: error in renaming log/data files
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile or tempfile '/u1/oracle/oradata/nebula/nebula1.dbf'
SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/nebula2.dbf' to '/u2/backup/nebula2.dbf'; alter database rename file '/u1/oracle/oradata/nebula/nebula2.dbf' to '/u2/backup/nebula2.dbf'
*
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile or tempfile '/u1/oracle/oradata/nebula/nebula2.dbf'
SVRMGR> SVRMGR> alter database rename file '/u1/oracle/oradata/nebula/nebula2.dbf' to '/u2/backup/nebula2.dbf'; alter database rename file '/u1/oracle/oradata/nebula/nebula2.dbf' to '/u2/backup/nebula2.dbf'
*
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile or tempfile '/u1/oracle/oradata/nebula/nebula2.dbf'
Please let me know why it's not let me renamed these datafiles, i have to make this database up, pls your help required.
Thanks
Sami
-
It seems to be that this '/u1/oracle/oradata/nebula/nebula2.dbf' does not exist in the database.
Check in the database by selecting from DBA_DATA_FILES view.
-
Or, while you have the database mounted, you can:
select member from v$logfile
