简单整理了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. ->
ALTER DATABASE OPEN;
->ALTER DATABASE OPEN RESETLOGS; 2.umount old filesystem 3. Create oracle, adm User
4.mount new filesystem
5.execute backup control file sql
6.relink 7.Link check :
(1) cd /usr/sap//SYS
# ln -s /sapmnt//global global
# ln -s /sapmnt//profile profile
(2) cd /usr/sap//SYS/exe
# ln -s /sapmnt//exe dbg