64208664578e09c3ff.png (175.46 KB, 下载次数: 33)
2024-5-16 11:09 上传
查看控制文件快照位置节点1：
[oracle@xd1dbadm01 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:41:01 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: YDHLGL (DBID=879094270)
RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.12.0.0/dbhome_1/dbs/snapcf_ydhlgl1.f'; # default
节点2：
[oracle@xd1dbadm02 dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:47:38 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: YDHLGL (DBID=879094270)
RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.12.0.0/dbhome_1/dbs/snapcf_ydhlgl2.f'; # default
RAC修改snapshot controlfile 参数
在其中一节点下进行参数修改CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
具体语句：
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
new RMAN configuration parameters are successfully stored
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
节点2确认参数信息：
[oracle@xd1dbadm02 dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu May 16 10:47:38 2024
Version 19.12.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: YDHLGL (DBID=879094270)
RMAN> show snapshot controlfile name;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name YDHLGL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f';
字典表确认以及测试
select * from V$RMAN_CONFIGURATION
CONF# NAME VALUE CON_ID
---------- ------------------------------ ---------------------------------------- ----------
1 BACKUP OPTIMIZATION OFF 0
2 SNAPSHOT CONTROLFILE NAME TO '+RECO/YDHLGL/snapcf_ydhlgl.f' 0
在 AnyBackup 控制台重新发起备份任务进行测试。
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |