When I tried to duplicate one of the databases using the RMAN duplicate, I’ve encountered the block corruption errors on the SYSAUX tablespace. The root cause of corruptions is still unknown to me. With further investigation, I’ve learned that the corrupt blocks do not belong to any objects. (The query used to identify them will …
RMAN Duplicate Failed – Need to Format Corrupt Block Not Part of Any Segment Read More »
During a new setup of our 11g R1 (11.1.0.7) on Solaris platform, initially the system is provided with only single path to disks (LUNs) on SAN. Later the sys admins would like to enable the multipathing. 🙁 Obviously, it is expected that the disk paths will be changed. This will not only affect the ASM …
Last week we’ve encountered the archived-log-gap-missing issue on Oracle 10.2.0.3 physical standby. Looking from V$MANAGED_STANDBY, it showed waiting for gap of the archived log sequence #53713. SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS ——— ———— ———- ———- ———- ———- ARCH CONNECTED 0 0 0 0 ARCH …
Oracle 10.2.0.3 Gap Resolution of Physical Standby Appears to Hang Read More »
Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment. In order for database to use Automatic Storage Management …
Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox Read More »
I found this tip from Oracle document while looking for a solution for session hung at the SQL prompt after issuing “alter tablespace read only”. Usually “alter tablespace read only” executes very quickly. However, the likelihood cause of waiting for tablespace to become read-only is due to existing in-flight transactions started before “alter tablespace read …
