Shulou(Shulou.com)06/01 Report--

Environment:

Database version: oracle 11.2.0.4

Whether RAC: the RAC of two nodes

-- preparation work

Before replacement:

10.100.10.62 en1

10.100.10.200 en1

After replacement:

10.100.10.62 en8

10.100.10.200 en8

1. View the Public IP configuration before modification

Testdb1:/home/oracle (testdb1) $oifcfg getif

En1 10.100.10.0 global public

En3 192.168.110.0 global cluster_interconnect

two。 View the VIP configuration of Node 1 before modification

Testdb1:/home/oracle (testdb1) $srvctl config vip-n testdb1

VIP exists: / testdb1-vip/10.100.10.156/10.100.10.0/255.255.255.0/en1, hosting node testdb1

3. View the VIP configuration before Node 2 modification

Testdb2:/home/oracle (testdb2) $srvctl config vip-n testdb2

VIP exists: / testdb2-vip/10.100.10.157/10.100.10.0/255.255.255.0/en1, hosting node testdb2

4. Check the current scan IP configuration

Testdb1:/home/oracle (testdb1) $srvctl config scan

SCAN name: testdb-scan, Network: 1/10.100.10.0/255.255.255.0/en1

SCAN VIP name: scan1, IP: / testdb-scan/10.100.10.158

5. Check OCR backup

Testdb1:/home/oracle (testdb1) $ocrconfig-showbackup

Testdb1 2016-09-18 09:18:48 / oracle/app/11.2.0/grid/cdata/testdb-cluster/backup00.ocr

Testdb1 2016-09-18 05:18:47 / oracle/app/11.2.0/grid/cdata/testdb-cluster/backup01.ocr

Testdb1 2016-09-18 01:18:46 / oracle/app/11.2.0/grid/cdata/testdb-cluster/backup02.ocr

Testdb1 2016-09-16 13:18:38 / oracle/app/11.2.0/grid/cdata/testdb-cluster/day.ocr

Testdb1 2016-09-07 04:11:26 / oracle/app/11.2.0/grid/cdata/testdb-cluster/week.ocr

PROT-25: Manual backups for the Oracle Cluster Registry are not available

# backing up OCR manually

Su-root

/ oracle/app/11.2.0/grid/bin/ocrconfig-export / home/oracle/ocr_bak20160918

#

one。 Stop business

Hostname View Host

Id View id

View the crs status of each node

Crsctl stat res-t

two。 Stop the self-startup of CRS-related resources

1. Stop listening to resources

Su-oracle

Srvctl disable listener

Srvctl stop listener

Crsctl stat res-t

two。 Stop database resources (per node)

Su-oracle

Ps-ef | grep LOCAL=NO | awk'{print $2}'| xargs kill-9

Select * from v$FAST_START_TRANSACTIONS where UNDOBLOCKSDONE UNDOBLOCKSTOTAL;-check to see if anything big is rolled back. If so, you need to wait for the rollback to finish.

Select undoblocksdone,undoblockstotal from v$fast_start_transactions where state'RECOVERED'

Sqlplus / as sysdba

Alter system switch logfile

Alter system switch logfile

Alter system switch logfile

Alter system switch logfile

Alter system switch logfile

Alter system switch logfile

Alter system switch logfile

Alter system checkpoint

Srvctl disable database-d testdb (only need to operate on one node)

Srvctl stop database-d testdb-o immediate (only need to operate on one node)

Crsctl stat res-t

New window ora log View Log

Tail-300f / oraclelog/diag/rdbms/testdb/testdb1/trace/alert*.log

Tail-300f / oraclelog/diag/rdbms/testdb/testdb2/trace/alert*.log

3. Stop the VIP resource (per node)

Stop Node 1:

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl disable vip-I testdb1-vip

/ oracle/app/11.2.0/grid/bin/srvctl stop vip-n testdb1

Stop Node 2:

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl disable vip-I testdb2-vip

/ oracle/app/11.2.0/grid/bin/srvctl stop vip-n testdb2

4. Stop scan_listener resources

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl disable scan_listener (only need to operate on one node)

/ oracle/app/11.2.0/grid/bin/srvctl stop scan_listener (only need to operate on one node)

5. Stop scan resources

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl disable scan (only need to operate on one node)

/ oracle/app/11.2.0/grid/bin/srvctl stop scan (only need to operate on one node)

6. Stop the crs service (per node)

Su-root

/ oracle/app/11.2.0/grid/bin/crsctl stop crs

7. The host side changes the corresponding network card en1 of Public IP (10.100.10.62x200) to en8, and the configuration of IP address / subnet mask remains the same.

8. Start the crs service (per node)

Su-root

/ oracle/app/11.2.0/grid/bin/crsctl start crs

View crs status

Crsctl stat res-t

two。 Modify the Nic name (Public IP)

1. View the Public IP configuration before modification

Testdb1:/home/oracle (testdb1) $oifcfg getif

En1 10.100.10.0 global public

En3 192.168.110.0 global cluster_interconnect

two。 Delete the Public IP of en1

Su-grid

Oifcfg delif-global en1

3. Add Public IP for en8

Su-grid

Oifcfg setif-global en8/10.100.10.0:public

4. View the modified Public IP configuration

Testdb1:/home/oracle (testdb1) $oifcfg getif

four。 Modify the Nic name (VIP)

1. View the VIP configuration of Node 1 before modification

Testdb1:/home/oracle (testdb1) $srvctl config vip-n testdb1

VIP exists: / testdb1-vip/10.100.10.156/10.100.10.0/255.255.255.0/en1, hosting node testdb1

two。 View the VIP configuration before Node 2 modification

Testdb2:/home/oracle (testdb2) $srvctl config vip-n testdb2

VIP exists: / testdb2-vip/10.100.10.157/10.100.10.0/255.255.255.0/en1, hosting node testdb2

3. Modify the VIP configuration on node 1

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl modify nodeapps-n testdb1-A 10.100.10.156/255.255.255.0/en8

4. Modify the VIP configuration on node 2

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl modify nodeapps-n testdb2-A 10.100.10.157/255.255.255.0/en8

5. View the modified VIP configuration of Node 1

Srvctl config vip-n testdb1

6. View the modified VIP configuration of Node 2

Srvctl config vip-n testdb2

five。 Check the current scan IP configuration

Testdb1:/home/oracle (testdb1) $srvctl config scan

SCAN name: testdb-scan, Network: 1/10.100.10.0/255.255.255.0/en1

SCAN VIP name: scan1, IP: / testdb-scan/10.100.10.158

six。 Modify CRS related resources to self-startup. Restart CRS

Su-root

/ oracle/app/11.2.0/grid/bin/srvctl enable listener / / listener resources

/ oracle/app/11.2.0/grid/bin/srvctl enable database-d testdb / / Database resources

/ oracle/app/11.2.0/grid/bin/srvctl enable vip-I testdb1-vip / / VIP resources for Node 1

/ oracle/app/11.2.0/grid/bin/srvctl enable vip-I testdb2-vip / / VIP resources for Node 2

/ oracle/app/11.2.0/grid/bin/srvctl enable scan_listener / / scan_listener resources

/ oracle/app/11.2.0/grid/bin/srvctl enable scan / / scan resources

Restart the CRS service (executed separately by two nodes)

/ oracle/app/11.2.0/grid/bin/crsctl stop crs

/ oracle/app/11.2.0/grid/bin/crsctl start crs

Check logs, services

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.