Different restore and recovery scenario for PDB and CDB in Oracle 12c

Introduction The next document will describe the steps to restore scenario for CDB and PDB using Data protector and RMAN 1.New SYSBACKUP privilege in RMAN 12c 1.1 create common user in CDB with sysbackup privilege. [oracle@rac1 ~]$ export ORACLE_SID=orcl1 [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 9 19:56:36 2017Continue reading Different restore and recovery scenario for PDB and CDB in Oracle 12c

Restore Database with PDB PITR Oracle 12c

1 Introduction The next document will describe the steps to restore database with CDB and PDB point in time using Data protector and RMAN.   2.  Restore Database with PDB PITR using command prompt (Best/Preferred way)   [oracle@orclbkp admin]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon Jun 26 21:32:29 2017 CopyrightContinue reading Restore Database with PDB PITR Oracle 12c

Database point in time recovery using Data protector and RMAN

1 Introduction The next document will describe the steps to restore database point in time using Data protector and RMAN   2. Restore using data protector console   2.1. Restore screen shot       3.  Restore Database PITR using command prompt (Best/Preferred way)   3.1  Restore database 1st incarnation (No need to reset incarnation)Continue reading Database point in time recovery using Data protector and RMAN

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/orContinue reading Database corrupt block recovery using RMAN

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