RMANTag Archive

##Connecting RMAN############## rman TARGET SYS/target_pwd@target_str # connects in NOCATALOG mode rman TARGET / CATALOG rman/rman@rcat rman TARGET / CATALOG rman/rman@rcat AUXILIARY sys/aux_pwd@aux_str ##Create user and catalog in RMAN database ######## CREATE USER rman_dba IDENTIFIED BY rman_dba TEMPORARY TABLESPACE temp DEFAULT TABLESPACE rman_dba QUOTA UNLIMITED ON rman_dba; GRANT RECOVERY_CATALOG_OWNER TO rman_dba;… Continue Reading rman command reference

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… Continue Reading Database backup and restore after manual catalog RMAN backup

RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make incrementally updated backup .These incrementally updated backup will be used to make updated image copy will all roll forward image. 2.Reduce amount of time to take backup. 3.Save network bandwidth… Continue Reading RMAN incremental Backup cumulative and differential

1 Introduction The next document will describe the steps to recover corrupt block using RMAN   2. Recover block if datafile header is corrupted   2.1. Please check the physical corruption   [oracle@cdv1pradmdbv01 datafile]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon Jun 26 12:55:06 2017 Copyright… Continue Reading Database corrupt block recovery using RMAN

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… Continue Reading Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance