Dream of Mirror Ruins

Flashback DataGuard Database Oracle Database - 11.2 Snapshot Standby Convert to snapshot standby. SQL> alter database recover managed standby database cancel;Database altered.~]$ srvctl stop database -d cocostdSQL> startup mountORACLE instance started.Total System Global Area 3941736448 bytesFixed Size 2259280 bytesVariable Size 905971376 bytesDatabase Buffers 3019898880 bytesRedo Buffers 13606912 bytesDatabase mounted.SQL> selec...

ORA-00925 SYMPTOMS ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 11 13:34:07 2024Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-09925: Unable to create audit trail fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 9925ORA-01075: you are currently logged on CAUSE The audit_file_dest directory does not exist or has insufficient permission. SOLUTION ~]$ mkdir -p $ORACLE_BASE/admin/coco/adump~]$ chmod 750 $ORACLE_BASE/ad...

RMAN-05001 SYMPTOMS ~]$ rman target sys/oracle@coco1 auxiliary sys/oracle@cocostd1Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 10 20:29:02 2024Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: COCO (DBID=3082357723)connected to auxiliary database: COCO (not mounted)RMAN> duplicate target database for standby from active database;Starting Duplicate Db at 10-FEB-24using target database control file instead of recovery...

CRS-5019 APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Enterprise Edition - Version 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.4.0 SYMPTOMS "/u01/app/11.2.0/grid/log/oracle11grac03/alertoracle11grac03.log"2024-02-10 09:17:05.240:[/u01/app/11.2.0/grid/bin/oraagent.bin(27008)]CRS-5019:All OCR locations are on ASM disk groups [OCR], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/u01/app/11.2.0/grid/log/oracle11grac03/agen...

Adding and Deleting Cluster Nodes for 11g Adding Cluster Nodes for 11g Prerequisite Steps for Adding Cluster Nodes Make physical connections. Install the operating system. Create Oracle users. Ensure that SSH is configured on the node. Verify the hardware and operating system installations with the Cluster Verification Utility (CVU). cluvfy comp peer [-refnode ref_node] -n node_list [-orainv orainventory_group] [-osdba osdba_group] [-verbose] Adding a Cluster Node on Linux and UNIX Syst...

INS-20802 Oracle Cluster Verification Utility failed APPLIES TO Operating System - Oracle Linux Server 7.9 Oracle Database - Version 11.2.0.4.0 Oracle Grid Infrastructure - Version 11.2.0.4.0 SYMPTOMS runInstaller (OUI) reports INS-20802 while running Oracle Cluster Verification Utility post check: INFO: ERROR:INFO: PRVG-1101 : SCAN name "rac-scan" failed to resolveINFO: ERROR:INFO: PRVF-4657 : Name resolution setup check for "rac-scan" (IP address: 192.168.3.125) failedINFO: ERROR:INFO...

Installing Oracle Database 11.2.0.4 RAC on RHEL 7.9 Operating System: Red Hat Enterprise Linux Server release 7.9 (Maipo) Oracle Database: p13390677_112040_Linux-x86-64_{1..3}of7.zip Packages Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel gcc \libxcb libibverbs make sm...

p4547809_92080_Linux-x86 ・ p4547809_92080_Linux-x86_README Record

p19955028_112040_Linux-x86-64 ・ p19955028_112040_Linux-x86-64_README Record Upgrade OPatch utility version to 11.2.0.3.6 or later. ~]# /u01/app/11.2.0/grid/OPatch/opatch versionOPatch Version: 11.2.0.3.4OPatch succeeded.~]# /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch versionOPatch Version: 11.2.0.3.4OPatch succeeded.~]# mv /u01/app/11.2.0/grid/OPatch{,.bak.`date +%m%d`}~]# mv /u01/app/oracle/product/11.2.0/db_1/OPatch{,.bak.`date +%m%d`}~]# unzip -q /soft/p6880880_112000_Linux-x86-64_...

Migrate Oracle Database 11.2 RAC by DataGuard Physical Standby Oracle Database - 11.2.0.4.0 RAC Introduction 主备数据库都是 Oracle 11gR2 RAC 环境，数据库文件目录架构一致。采用 Maximum Performance 方式，即日志同步采取 ASYNC noaffirm 方式。 本次配置以迁移为目的，所以主库不配置 switchover failover 相关参数。 主库 备库 操作系统 Redhat 7.9 Redhat 7.9 主机名 oracle11grac01,oracle11grac02 oracle11grac03,oracle11grac04 数据库版本 11.2.0.4 11.2.0.4 集群版本 11.2.0.4 11.2.0.4 DB_NAME coco coco DB_UNIQUE_NAME coco cocostby instance_name coco1, coco2 c...