snapshot controlfie 在 RAC + DataGuard 环境下的配置

最新推荐文章于 2024-07-23 17:52:34 发布

crhwkrhpunow61910

最新推荐文章于 2024-07-23 17:52:34 发布

阅读量112

点赞数

文章标签：数据库

## 1，检查 ASM 信息

[grid@irora11 ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N         512   4096 1048576   1024010   984001                0          984001              0             N ARCHDG01/
MOUNTED EXTERN N         512   4096 1048576   4608045 4430455                0         4430455              0             N DATADG01/
MOUNTED EXTERN N         512   4096 1048576     10240     9802                0            9802              0             Y OCRVOTE/
MOUNTED EXTERN N         512   4096 1048576    512005   476663                0          476663              0             N REDODG01/
ASMCMD>
ASMCMD> cd datadg01
ASMCMD> ls
IRRACC/
TBS_SUPPORT_DAT01
TBS_SUPPORT_TEMP01
mread_data01
mread_data02
mread_data03
mread_data04
mread_idx01
mread_temp01
ASMCMD> pwd
+datadg01
ASMCMD>

## 2，更改前 snapshot controlfile 配置信息

[oracle@irora11 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 08:48:46 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name IRRACC are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/products/11.2.0/dbs/snapcf_irracc1.f'; # default

RMAN>

[oracle@irora12 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 08:49:42 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

RMAN>

[oracle@irora13 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 08:50:06 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

RMAN>

## 3，确定备份前 snapshot controlfile 状态

[oracle@irora11 ~]$ cd /opt/oracle/products/11.2.0/dbs/
[oracle@irora11 dbs]$ date;ll
Thu Aug 7 08:54:27 CST 2014
total 38164
-rw-rw---- 1 oracle asmadmin     1544 Jul 30 10:29 hc_irracc1.dat
-rw-r--r-- 1 oracle oinstall       43 Mar 4 16:34 initirracc1.ora
-rw-r--r-- 1 oracle oinstall     1954 Mar 4 12:41 initirracc1.ora.bak
-rw-r--r-- 1 oracle oinstall     1954 Mar 4 12:41 initirracc1.ora.bak.irora11
-rw-r--r-- 1 oracle oinstall     2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall     1536 Jun 26 17:07 orapwirracc1
-rw-r----- 1 oracle asmadmin 39043072 Aug 7 08:15 snapcf_irracc1.f                    <<<<<< 已生成 snapshot controlfile
-rw-r----- 1 oracle asmadmin     5632 Mar 4 10:26 spfileirracc1.ora.bak
[oracle@irora11 dbs]$

[oracle@irora12 ~]$ cd /opt/oracle/products/11.2.0/dbs/
[oracle@irora12 dbs]$ date;ll
Thu Aug 7 08:54:31 CST 2014
total 20
-rw-rw----. 1 oracle asmadmin 1544 Jul 30 10:29 hc_irracc2.dat
-rw-r--r--. 1 oracle oinstall 43 Mar 4 16:49 initirracc2.ora
-rw-r-----. 1 oracle oinstall 1998 Mar 4 12:42 initirracc2.ora.bak.irora12
-rw-r--r--. 1 oracle oinstall 2851 Feb 28 17:22 init.ora
-rw-r-----. 1 oracle oinstall 1536 Jun 26 17:13 orapwirracc2
[oracle@irora12 dbs]$

[oracle@irora13 ~]$ cd /opt/oracle/products/11.2.0/dbs/
[oracle@irora13 dbs]$ date;ll
Thu Aug 7 08:54:35 CST 2014
total 28
-rw-rw---- 1 oracle asmadmin 1544 Jul 30 10:29 hc_irracc3.dat
-rw-r--r-- 1 oracle oinstall 43 Mar 4 16:49 initirracc3.ora
-rw-r----- 1 oracle oinstall 1998 Mar 4 12:42 initirracc3.ora.bak.irora13
-rw-r--r-- 1 oracle oinstall 2851 Feb 28 17:22 init.ora
-rw-r----- 1 oracle oinstall 1536 Jun 26 17:13 orapwirracc3
-rw-r----- 1 oracle oinstall 5632 Mar 4 10:29 spfileirracc1.ora.bak
[oracle@irora13 dbs]$

## 4，在节点一通过 RMAN 执行备份 controlfile 命令，备份到本地 /tmp 目录下

run
{BACKUP
    # recommended format
    FORMAT '/tmp/control_back_20140807'
    CURRENT CONTROLFILE;
}

[oracle@irora11 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 08:50:33 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN>    run
2> {BACKUP
3>     # recommended format
    FORMAT '/tmp/control_back_20140807'
    CURRENT CONTROLFILE;
}
4> 5> 6>
Starting backup at 07-AUG-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1328 instance=irracc1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 07-AUG-14
channel ORA_DISK_1: finished piece 1 at 07-AUG-14
piece handle=/tmp/control_back_20140807 tag=TAG20140807T085625 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 07-AUG-14

RMAN> exit

Recovery Manager complete.
[oracle@irora11 ~]$

## 5，再次检查各个节点 snapshot controlfile 信息

[oracle@irora11 dbs]$ date;ll
Thu Aug 7 08:56:43 CST 2014
total 38164
-rw-rw---- 1 oracle asmadmin     1544 Jul 30 10:29 hc_irracc1.dat
-rw-r--r-- 1 oracle oinstall       43 Mar 4 16:34 initirracc1.ora
-rw-r--r-- 1 oracle oinstall     1954 Mar 4 12:41 initirracc1.ora.bak
-rw-r--r-- 1 oracle oinstall     1954 Mar 4 12:41 initirracc1.ora.bak.irora11
-rw-r--r-- 1 oracle oinstall     2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall     1536 Jun 26 17:07 orapwirracc1
-rw-r----- 1 oracle asmadmin 39043072 Aug 7 08:56 snapcf_irracc1.f                     <<<<<< snapshot controlfile 已更新
-rw-r----- 1 oracle asmadmin     5632 Mar 4 10:26 spfileirracc1.ora.bak
[oracle@irora11 dbs]$

[oracle@irora12 ~]$ cd /opt/oracle/products/11.2.0/dbs/
[oracle@irora12 dbs]$ date;ll
Thu Aug 7 08:59:37 CST 2014
total 20
-rw-rw----. 1 oracle asmadmin 1544 Jul 30 10:29 hc_irracc2.dat
-rw-r--r--. 1 oracle oinstall 43 Mar 4 16:49 initirracc2.ora
-rw-r-----. 1 oracle oinstall 1998 Mar 4 12:42 initirracc2.ora.bak.irora12
-rw-r--r--. 1 oracle oinstall 2851 Feb 28 17:22 init.ora
-rw-r-----. 1 oracle oinstall 1536 Jun 26 17:13 orapwirracc2
[oracle@irora12 dbs]$

[oracle@irora13 ~]$ cd /opt/oracle/products/11.2.0/dbs/
[oracle@irora13 dbs]$ date;ll
Thu Aug 7 09:00:09 CST 2014
total 28
-rw-rw---- 1 oracle asmadmin 1544 Jul 30 10:29 hc_irracc3.dat
-rw-r--r-- 1 oracle oinstall 43 Mar 4 16:49 initirracc3.ora
-rw-r----- 1 oracle oinstall 1998 Mar 4 12:42 initirracc3.ora.bak.irora13
-rw-r--r-- 1 oracle oinstall 2851 Feb 28 17:22 init.ora
-rw-r----- 1 oracle oinstall 1536 Jun 26 17:13 orapwirracc3
-rw-r----- 1 oracle oinstall 5632 Mar 4 10:29 spfileirracc1.ora.bak
[oracle@irora13 dbs]$

## 6，备库 snapshot controlfile 检查

[oracle@irora03s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:11:55 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN>

[oracle@irora08s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:12:46 2014

connected to target database (not started)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 08/07/2014 10:12:49
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

RMAN>

[oracle@irora08s ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 7 10:13:21 2014

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 8.0171E+10 bytes
Fixed Size                  2261848 bytes
Variable Size            2.3622E+10 bytes
Database Buffers         5.6371E+10 bytes
Redo Buffers              175083520 bytes
Database mounted.
SQL>    exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@irora08s ~]$
[oracle@irora08s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:25:33 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN>

## 7，依照 oracle 原厂提供的操作步骤，更改主库 snapshot controlfile 位置

Oracle 技术支持 - 星期一 [ODM Answer]

Hi,

In RAC, the snapshot controlfile must be located in a shared location, accessible for all nodes in the RAC.
This is discussed in the following Note:

- ORA-245: In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location ( Doc ID 1472171.1 )

Remember, you will need to run the rman 'CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/snapcf_.f';' command on all the instance (so on each node) of the RAC.
You will only need to do this once.

Thanks

rman 下执行：

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f';

### 节点一更改：
[oracle@irora11 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:31:03 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f';
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name IRRACC are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f'; <<<<<<<<<<<<<

RMAN>

### 节点二更改：

[oracle@irora12 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:33:34 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

RMAN>

### 节点三更改：

[oracle@irora13 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 10:33:57 2014

connected to target database: IRRACC (DBID=1768964736)

RMAN> show all;

RMAN>

#### 看下备库的情况

[oracle@irora03s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 11:24:06 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN>

[oracle@irora08s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 11:25:40 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN>

## 更改备库

[grid@irora03s ~]$ date
Thu Aug 7 11:26:56 CST 2014
[grid@irora03s ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N         512   4096 1048576   1024010   774792                0          774792              0             N ARCHDG01/
MOUNTED EXTERN N         512   4096 1048576   4608045 4453452                0         4453452              0             N DATADG01/
MOUNTED EXTERN N         512   4096 1048576     10240     9844                0            9844              0             Y OCRVOTE/
MOUNTED EXTERN N         512   4096 1048576    512005   446231                0          446231              0             N REDODG01/
ASMCMD>

## 在备库一号点执行更改操作
[oracle@irora03s ~]$ date
Thu Aug 7 11:27:24 CST 2014
[oracle@irora03s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 11:27:27 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+datadg01/snapcf_irracc.f';
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN>

## 检查备库第 2 节点，已设定在共享存储上。
[oracle@irora08s ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Aug 7 11:29:20 2014

connected to target database: IRRACC (DBID=1768964736, not open)

RMAN> show all;

RMAN>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66634/viewspace-1247078/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66634/viewspace-1247078/

crhwkrhpunow61910

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
snapshot controlfie 在 RAC + DataGuard 环境下的配置

## 1，检查 ASM 信息 [grid@irora11 ~]$ asmcmdASMCMD> lsdgState Type Rebal Sector Block AU...
复制链接

扫一扫