Backup

  1. Home
  2. Backup
by Team Ajara

Script to take Oracle DB full backup using networker

Script Script on Unix server to take Oracle DB full backup using networker File name: full_bkp_ORCL.sh   LOGDATE=`date +”%m_%d_%y_%H_%M”` export LOGDATE ORAENV_ASK=NO ORACLE_SID=$1 export ORACLE_SID . /usr/local/bin/oraenv >/dev/null DB=${ORACLE_SID} export
by Team Ajara

Networker backup software installation on ODA

Networker backup software Installation on Oracle Database Appliance Networker is backup software that is used to take database backups of Oracle and MSSQL, etc It is a backup software similar
by Team Ajara

Error while creating Restore Point

Error while creating Restore Point. Error: SQL> create restore point before_patch guarantee flashback database ; create restore point before_patch guarantee flashback database * ERROR at line 1: ORA-38784: Cannot create
by Team Ajara

Restoring COLD backup in the same location

Restoring COLD backup in the same location. Scenario with Networker Media Manager. Step 1 : Move SPFile for scenario purpose: [oracle@oratst0001 dbs]$ mv spfilevirtualdb.ora spfilevirtualdb.ora2 [oracle@oratst0001 dbs]$   Step 2
by Team Ajara

Recovering NOLOGGING Tables and Indexes Scenario

Recovering NOLOGGING Tables and Indexes Scenario.   Step 1: Create table and insert data. ================================================== SQL> alter table pqrs.xyz nologging; Table altered. SQL> insert into pqrs.xyz values (20); 1 row
by Team Ajara

Recovering After the Loss of Archived Redo Log Files

Recovering After the Loss of Archived Redo Log Files Scenario: Step 1: Verify Archives: SQL> archive loglist =========================================================== SQL> select 1* select NAME,ARCHIVED,DELETED,STATUS from v$archived_log SQL> / NAME ARC DEL
by Team Ajara

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
by Team Ajara

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
by Team Ajara

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:
by Team Ajara

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