网站建设_,快杰云主机,自助网站制作系统源码,制作一个网站都需要学什么文章目录 前言一、信息确认共享目录位置控制文件快照位置节点1节点2 二、RAC修改snapshot controlfile 参数三、字典表确认以及测试 前言
在使用 AnyBackup 管理控制台发起 Oracle RAC 数据库备份后#xff0c;在任务历史记录 执行输出中显示如下错误信息#xff1a; c… 文章目录 前言一、信息确认共享目录位置控制文件快照位置节点1节点2 二、RAC修改snapshot controlfile 参数三、字典表确认以及测试 前言
在使用 AnyBackup 管理控制台发起 Oracle RAC 数据库备份后在任务历史记录 执行输出中显示如下错误信息 control file backup failed; in Oracle RAC, target might not be on shared storage. or control file backup failed; in Oracle RAC, target is likely on a local file system . RMAN输出报错,请检查下是否符合备份恢复条件、是否有配置错误或者有对Oracle的错误操作。 错误提供者: oracleschedule错误值:425984055错误位置:ncOracleExecThread.cpp:877)
一、信息确认
共享目录位置
[rootcxlrac01 ~]# su - grid
Last login: Tue Nov 28 14:35:03 CST 2023 on pts/2
[gridcxlrac01 ~]$
[gridcxlrac01 ~]$
[gridcxlrac01 ~]$ asmcmd
ASMCMD
ASMCMD
ASMCMD ls
DATAC1/
RECOC1/
ASMCMD cd datac1
ASMCMD
ASMCMD ls
ASM/
Cluster-um1/
DB1DB1/
TDHLBG/
TDHLDW/
TDHLTS/
TDHLYL/
orapwasm
orapwasm_backup
ASMCMD
ASMCMD
ASMCMD exit控制文件快照位置
节点1
[oraclecxlrac01 ~]$ rman target /Recovery Manager: Release 19.0.0.0.0 - Production on Tue Nov 28 14:46:48 2023
Version 19.15.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.connected to target database: TDHLYL (DBID1578450313)RMAN RMAN RMAN show snapshot controlfile name;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TDHLYL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/snapcf_tdhlyl1.f; # defaultRMAN 节点2
[oraclecxlrac02 ~]$ rman target /Recovery Manager: Release 19.0.0.0.0 - Production on Tue Nov 28 14:48:29 2023
Version 19.15.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.connected to target database: TDHLYL (DBID1578450313)RMAN RMAN show snapshot controlfile name;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TDHLYL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/snapcf_tdhlyl2.f; # defaultRMAN exitRecovery Manager complete.
[oraclecxlrac02 ~]$ 二、RAC修改snapshot controlfile 参数
在其中一节点下进行参数修改CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘DATAC1/TDHLBG/snapcf_tdhlyl.f’;
[oraclecxlrac01 ~]$ rman target /Recovery Manager: Release 19.0.0.0.0 - Production on Tue Nov 28 14:46:48 2023
Version 19.15.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.connected to target database: TDHLYL (DBID1578450313)RMAN RMAN RMAN show snapshot controlfile name;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TDHLYL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/snapcf_tdhlyl1.f; # defaultRMAN RMAN CONFIGURE SNAPSHOT CONTROLFILE NAME TO DATAC1/TDHLYL/snapcf_TDHLyl.f;new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO DATAC1/TDHLYL/snapcf_TDHLyl.f;
new RMAN configuration parameters are successfully storedRMAN show snapshot controlfile name;RMAN configuration parameters for database with db_unique_name TDHLYL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO DATAC1/TDHLYL/snapcf_TDHLyl.f;RMAN RMAN exitRecovery Manager complete.
[oraclecxlrac01 ~]$ 在第二节点确认参数信息
[oraclecxlrac02 ~]$
[oraclecxlrac02 ~]$ rman target /Recovery Manager: Release 19.0.0.0.0 - Production on Tue Nov 28 14:48:29 2023
Version 19.15.0.0.0Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.connected to target database: TDHLYL (DBID1578450313)RMAN RMAN show snapshot controlfile name;using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TDHLYL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO DATAC1/TDHLYL/snapcf_tdhlyl.f;RMAN exitRecovery Manager complete.三、字典表确认以及测试
select * from V$RMAN_CONFIGURATION;
在 AnyBackup 控制台重新发起备份任务进行测试。
