• Oracle

    Oracle database Cloning-24

    Cloning Cloning is creating a same database as in different name and the DBID will be different. Use It mostly used to test the application functionality and new implementation. Methods of cloning Cold backup Hot Backup RMAN Backup (duplicated database / active database) Pre- Requirement Create a folder according to the versions. 11g: /opt/oracle (ORACLE_BASE ) –> (Admin , Oradata & diag) Admin –>DBname (adump, create, ddump & pfile) Oradata –> DBnames Diag –> RDMBS–>DBname–>DBname–>Trace (bdump,cdump & udump) All in under trace, but without folders Clod backup Cloning It’s an offline cloning. Go to source database. Pre- requesting: Note down the following. Sql> select name from v$datafile; Sql> select member…