Active RMAN duplicate clone 12c using section size and compress backupset

Overview of New PULL method The original “push” process is based on image copies.With Oracle Database 12c, a “pull” (or restore) process is based on backup sets. A connection is first established with the source database. The auxiliary instance then retrieves the required database files from the source database as backup sets. A restore operationContinue reading Active RMAN duplicate clone 12c using section size and compress backupset

Database backup and restore after manual catalog RMAN backup

Database backup and restore after manual catalog RMAN backup 1.Please take backup of primary database ORCL rman target / nocatalog log=/tmp/rman_bkp.log << EOF1 run { backup as compressed backupset database format ‘/opt/app/oratest1/bkp/ORCL_%U’; backup as compressed backupset archivelog all format ‘/opt/app/oratest1/bkp/ORCL_ARCH_%U’; } exit; EOF1 Please copy it in backup location to /opt/app/oratest1/bkp 2.Please start nomount RCATTContinue reading Database backup and restore after manual catalog RMAN backup

Duplicate database until Point in Time recover, using backup location from RAC to single instance

Prepare by:  Nurullah Sharif Scope: Point in Time Recovery   Duplicate database until Point in Time recover, using backup location. #PointInTimeRecovery #DuplicateDatabase #RestoreDatabaseUsingBackupLocation   We are using full backup of 28-11-2017 and archivelog backup of 29-11-2017   Step 1: Take full backup and archive log backup. On target database : Rman target / run {Continue reading Duplicate database until Point in Time recover, using backup location from RAC to single instance

RMAN clone from data guard DR to different host and different backup location

This document describe the step to clone database in another host using RMAN from DR (Data gurad) .We need not to connect to source database.Moreover we will use different location for backup. A. Please follow below step for pre-requisites setup mentioned in below url 1.Copy the init parameter file from source . 2.In target placeContinue reading RMAN clone from data guard DR to different host and different backup location

RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in init file to make it compatible to single instance. Replace original instance name to target name in pfile .For my case it should EBILTST as target. ##Remove following parameters## EBILDR12.__data_transfer_cache_size=0 EBILDR11.__data_transfer_cache_size=0 EBILDR11.__db_cache_size=5939134464 EBILDR12.__db_cache_size=3154116608 EBILDR12.__java_pool_size=234881024 EBILDR11.__java_pool_size=234881024Continue reading RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance

1.Login to source database 2. Create temporary pfile from spfile of source database   2.1. create temporary pfile from spfile sqlplus / as sysdba SQL>create pfile=’/tmp/inittest.ora’ from spfile;     2.2. Change parameters in init parameter to fit target database   Please change all source database name to target database name and create audit_file_dest andContinue reading Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance