Transfer backup set from ASM to filesystem
We can create RMAN Backup set into Flash Recovery Area on ASM Disk. Bellow i am describing, how to transfer backup pices from ASM Disk…
Category: Oracle Database
Create Physical Standby on ASM for Non-ASM Primary
Source Setup Details: Host Name: SUN1 IP: 192.168.126.2 Oracle Home: /export/home/oracle/oracle/product/db_1 DB Name: INDIAN PORT: 1521 ASM DISK GROUP: /home/oracle/DB/database/INDIAN/ Target Setup Details: Host Name:…
Clone/Duplicate a ASM Enable Database to ASM Enable TARGET System
Source Setup Details: Host Name: SUN1 IP: 192.168.126.2 Oracle Home: /export/home/oracle/oracle/product/db_1 DB Name: INDIAN PORT: 1521 ASM DISK GROUP: DB_DATA01 Target Setup Details: Host Name:…
Clone/Duplicate Database from ASM to Non-ASM
Source Setup Details: Host Name: SUN1 IP: 192.168.126.2 Oracle Home: /export/home/oracle/oracle/product/db_1 DB Name: INDIAN PORT: 1521 Disk Group: DB_DATA01 Target Setup Details: Host Name: SUN2…
Clone/Duplicate Database from Non-ASM to ASM
Source Setup Details: Host Name: SUN1 IP: 192.168.126.2 Oracle Home: /export/home/oracle/oracle/product/db_1 DB Name: INDIAN PORT: 1521 DB Location: /export/home/oracle/DB/database/INDIAN Target Setup Details: Host Name: SUN2…
How to move a datafile from ASM to a file system
Can be performed in 2 Ways: While the database is in mount stage. While the database is running While the database is in mount stage.…
Create Physical Standby on Normal File System for ASM Primary
Source Setup Details: Host Name: SUN1 IP: 192.168.126.2 Oracle Home: /export/home/oracle/oracle/product/db_1 DB Name: INDIAN PORT: 1521 ASM DISK GROUP: DB_DATA01 Target Setup Details: Host Name:…
Other’s
ASM can work for RAC and non-RAC databases One ASM instance on a node will service any number of instances on that node If using…
What will you do, if RMAN metadata corrupt?
Error accord when we trying to mount the ASM disk Group. SQL> startup mount ORA-15032: not all alterations performed ORA-15063: diskgroup “” lacks quorum of…
Move ASM spfile to Different Disk Group
In 10gR2 Step 1 Create pfile from the current spfile $ sqlplus / as sysasm SQL> show parameter spfile SQL> create pfile=’/export/home/oracle/initINDIAN.ora’ from spfile; File…