Wednesday , July 26 2017

Blog Layout

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »