rman command reference

##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; CREATE CATALOG; ## Register Database###### Rman target / catalog rman_dba/rman_dba@<catalog> […]

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 RCATT database. 3.Please create controlfile from […]

RMAN incremental Backup cumulative and differential

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 To be able to recover changes to objects created with […]

Database corrupt block recovery using RMAN

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 (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. […]

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 and control_files loction   BKPTSTC.__data_transfer_cache_size=0 BKPTSTC.__db_cache_size=939524096 […]