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
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).
Clone DB UNIX style and taking consideration that you already have an Oracle home and user id over on the target server
1.alter database backup controlfile to trace;
2. shutdown database.
3. copy /FTP all datafiles,redo logs,init.ora (don't forget to rename the init.ora to the new database name as well as in the actual init.ora) to new server.
4. edit the control file that was put to trace.don't forget ftp it over.
ex.. CREATE CONTROLFILE SET DATABASE "Prince JR" RESETLOGS ARCHIVELOG
edit: datafiles; you do not need to issue the recover database command
alter database open resetlogs;
5. make sure you have you're enviornment variables set to the new home and sid within your .profile /env file (or whatever you use).
6. on target server login with the user id and issue the following.
connect / as sysdba
7. Vollah! you have a cloned database.
hmmm don't think I missed anything
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
I am confused in here. DO i NEED to give "Create controlfile set database " Or "Create controlfile reuse set database" or "Create control file resuse database".
I am just eager to know how does it work in 3 different statements..
Specify REUSE to indicate that existing control files identified by the initialization parameter CONTROL_FILES can be reused, thus ignoring and overwriting any information they may currently contain. If you omit this clause and any of these control files already exists, Oracle returns an error.
Use SET DATABASE to change the name of the database. The name of a database can be as long as eight bytes.