Programmer Think

Oracle Active Data Guard and Automatic Block Repair Starting in Oracle Database 11g Release 2 (11.2), the primary database automatically attempts to repair the corrupted block in real time by fetching a good version of the same block from a physical standby database. This capability is referred to as automatic block repair, and it allows corrup ...

The ABCR function of Oracle 11gr2 has been introduced. When a damaged database is retrieved, it will be automatically repaired. Now test whether the database will be automatically repaired when the database block is damaged and the instance is forced to close.First, test the general user table, baiyang.t'ou objs(I) current active and standby en ...

1. Backup databaseBoth RMAN and expdp can be used.2. Backup Software Directory (node1/2) tar -czvf /u01/grid.tar.gz /u01/app/11.2.0/grid --exclude=/u01/app/11.2.0/grid/rdbms/audit/* tar -czvf /u01/database.tar.gz /u01/app/oracle/ --exclude=/u01/app/oracle/admin/orcl/adump/* 3. Backup OCR (node1/2) [grid@vastdata01 ~]$ cd $ORACLE_HOME/bin [g ...

The positioning of this series is to study XTTS and related technologies in depth. As the beginning of this series, in line with the principle of practicality, I first refine and simplify the actual implementation plan of U2L migration in an actual production environment, aiming at clearly explaining how to use XTTS as a solution for U2L migrat ...

Oracle introduced the ADG (Active DataGuard) read-only mode DataGuard in 11g version to replace the DG mode in 10g, which can only be mount ed but cannot be opened. There are also some improvements in the way of building. This article lists two different ways of building and their differences in detail. General description of two DG constr ...

Environment-related: OS: CentOS release 5.11 IP: 192.168.77.10 MEM: 16G DISK: 50G 1. Brief description This blog post is actually a silent installation of the CentOS 5 system Oracle 10g in the production environment in use. This blog includes oracle Software silent installation, software upgrade, playing PSU, man ...

At ORACLE10g and 11g versions, the default log archive path for ORACLE is the flash-back recovery area ($ORACLE_BASE/flash_recovery_area).ORACLE has a limitation on this path: it only has 2G of space by default, and it is not only the default path for archive logs, but also the default address for backup files and flash back lo ...