오라클 패치 후 다시 원복 하기

[CRS, DB PATCHSET 한 후  DB만 원래대로 복원하기 위해 downgrade를 해줌]

전제조건
   1. 10.2.0.5 patchset으로 설치된 crs 와 db 설치됨
   2. 10.2.0.4 버전이었을때 백업을 해놓아야하는 부분(oraInventory, ORACLE_HOME폴더)
      2-1. /etc/oraInst.loc에 내용에 있는 oraInventory 폴더
      2-2. ORACLE_HOME 폴더

1. crs_stat -t   RAC상태가 online인지 확인한다.

2. alter system set cluster_database=FALSE scope=spfile;

3. srvctl stop database -d DB명 후
   
   $ORACLE_HOME/rdbms/admin/catrelod.sql
   $ORACLE_HOME/network/admin/tnsnames.ora
  
   위 두개 파일을 백업 해놓는다.

4.
   4-1. sqlplus 접속후
   4-2. startup downgrade
   4-3. spool downgrade.out
   4-4. @?/rdbms/admin/catdwgrd.sql
   4-5. spool off
   4-6. shutdown immediate

5. 10.2.0.4버전이었을때 백업했던 oraInventory폴더를   /etc/oraInst.loc 파일에서 가르키고 있는 곳에 복원 시킴

6. 10.2.0.4버전이었을때 백업했던 것을 다시 복원시켜야함
   6-1. 위에서 백업했던 10.2.0.5용 catrelod.sql와 tnsnames.ora를  10.2.0.4폴더 자리에 넣어놓는다.

7. 한쪽노드에서
   7-1. sqlplus 접속후
   7-2. startup downgrade
   7-3. spool catrelod.out
   7-4. @?/rdbms/admin/catrelod.sql
   7-5. spool off
   7-6. select comp_name, version, status from dba_registry;
        COMP_NAME                           VERSION                        STATUS
        ----------------------------------- ------------------------------ ----------------------
        Oracle Enterprise Manager           10.2.0.4.0                     VALID
        Spatial                             10.2.0.4.0                     INVALID
        Oracle interMedia                   10.2.0.4.0                     VALID
        OLAP Catalog                        10.2.0.4.0                     VALID
        Oracle XML Database                 10.2.0.4.0                     VALID
        Oracle Text                         10.2.0.4.0                     VALID
        Oracle Expression Filter            10.2.0.4.0                     VALID
        Oracle Rule Manager                 10.2.0.4.0                     VALID
        Oracle Workspace Manager            10.2.0.4.3                     VALID
        Oracle Data Mining                  10.2.0.4.0                     VALID
        Oracle Database Catalog Views       10.2.0.4.0                     VALID
        Oracle Database Packages and Types  10.2.0.4.0                     VALID
        JServer JAVA Virtual Machine        10.2.0.4.0                     VALID
        Oracle XDK                          10.2.0.4.0                     VALID
        Oracle Database Java Packages       10.2.0.4.0                     VALID
        OLAP Analytic Workspace             10.2.0.4.0                     VALID
        Oracle OLAP API                     10.2.0.4.0                     INVALID
        Oracle Real Application Clusters    10.2.0.4.0                     VALID

   7-7. shutdown immediate
   7-8. startup
   7-9. @?/rdbms/admin/utlrp.sql
  
8. select comp_name, version, status from dba_registry;
   COMP_NAME                           VERSION                        STATUS
   ----------------------------------- ------------------------------ ----------------------
   Oracle Enterprise Manager           10.2.0.4.0                     VALID
   Spatial                             10.2.0.4.0                     VALID
   Oracle interMedia                   10.2.0.4.0                     VALID
   OLAP Catalog                        10.2.0.4.0                     VALID
   Oracle XML Database                 10.2.0.4.0                     VALID
   Oracle Text                         10.2.0.4.0                     VALID
   Oracle Expression Filter            10.2.0.4.0                     VALID
   Oracle Rule Manager                 10.2.0.4.0                     VALID
   Oracle Workspace Manager            10.2.0.4.3                     VALID
   Oracle Data Mining                  10.2.0.4.0                     VALID
   Oracle Database Catalog Views       10.2.0.4.0                     VALID
   Oracle Database Packages and Types  10.2.0.4.0                     VALID
   JServer JAVA Virtual Machine        10.2.0.4.0                     VALID
   Oracle XDK                          10.2.0.4.0                     VALID
   Oracle Database Java Packages       10.2.0.4.0                     VALID
   OLAP Analytic Workspace             10.2.0.4.0                     VALID
   Oracle OLAP API                     10.2.0.4.0                     VALID
   Oracle Real Application Clusters    10.2.0.4.0                     VALID

9. alter system set cluster_database=TRUE scope=spfile;
10. shutdown
11. srvctl start database -d 데이터베이스명