All posts

  1. Home
  2. All posts
    3. (
  3. Page 6
    4. )
by Team Ajara

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

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

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

Introduction to SQL in Oracle.

Introduction to SQL in Oracle.   SQL was invented and developed by IBM in the early 1970’s. SQL stands for Structured Query Language. IBM was able to demonstrate how to
by Team Ajara

Yearly partitions in Oracle database

How to create and maintain Yearly partitions in Oracle database.   Creation of range partition Creating a table with Yearly Partitions CREATE TABLE “IC_OWNER”.”ESTIMATE” ( “ESTIMATE_SK” NUMBER(*,0), “ESTIMATE_VER_NBR” NUMBER(20,0), “ESTIMATE_NBR”
by Team Ajara

Script to display ASM disk group usage

Script to display ASM disk group usage. SQL> l 1   SELECT 2   name , state 3   ,group_number 4   , total_mb/1024 total_mb 5   ,(total_mb – free_mb)/1024
by Blog Writer

Oracle Basic Commands for Beginners

Oracle Basic Commands for Beginners. To practice oracle basic commands, first install Oracle database on home computer/laptop. Follow the below link. Oracle 19c Installation on Windows Now start practicing below
by Blog Writer

Oracle 21c Installation on Windows

Oracle 21c Installation on Windows. In google, search to “Download Oracle 21c Software on windows”, then you will get the below link. Click on the link. Then you need to
by Team Ajara

Oracle 19c Installation on Windows

Oracle 19c Installation on Windows. In google, Search to “Download Oracle 19c software on windows”, then you will get the below link. Click on the link. Then you need to
by Team Ajara

Wallet open and close in Transparent Data Encryption

wallet STATUS is not reflecting when it is closed. To Close the wallet SQL>ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE; keystore altered. Verify the STATUS  of wallet SQL>Select WRL_TYPE,STATUS ,WALLET_TYPE from