Wednesday , July 26 2017

TimeLine Layout

July, 2017

  • 20 July

    ORA-01102: cannot mount database in EXCLUSIVE mode

    ORA-01102 ORA-09968 Error While Starting Oracle Database:

    Read More »
  • 20 July

    Cron tab scheduling command in linux

    CRON  TAB SCHEDULING COMMAND IN LINUX: What is cron tab: It’s a unix utility that allows task to be automatically run at desired intervals regularly or as given command in the background in word,scheduling task are calls in unix as cron job or cron task. it’s great feature of unix, …

    Read More »
  • 19 July

    How to change the SGA_TARGET & SGA_MAX_TARGET in Oracle

    ****  ENABLE SGA_TARGET *****  

    Read More »
  • 18 July

    DATA BASE LINKS

    DATABASE LINKS: What are the db links? create a link from one database to another database is called a database links.database link facilities accessing of the data existing in remote server from A server. PREREQUISITES: you must need  have the CREATE DATABASE LINK system privileges. you must need  have the …

    Read More »
  • 7 July

    How to Change in SQL Prompt with your name ?

    how to change SQL prompt: [rootdbcentre5 ~]# su – oracle [oracle@dbcentre5 ~]$ cd $ORACLE_HOME/sqlplus/admin [oracle@dbcentre5 admin]$ ls glogin.sql      libsqlplus.def        plustrce.sql    pupbld.sql [oracle@dbcentre5 admin]$ vi glogin.sql set sqlprompt ‘&_user>’    [ text on this script] — Copyright (c) 1988, 2005, Oracle. All Rights Reserved. — …

    Read More »
  • 7 July

    RMAN INCREMENTAL BACKUPS

    RMAN INCREMENTAL BACKUPS: Incase of incremental backup , rman takes the backup of only modified blocks. The different levels of incrementals are: level 0  [ complete backup] level 1   [incremental backup] level2   [cumulative] Incremental  backup is also called as diffrenial backup. level 0 is the base  base backup …

    Read More »
  • 7 July

    TAKING THE BACKUP OF ARCHIVELOGS IN RMAN

    RMAN> list archivelog all; List of Archived Log Copies for database with db_unique_name DBC ===================================================================== Key Thrd Seq S Low Time ——- —- ——- – ——— 19 1 2 A 01-JUL-17 Name: /u01/app/oracle/fast_recovery_area/DBC/archivelog/2017_07_05/o1_mf_1_2_doryt2co_.arc 182 1 3 A 05-JUL-17 Name: /u01/app/oracle/fast_recovery_area/DBC/archivelog/2017_07_05/o1_mf_1_3_dos783g5_.arc 199 1 4 A 05-JUL-17 Name: /u01/app/oracle/fast_recovery_area/DBC/archivelog/2017_07_05/o1_mf_1_4_dos7kv2s_.arc RMAN> RMAN> backup …

    Read More »
  • 7 July

    loss of full database in rman catalog mode

      LOSS OF FULL DATABASE USING  RMAN CATALOGMODE: Catalog is seperate database and it is repository of all target databse .we can register any number of  databases into recovery catalog . In this backup information at will be seperate datbase . STEP 1:  REPORT SCHEMA : RMAN> report schema; Report …

    Read More »
  • 6 July

    VIRTUAL PRIVATE CATALOG(11G)

    VIRTUAL PRIVATE CATALOG: In   11G  oracle as introduced virtual private catalog. Prior to 11g ,A single recovery catalog can be used by multiple users to give and modified the records in the Recovery catalog. Using A single Recovery catalog by multiple users may lead to security consult .To overcome this …

    Read More »
  • 6 July

    RMAN CONFIGURE IN CATALOG MODE

    RMAN CONFIGURE IN CATALOGMODE :  [root@dbcentre4 ~]# su – oracle [oracle@dbcentre4 ~]$ ps -ef|grep smon oracle 19559 19524 0 10:39 pts/1 00:00:00 grep smon [oracle@dbcentre4 ~]$ ps -ef|grep pmon oracle 19561 19524 0 10:39 pts/1 00:00:00 grep pmon STEP 1:  CREATE  ONE DATABASE: STEP 3: CREATE ONE USER & BASE TABLES: …

    Read More »