简单整理了SAP系统的SID变更步骤,真正作的时候需要考虑的很多,所以我觉得在每次要变更SID之前,最好写详细的Senario。而且,在作的时候也把时间都记录。
这里省略了变更SID之后,在SAP系统上作的操作。
1. backup controlfile
SVRMGR> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
SVRMGR> SHUTDOWN IMMEDIATE;
modify backup control file sql script
a. CREATE CONTROLFILE REUSE DATABASE "OLD_DB_NAME" NORESETLOGS;
->CREATE CONTROLFILE SET DATABASE "NEW_DB_NAME" RESETLOGS;
b. RECOVER DATABASE;
->RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
c. <OLD_SID> -> <NEW_SID>
ALTER DATABASE OPEN;
->ALTER DATABASE OPEN RESETLOGS;
2.umount old filesystem
3. Create oracle<SID>, <SID>adm User
4.mount new filesystem
5.execute backup control file sql
6.relink
7.Link check :
(1) cd /usr/sap/<SID>/SYS
# ln -s /sapmnt/<SID>/global global
# ln -s /sapmnt/<SID>/profile profile
(2) cd /usr/sap/<SID>/SYS/exe
# ln -s /sapmnt/<SID>/exe dbg
8.Check <sid>adm user environment.
.cshrc, .kshrc, .login, .profile, .dbenv_<hostname>.sh, .dbenv_<hostname>.csh, .sapenv_<hostname>.sh .sapenv_<hostname>.csh
9.Modify R/3 parameters
: startsap_<hostname>_<system no>, stopsap_<hostname>_<system no>
: DEFAULT.PFL, TEMU.PFL
: START_D<VEBMGS><system no>_<hostname>, <SID>_D<VEBMGS><system no> ...
10.Check files (/etc/hosts, /etc/services)
11.saplicense install
Link URL: http://happyland.itpub.net/post/4163/108670
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/148866/viewspace-701499/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/148866/viewspace-701499/