-
move database from one server to another
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
Jeff Hunter
-
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?
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
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??
-
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??
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|