In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount of space is less that the actual database as it stores the pages that have changed, it has a copy of the page before the change was made. The snapshot database is a read-only database. … Continue reading Database snapshot
Tag: clone
How to clone a database manually?
Using the following steps one can clone a database manually. In the following example PRD represents the source and DEV represents target/new database. 1) Get list of datafiles on the PRD database. In the following example this database has 3 datafiles. SQL> SELECT name FROM v$datafile; NAME -------------------------------------------------------------------------------- /u03/oradata/PRD/system01.dbf /u03/oradata/PRD/undotbs01.dbf /u03/oradata/PRD/sysaux01.dbf 3 rows selected. 2) … Continue reading How to clone a database manually?
Clone a database with RMAN
Duplicating a Database using RMAN - (UNIX / Linux) PMMPRD to PMMQA1 Pre-requisites A valid full database backup of the target database $rman target sys/xxxx@pmmprd.world catalog rman/xxxxx@recprd RMAN> list backup summary; Target database must be mounted or open (Target means PMMPRD) $ sqlplus "/ as sysdba" SQL> startup open Steps Required Create Password File for … Continue reading Clone a database with RMAN
How to create a NetApp FlexClone RAC Database
In the past I used these procedures to create a FlexClone Oracle RAC database. Mainly for refreshing a data-warehouse from production. 1- Create pfile from spfile production create pfile='/home/oracle/create_clone/initCDWD.ora' from spfile; create pfile='/home/oracle/create_clone/initCDWQ.ora' from spfile; 2- Create backup control file to trace alter database backup controlfile to trace as '/home/oracle/backup_controlfile/ct_CDWP_resetlogs_151106.sql' resetlogs; (WE USE THIS ONE … Continue reading How to create a NetApp FlexClone RAC Database
alexlima.com 