How to move a datafile from a file system to ASM?
Create Case 1. create datafile in local file systemExample: alter tablespace users add datafile ‘/export/home/oracle/oracle/anup.dbf’ size 100m; 2. view the datafile location: SQL> select name…
Category: ASM
Implement ASM Instance on Solaris
Now we are ready to implement ASM Instance on Solaris. We divided all task in following Section: Section A: Prepare/Install RHEL Machine Section B: Install…
Move / Relocate Database to Different Disk Group
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 Task: We move or relocate…
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…
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.…
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…
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…
Rebalancing Concep
• “Rebalancing” is the process of moving file extents onto disks • Purpose of rebalancing is evenly distributing the I/O load of the diskgroup •…