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 ...
Posted by phpnewbie81 on Fri, 06 Dec 2019 11:48:32 +0100
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 ...
Posted by cristal777 on Wed, 04 Dec 2019 05:47:04 +0100
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
Posted by john8m on Wed, 02 Oct 2019 03:53:29 +0200
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 ...
Posted by sargenle on Sun, 28 Jul 2019 12:51:33 +0200
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 ...
Posted by fredroines on Tue, 16 Jul 2019 18:34:20 +0200
OS: CentOS release 5.11
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 ...
Posted by thinguy on Tue, 14 May 2019 13:07:02 +0200
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 ...
Posted by maheshb on Wed, 08 May 2019 04:35:03 +0200