Changing the database name
Can anyone give me some information on what are steps involved in 1)creating database on same server with different Dbname 2)Creating database on different server with same database name but differnt paths.
I have the backup of the database on tape. what should my control file script look like for different scenarios and what are the commands to be given after running control file script.
Can I use 1) " CREATE CONTROLFILE REUSE set DATABASE "newdbname" RESETLOGS"
Changing the file system to the different directory
/u02/oradata/newdbname/sys1.dbf
2) Alter database open resetlogs;
Is it not needed to give restore database before giving alter database open resetlogs command ???
Are the above steps can be used for both above mentioned scenarios ( Instead if newdbname it will be olddbname for seconds scenario).
Thanks