?rac???????????????
???????????? ???????[ 2015/11/25 13:38:16 ] ????????????? rac ????
???????dba???????????????????????????????????????????????????????????????????????????????????????????????????2??????3????????????????????????????????????????????????????????
???????????????????????srvctl????
????[oracle@node2]$ srvctl stop instance -d racdb -i racdb1??racdb2 -o immediate
????????????crs??
????[oracle@node2 ~]$ crs_stat -t
????Name Type Target State Host
????------------------------------------------------------------
????ora....SM2.asm application ONLINE ONLINE node1
????ora....E1.lsnr application ONLINE ONLINE node1
????ora.node1.gsd application ONLINE ONLINE node1
????ora.node1.ons application ONLINE ONLINE node1
????ora.node1.vip application ONLINE ONLINE node1
????ora....SM1.asm application ONLINE ONLINE node2
????ora....E2.lsnr application ONLINE ONLINE node2
????ora.node2.gsd application ONLINE ONLINE node2
????ora.node2.ons application ONLINE ONLINE node2
????ora.node2.vip application ONLINE ONLINE node2
????ora.racdb.db application OFFLINE OFFLINE
????ora....b1.inst application OFFLINE OFFLINE
????ora....b2.inst application OFFLINE OFFLINE
????????????????nomount??
????[oracle@node2 ~]$ srvctl start database -d racdb -o nomount
???????????????????
????SQL> select INSTANCE_NAME??HOST_NAME??STATUS from gv$instance;
????INSTANCE_NAME HOST_NAME STATUS
????---------------- -------------------- ------------
????racdb1 node2.ocean.com STARTED
????racdb2 node1.ocean.com STARTED
?????????????rman???????е?????????????μ???????
????[oracle@node2 ~]$ rman target / nocatalog
????RMAN> restore controlfile to '+DATA/racdb/controlfile/control_2' from '+DATA/racdb/controlfile/current.256.842559447';
????Starting restore at 20-MAR-14
????allocated channel: ORA_DISK_1
????channel ORA_DISK_1: sid=146 instance=racdb1 devtype=DISK
????channel ORA_DISK_1: copied control file copy
????Finished restore at 20-MAR-14
????????????????????????
????SQL> alter system set control_files='+DATA/racdb/controlfile/control_2'??'+DATA/racdb/controlfile/current.256.842559447'
????scope=spfile;
????System altered.
?????塢?????????????control_files?????????????????????????????Ч??
????[oracle@node2 ~]$ srvctl stop instance -d racdb -i racdb1??racdb2 -o immediate
???????????????????
????[oracle@node2 ~]$ srvctl start database -d racdb
?????????????????control_files????
????SQL> show parameter control
????NAME TYPE VALUE
????------------------------------------ ----------- ------------------------------
????control_file_record_keep_time integer 7
????control_files string +DATA/racdb/controlfile/contro
????l_2?? +DATA/racdb/controlfile/c
????urrent.256.842559447
????????????????????control_2????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11