on 09-19-2007 10:43 AM
Hi all.
I want do system copy on sap 4.6 with oracle10g. the target server's enviroment is all the same against the source server including hardware and software. I have installed sap ci and di and oracle database on the target server, what I want to know is that ,can I do system copy by restoring database from the backup image made from source database to the target server?
the step needed is just restore it ,and then the target server will be all the same with the source server?(the source is online for production for a long time)
thanks very much!!
Message was edited by:
zhang dong
Message was edited by:
zhang dong
thanks for your posting, friends!
but I doubt that , shouldn't I copy the /user/sap/* to the target server and overwrite the same directory? because I found that this directory on target server is about 1GB in size, but the same directory on the source server is only 90MB in size, if I just restore oracle database file to the target server , so could the target server take place of the source server to continually do transactions?
thanks!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
/usr/sap contains loads of log files. so, the directory size of both instance is different and that's expected.
the target server can take place of the source system, but your should keep the same hostname. if not, you will need to create a procedure to change things in your system that refers to your new hostname... and adapt everybody's saplogon.ini... unless you use an alias in the DNS and point to the new server.
thank you Eric!!
If the backup server's hostname is different with the original server, what files should I edit? Could you please give a list of these files? I know little about sap,and I don't have authority to access the stuff on sap's site,thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
to get a good idea, go download the homogeneous system copy guide from http://service.sap.com/INSTGUIDES
it contains information on SID change (which you do not need) but also for hostname change.
oh, the dialog instance host connect to the central instance host only through the hostname,right? if so , i can edit the host file on the dialog instance host , this can redirect the hostname of original central instance host to the new ip address of the current central instance host, can i do like this ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
plz help me some,thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK,thanks
another question, the sap dialog instance is installed on another machine,if the primary database(also the sap central instance and database instance's host) is down someday, the backup server takeover it, the sap dialog instance should do some modifications, because the dialog instance must connect to the central instance to work,is it right? can the dialog instance's config be modified to connect to the new ip address of the new central instance(the backup server)??
Message was edited by:
zhang dong
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"to start SAP on the DR server, you must do these steps manually. "
what extra steps should I do? data guard is not enough?
the sap has already been installed on the backup server,except that it hadn't been online for production, the primary server's sap has been online for some years.
the sid and other cfg is the same i think
Message was edited by:
zhang dong
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry ,I gernerate another question
if I use data guard to do the DR on oracle database, the primary server transport the redo log to the backup server, on the backup server , the database replay the log and stay synchronization with the primary server. when the primary server is dwon, then the sap can start on the backup server and take place of the primary server ,is it doable?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks!!
I don't have the authentication to access the sap site, I am planning a oracle's disaster recover project ,but the server is not only oracle server but also sap server, and I have no ideas on sap,so I find here, I am lucky!
after all , thank you,Eric!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks very much!
and I still have another question,when I do the database restore , can I use the RMAN instead of sap's own tools?
I think the so called "system copy",is just the restoration or import of the third party database to the other machine , what's more?
thanks for all!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes, you can use RMAN instead. no problem.
in a system copy, the biggest part is copying the database on the new machine. but many post-copy steps must be done if you change SID or hostname. the guide I provided you explains the process.
you might also get the latest homogeneous system copy guide from SAP at http://service.sap.com/instguides .
zhang,
a good procedure exists on the web, check this guide:
http://www.basisconsultant.com/docs/handbooks/homcopyv1.pdf
Good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Zhang:
Check for the homogenous system copy procedures under:
https://websmp204.sap-ag.de/instguides -> SAP Cpmponents - SAP R3 -> 46C
OR
A short overview of what you could do:
-
for hot backups ##################
1. install software on target maching,do not create db.
2. create directory structure same as your source db.
3. copy tnsname.ora , listner.ora files ,sqlnet.ora.
4. create service for instance and listner.
5. startup the db in nomount state with pfile option.
6. restore database.
7. recover database or alter database open resetlogs.
for cold backups ###############
1. install oracle software on target machine.
2. create same dir structure as of your source db.
3. create services for instance and listner
4. copy the dbfiles and redologfile to the dir same as source.
5. copy the networking file to appropriate directory.
6. startup mountpfile = 'location of pfile'
7. alter database open or alter database open resetlogs.
-
That should make your job easier.
-Madhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes, you can use the offline backup or online backup (in this case you need to apply the redologs generated afterwards) to get the system to the same level.
You will get some useful tips in the SAP note 96848.
Regards,
Madhukar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.