How to Copy ASM datafile From Primary Database to Standby Database on ASM
Method: 1 On Primary database:- Step 1:- Take an copy of the file to normal file system RMAN > Copy datafile ‘‘ to ‘‘ ;…
Category: Oracle Database
How to move ASM database files from one diskgroup to another
The steps involved in moving a datafile from a diskgroup to another is as given below. 1) Identify the data file to be moved. 2)…
Database Cloning to Different Host through RMAN
Assumed Source database names: Host: SUN1 Primary Database SID: PROD Data file mount Point: /DB/PROD Assuming Target Database: Host: SUN2 Primary Database SID: CLONE Data…
Database Cloning to Same Host through RMAN
Assumed Source database names: Host: SUN1 Primary Database SID: PROD Data file mount Point: /DB/PROD Assuming Target Database: Host: SUN1 Primary Database SID: CLONE Data…
Database Cloning to Same Host through Cold Backup
Source database Details: Host: SUN1 Database SID=PROD Data file Mount Point = /DB/PROD Target (Clone) Database Details: Host: SUN1 Database SID=CLONE Data file Mount Point:…
What is a Cloning?Why Export/import is not suitable for Cloning?Method behind the Cloning?Reason for Cloning?Steps involve in cloning?Difference between cloning and Refreshing ?
What is a Cloning? Cloning is a process to create an exact copy of oracle database without using export/import. This method is used by DBAs…
Case 2: All control files lost
What if you lose all your control files? In that case you have no option but to use a backup control file. The recovery needs…
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…
Case 5: If all database lost and we have no backup of newly created data file.
Step 1 Restore database and mount the database Step 2 Recover the database SQL> recover database using backup controlfile; Step 3 Check file status SQL>…
Case 4: Lost datafile and No backup (When database abnormal terminated)
Step 1 Startup the database with mount option SQL> startup mount Step 2 Recreate datafile SQL> alter database create datafile ‘’ as ‘’ size ;…