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 operation is performed from the auxiliary […]
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 RCATT database. 3.Please create controlfile from […]
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 { backup as compressed BACKUPSET incremental […]
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 place this init file to $ORACLE_HOME/dbs […]
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=234881024 EBILDR12.__large_pool_size=5335154688 EBILDR11.__large_pool_size=5268045824 EBILDR11.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from […]
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 and control_files loction BKPTSTC.__data_transfer_cache_size=0 BKPTSTC.__db_cache_size=939524096 […]