ORA-01511,ORA-01516

[Sami]

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

[tamilselvan]

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.

[marist89]

Or, while you have the database mounted, you can:
select member from v$logfile