How to create ASM base groups

Creating ASM base groups: >> Before  creating ASM groups, we should check “labels” and “raw partition or disk partition.” NOTE: You can see that “TYPE=”oracleasm”” disks are already configured to be used for ASM groups. >> We will use ASMCA utility for creating ASM disk groups ASMCA stands for (Automatic …

Read More »

How to switch on primary database to physical standby database

After configuring dataguard, perform following operations to check whether the switching from primary database to standby database is happening or not. STANDBY DATABASE: <STEP 1> : Check below query to know whether standby database is mounted or not. < STEP 2> let me check ROLE,CONTROL FILE CHECKS: PRIMARY DATABASE: <STEP …

Read More »

ORA-01102: cannot mount database in EXCLUSIVE mode

ORA-01102 ORA-09968 Error While Starting Oracle Database: * Database alert log might show following error. thu 24 Jul 20 12:47 2017 ALTER DATABASE MOUNT sculkget: failed to lock /u01/app/oracle/product/11.2.0/dbhome_1/dbs/lkCRD exclusive sculkget: lock held by PID: 64 ORA-09968: unable to lock file Linux-x86_64 Error: 11: Resource temporarily unavailabl *You might have already …

Read More »

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 a great feature of …

Read More »

How to change the SGA_TARGET and SGA_MAX_TARGET in Oracle

 ****  ENABLE SGA_TARGET ***** MEMORY_TARGET : Dynamic MEMORY_MAX_TARGET : NotDynamic *Prior to 11g, Oracle manages PGA seperately by the pga_aggregate_target parameter. *Oracle introduces AMM feature from 11g which will manage SGA as well as PGA. *When we set MEMORY_TARGET, Oracle will dynamically assign memory to SGA and PGA Note : …

Read More »

Oracle Database 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 of …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe