All posts

  1. Home
  2. All posts
    3. (
  3. Page 5
    4. )
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

How to disable diagnostic and tuning pack

To disable diagnostic and tuning pack : Step 1) show parameter control; Step 2) alter system set control_management_pack_access=none scope=both; Step 3) show parameter control; We can see the disabled diagnostic
by Team Ajara

Partitioning table based on Quarter

How to create and maintain a quarterly partitions for a Table?   Range partitions Creating a table with Quarterly Partitions CREATE TABLE "STG"."QPT" ( "QPT_NBR" NUMBER(*,0), "START_DT" DATE ) TABLESPACE
by Team Ajara

Partitioning table based on Month

How to create and maintain a monthly partitions for a Table?   Range partitions Creating a table with Monthly Partitions CREATE TABLE “FORM_STG”.”QPT” ( “NBR” number, “FORM_DATE” DATE ) PARTITION
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