Dream of Mirror Ruins

Installing Oracle Database 10.2.0.5 RAC on RHEL 5.7 Operating System: RHEL 5.7 Grid Infrastructure: 10201_clusterware_linux_x86_64.cpio Database Software: 10201_database_linux_x86_64.cpio Patches: p8202632_10205_Linux-x86-64.zip Pre-Installation Preparation and Verification Verifying and Updating the redhat-release File. ~]# rpm -q redhat-release~]# cp /etc/redhat-release /etc/redhat-release.orig~]# cat > /etc/redhat-release << EOFRed Hat Enterprise Linux AS release 3 (Taroon)EOF...

PROC-22 The OCR backend has an invalid format APPLIES TO Oracle Database - Version 10.2.0.5 RAC SYMPTOMS ~]# tail -n2 /var/log/messagesFeb 21 13:54:18 rac1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.3718.Feb 21 13:54:18 rac1 logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.3815.~]# cat /tmp/crsctl.3815OCR initialization failed with invalid format: PROC-22: The OCR backend has an invalid format CAUSE The OCR raw de...

su command fails with resource temporarily unavailable SYMPTOMS ~]# su - gridLast login: Mon Feb 19 12:15:34 CST 2024 on pts/0su: failed to execute /bin/bash: Resource temporarily unavailable CAUSE The maximum number of user processes exceeded the limit. ~]# ps h -Led -o user | sort | uniq -c | grep grid SOLUTION Increase the nproc values in /etc/security/limits.d/97-oracle-database-11g-limits.conf. ~]# cat >>/etc/security/limits.d/97-oracle-database-11g-limits.conf <<EOFgrid ...

High Availability Configuration Optimization 初始化参数： 配置 alternate 归档路径，通常是 LOG_ARCHIVE_DEST_1，防止归档目录满，导致数据库挂起。 配置 FAST_START_MTTR_TARGET 参数，减少故障恢复时间。 LOG_BUFFER 参数至少 128MB。 设置 SGA_TARGET 参数，启用自动共享内存管理，并将 USE_LARGE_PAGES 参数，设为 AUTO_ONLY 或 ONLY。 设置 ARCHIVE_LAG_TARGET 参数，定时触发日志切换归档。 Active Data Guard： 自动块修复，配置 LOG_ARCHIVE_CONFIG、LOG_ARCHIVE_DEST_n 和 FAL_SERVER 参数。 DB_BLOCK_CHECKSUM，推荐 DB_BLOCK_CHECKSUM=TYPICAL，最小开销。 DB_BLOCK_CHECKING，推荐 DB_BLOCK_CHECKING=MEDIUM，推荐先在备库上设置，没问题后再主库配置。 DB_LOST_WRI...

How To Check DataGuard Status Oracle Database - 11.2 Show the last archive produced in primary and the last archive applied to standby. SET linesize 200 pagesize 100SELECT a.thread#, b.last_seq prmy_last_file, a.applied_seq stdby_last_file, CASE WHEN b.last_seq - a.applied_seq > 2 THEN '=>' ELSE to_char(b.last_seq - a.applied_seq) END archive_difference, TO_CHAR (a.latest_apply_time, 'dd/mm/yyyy hh24:mi:ss') stdby_latest_time FROM (SELECT resetlogs_id, thread#, MAX(seque...

ORA-00245 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 Starting backup at 15-FEB-24using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-0...

Managing the Online Redo Log Creating Redo Log Groups and Members Creating Redo Log Groups. ALTER DATABASE ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 100M BLOCKSIZE 512; Creating Redo Log Members. ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.rdo' TO GROUP 2; Relocating and Renaming Redo Log Members SHUTDOWN IMMEDIATEmv /diska/logs/log1a.rdo /diskc/logs/log1c.rdomv /diska/logs/log2a.rdo /diskc/logs/log2c.rdoSTARTUP MOUNTALTER DATABASE RENAME FILE...

How to enable and disable flashback Oracle Database - Enterprise Edition - version 11.2.0.4.0 Enable flashback Make sure the database is in archive log mode. Refer: How to enable and disable archive log mode To enable flashback we need to set two parameters: DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE. SQL> alter system set db_recovery_file_dest='/home/oracle/app/oracle';System altered.SQL> alter system set db_recovery_file_dest_size=10g;System altered.SQL> show paramete...

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...