Hello,
I have to move a 9i database from one server to another. Can somebody provide me the steps to accomplish this task?
Thanks
Printable View
Hello,
I have to move a 9i database from one server to another. Can somebody provide me the steps to accomplish this task?
Thanks
Do you know how to install Oracle on the new server?
Good, install it.
Do you know how to back up your database?
I hope so. Back it up and restore the database on the new server.
Then start the database. If you are installing on Windows you will need to create a service, which you can do at the dos level. On Unix you have to put the right files in the /etc directory. You can find this in the before you install guide for your platform.
Then configure your listener. Of course you don't mention what version of os you are running, whether or not you are changing Oracle versions and what they are. Unless your database is huge, it should be a simple thing to move the database.
Thanks. It is on HP-UX.
I was thinking I do it this way. After installing oracle 9i on the new server, create datafiles in the new server like the one in the other server. Then take an export file of the old one and import int into the new server.
correct me if i am wrong.
>>create datafiles
typo, i meant to write tablespaces
IMHO, the easiest way to do it is:
1. install oracle software on new server
2. shutdown db on old server
3. copy all database files
4. startup db on new server
Thanks Marist89,
Before I copy all databasefiles from old to new server, dont i have to create tablespaces ?
correct me if i am wrong.
No, your database files (*.dbf) will contain all the tablespace information you need. Perhaps you're confusing tablespaces with data files themselves?
By copying over the datafiles, redo logs, init file, etc. you are moving your database. you might need to recreate the password file, and you will need to set up the listener. But that is it.
I thank one and all for their advice here. From all your views, i am going to do these steps on HP-UX. Hope i am correct.
Backup controlfile using trace option on Source Database.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Shutdown the original database.
Copy all datafiles, redolog files, init.ora files to the other server location.
Setup listener for the new instance.
Start the listener
Edit the create controlfile with the path of datafiles and redolog files placed on the new server/location
svrmgrl> connect internal;
svrmgrl> @create_controlfile_script;
statement processed
svrmgrl> alter database open resetlogs;
Hope I am correct !!
any inputs??
Backing up the controlfile to trace is a good way to see where all of your files are and to make sure that you get them. However you should not need to either recreate the control files or do a resetlogs. In fact you should not do either since you are doing a cold backup.Quote:
Originally posted by surnag
I thank one and all for their advice here. From all your views, i am going to do these steps on HP-UX. Hope i am correct.
Backup controlfile using trace option on Source Database.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Shutdown the original database.
Copy all datafiles, redolog files, init.ora files to the other server location.
Setup listener for the new instance.
Start the listener
Edit the create controlfile with the path of datafiles and redolog files placed on the new server/location
svrmgrl> connect internal;
svrmgrl> @create_controlfile_script;
statement processed
svrmgrl> alter database open resetlogs;
Hope I am correct !!
any inputs??
From his description of the intended steps it is obvious that the files will be placed in different directories on the new server. So he *has to* recreate the control file with the new datafile locations (the other option would be to simply modify the existing controlfile with "ALTER DATABASE REANAME ...." comands in nomount state).Quote:
Originally posted by gandolf989
Backing up the controlfile to trace is a good way to see where all of your files are and to make sure that you get them. However you should not need to either recreate the control files or do a resetlogs. In fact you should not do either since you are doing a cold backup.
surnag, you will probably not have much success with your steps if you intend to use svrmgrl on 9i database - sqlplus might be more appropriate. :D
Jmodic,
thanks for your advice and also the others. But why do you say It wont be successful if i use svrmgrl ? what might be the reasons?
Because there is no such thing in 9i as svrmgrl. It is depreciated, it is gone, it is not available any more. What you used to do with svrmgrl in Oracle7/8 must be done using SQL*Plus in Oracle9i and above. svrmgrl simply doesn't exist any more!
Thank you
I didn't see the part where he said the volumes were different. If that is the case then, yes, he does need to recreate the control files.Quote:
Originally posted by jmodic
From his description of the intended steps it is obvious that the files will be placed in different directories on the new server. So he *has to* recreate the control file with the new datafile locations (the other option would be to simply modify the existing controlfile with "ALTER DATABASE REANAME ...." comands in nomount state).
surnag, you will probably not have much success with your steps if you intend to use svrmgrl on 9i database - sqlplus might be more appropriate. :D