RMAN: Restore Concept
Use the RMAN RESTORE command to restore the following types of files from copies on disk or backups on other media: • Database (all datafiles)…
Category: Oracle Database
Different Type of Recovery
Complete Recovery Complete recovery can be done with the database OPEN unless the SYSTEM or UNDO tablespaces are damaged (this will terminate the instance). When…
Case 1: A multiplexed copy of the control file is available.
On startup Oracle must read the control file in order to find out where the datafiles and online logs are located. Oracle expects to find…
What is result cache in oracle Database with use case example?
In Oracle Database, the Result Cache is a feature that allows the caching of the results of SQL queries in memory. This caching mechanism can…
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…
How to copy a datafile from ASM to a file system by using dbms package
Step 1. Log onto the target database that is local to the ASM instance as the sys user. Step 2. create source directory within the…
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…
Handling Block Corruption in ASM Enable Database
Find corruption report on Alert log file. ORA-01578: ORACLE data block corrupted (file # 7, block # 65) ORA-01110: data file 7: ‘+DB_DATA01/INDIAN/DATAFILE/USERS.267.3’ Action Plan: 1. Take the data file (7) offline. SQL> alter database datafile 7 offline; 2. Use RMAN ‘BACKUP AS COPY…
How to Create Physical Standby Using RMAN Duplicate In ASM Filesystem For ASM Primary
Step 1: Pre-Requestsa) Database (PRIMARY) is up and running and the datafiles, controlfiles residing in ASM.b) ASM instance and diskgroups configured in STANDBY server.c) Network…
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…