As your original database name was DEV01 and you are renaming it to DEV03,
if this is a Hot Backup, you must first complete recovery of the database
with the
name DEV01. --ie, do NOT run "create controlfile .. SET DEV03 " but use
"create controlfile DEV01 resetlogs ", then "recover database using backup
controlfile ",
"alter database open resetlogs ", "alter database backup controlfile to trace "
and .. now .. use the new controlfile to rename the database with the "SET
DEV03 RESETLOGS "
and, of course, OPEN RESETLOGS.
OPEN RESETLOGS is required when
a) Performing an incomplete recovery {which you must do first with the
same db_name DEV01}
b) Renaming a database {which are you doing to rename the DB to DEV03}
In any case, your CREATE CONTROLFILE statement seems to be missing some
datafiles.
Why not generate it from the original database DEV01 and modify it ? In
fact, your hot
backup could have included a Controlfile Backup also, which you could have
used to regenerate
the CREATE CONTROLFILE statement.
Hemant
At 10:15 AM Thursday, you wrote:
Hi all,
(...continuing with my previous post....)
after re-creating the control file,should i,
RECOVER DATABASE USING BACKUP CONTROLFILE;
(i did not do this.i am not sure whether
to do this in this case !! )
before
ALTER DATABASE OPEN RESETLOGS;
Thanks and Regards,
Prem.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://web.singnet.com.sg/~hkchital
"A man 's reputation is what other people think of him; his character is
what he really is. "
-- Miner, Jack
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
