Recover oracle DB after loss of datafiles scenarios

Recovering oracle DB after loss of datafiles scenarios. Scenario 1: Loss of system datafile =========================== Step 1: Remove System File for scenario purpose: SQL> show parameter db_name NAME TYPE VALUE

ORA-19554: error allocating device, device type

ORA-19554: error allocating device, device type: SBT_TAPE, device name: RMAN> run { ALLOCATE CHANNEL C1 DEVICE TYPE SBT_TAPE PARMS 'BLKSIZE=1048576, SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so, SBT_PARMS=(CONFIG_FILE=/opt/dpsapps/dbappagent/config/oracle_ddbda.cfg)' FORMAT '%d_%U; BACKUP DATABASE; } using target database

Restore Oracle database from Cold backup

Restore Oracle database from Cold backup. Step 1: verify Backup Logs: Backup Logs =============================================================== including current SPFILE in backup set channel C1: starting piece 1 at 12-07-2018 08:01:00 channel C1:

Oracle DB Archive backup using DD boost data domain

Oracle Database Archive backup using DD boost data domain. contents of config file ==> oracle_ddbda.cfg cat /opt/dpsapps/dbappagent/config/oracle_ddbda.cfg DDBOOST_USER =ddboost_test DEVICE_HOST =oratst0001.ajara.tech DEVICE_PATH =/ddboost_test RMAN> run 2> { 3> ALLOCATE CHANNEL

Oracle DB HOT backup using DD boost data domain

Oracle Database HOT backup using DD boost data domain. contents of config file ==> oracle_ddbda.cfg cat /opt/dpsapps/dbappagent/config/oracle_ddbda.cfg DDBOOST_USER =ddboost_test DEVICE_HOST =oratst0001.ajara.tech DEVICE_PATH =/ddboost_test $ rman target / Recovery Manager: Release

Oracle DB COLD backup using DD Boost data domain

Oracle Database COLD backup using DD Boost data domain. Media Manager= DD BOOST $ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Wed Dec 5 05:32:34 2018 connected

Recovery of Read-Only Files with a Re-Created Control File

Recovery of Read-Only Files with a Re-Created Control File 1* select name ,status,enabled from v$datafile SQL> / NAME STATUS ENABLED ---------------------------------------------------------------------- ------- ---------- /u01/app/oracle/oradata/virtuald_COLD_restore/system01.dbf SYSTEM READ WRITE /u01/app/oracle/oradata/virtuald_COLD_restore/sysaux01.dbf ONLINE READ