Bugra Canbakal's Oracle Blog

  • Home
  • Contact
  • SITE MAP
You are here: Home / Archives for Bugra Canbakal

Creating standby database fast and easy

05:17 AM By Bugra Canbakal 8 Comments

1.PURPOSE AND SCOPE

With 11gR2 rman duplication its really easy to create standby database.

2.PRACTICE

Information Primary Database SID: PRIM Primary Database Domain/IP: ABSO Standby Database SID: PRIM_SBY Standby Database Domain/IP: CROO

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle, Standby - Dataguard Tagged With: oracle duplicate, oracle standby installation, standby, switchover

Data Guard Broker installation, configuration, monitoring and deactiving

06:05 AM By Bugra Canbakal 3 Comments

1.PURPOSE AND SCOPE

Oracle Data Guard broker software install with oracle database software and program bin file could find at $ORACLE_HOME/bin/dgmgrl location. Benefit of dgmgrl is most of the actions on primary/standby database can be done easyly through this tool, especilly switchover and managing primary/standby database.

2. IMPORTANT

When you are using the Broker to maintain your Data Guard configuration you must use either the Broker command line interface ‘DGMGRL’ or Grid Control to make any changes to your Data Guard configuration.  If you desire to use SQL*Plus then you should remove the the Data Guard Broker configuration using the ‘REMOVE CONFIGURATION PRESERVE DESTINATIONS’  command in DGMGRL. Then  you must  set the DG_BROKER_START parameter to ‘FALSE’ on all database in the configuration.

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle, Standby - Dataguard Tagged With: broker, data guard broker, dataguard, failover, oracle broker, switchover

Checking the status of disk usage on OS with the help of external table

10:32 AM By Bugra Canbakal 2 Comments


1.PURPOSE AND SCOPE

At this artichle i am going to explain how to check disk capacity and usage while using external table option.

Ps: I just test it on HP-UX and Linux servers.

 

2.PRACTICE

2.1. First of all we need to play output of df command. Our purpose is to eliminate space and tab on out and we will change them to comma.And also at script we are not going to take first line of output and we need to eliminate % character.After we eliminate % character we can save this coloum as a number at table and create some alert metrics for ourself. On the below i am going to provide normal df -Pk output and new version of it to save our table as like i talked about it.And i am going to save this output to df.log for other steps. [Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: database üstünden disk durumu, hpunix disk usage, linux disk usage, oracle.external table

Oracle 12c Database download

03:47 AM By Bugra Canbakal Leave a Comment

At last oracle 12c database and grid infrastructure(linux versions) ready to download.

https://edelivery.oracle.com/

 

Oracle PL/SQL
1
2
3
4
5
6
7
8
9
10
11
12
[oracle@12c ~]$ sql
 
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 26 23:05:30 2013
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
SQL>

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: 12c, 12c database, oracle

11.2.0.3 Auto archivelog deletion bug

08:45 AM By Bugra Canbakal Leave a Comment

1.PURPOSE AND SCOPE

Solving the Oracle 11.2.0.3 version auto archivelog deletion problem

2.PRACTICE

2.1. At Oracle 11.2.0.3 version there is a bug related with deleting archivelogs. Normally when FRA is need a space ,it need to check archivelogs which  can be deleted but because of the bug it doesn’t control which archivelogs can it be deleted ,you need to execute a dbms package to refresh the view. [Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: 11.2.0.3, archivelog bug, archivelog deletion.archivelog deletion bug, bug, oracle

User managed backup and restore

08:37 AM By Bugra Canbakal Leave a Comment

1.PURPOSE AND SCOPE

In this article, we are going to take user managed backup and try to restore it until spesific time.

2.PRACTICE

2.1. Lets start with backup side of user managed backup/restore.Before starting to copy tablespaces we need to changing the status of tablespaces.By the way you dont need to change the status of tablespaces like me by one by one, you can use “ALTER DATABASE BEGIN BACKUP;” command to take all of them backup mode.

Oracle PL/SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
[oracle@sb]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 18 10:21:38 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> select 'alter tablespace '||TABLESPACE_NAME||' begin backup;' from SYS.DBA_DATA_FILES;
'ALTERTABLESPACE'||TABLESPACE_NAME||'BEGINBACKUP;'
-------------------------------------------------------------
alter tablespace USERS begin backup;
alter tablespace UNDOTBS1 begin backup;
alter tablespace SYSAUX begin backup;
alter tablespace SYSTEM begin backup;
alter tablespace EXAMPLE begin backup;
alter tablespace MGMT_ECM_DEPOT_TS begin backup;
alter tablespace MGMT_TABLESPACE begin backup;
alter tablespace MGMT_AD4J_TS begin backup;
8 rows selected.
SQL> alter tablespace USERS begin backup;
Database altered.
SQL> alter tablespace UNDOTBS1 begin backup;
Database altered.
SQL> alter tablespace SYSAUX begin backup;
Database altered.
SQL> alter tablespace SYSTEM begin backup;
Database altered.
SQL> alter tablespace EXAMPLE begin backup;
Database altered.
SQL> alter tablespace MGMT_ECM_DEPOT_TS begin backup;
Database altered.
SQL> alter tablespace MGMT_TABLESPACE begin backup;
Database altered.
SQL> alter tablespace MGMT_AD4J_TS begin backup;
Database altered.

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle Tagged With: resetlog, user managed backup, user managed restore

Flashback database

12:04 PM By Bugra Canbakal 4 Comments

1.PURPOSE AND SCOPE

It is posible to fix the logical errors, with using flashback database technology but for sure time period of this kind of operations depends of flashback time of database.While using flashback technology we can use time,log sequence or SCN.

P.S: Disk failure and deletion of datafile/redo/control file  cant be restored with technology.

2.PRACTICE

2.1. We are going to connect to closed db and open flashback option.

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: RMAN, Single Node Tagged With: flashback, oracle flashback, resetlogs

UTL MAIL: Installation of package which helps to send email through database

08:45 AM By Bugra Canbakal 2 Comments

1.PURPOSE AND SCOPE

We need to install utlmail and prvtmail scripts to send email through databases,with help of these script we are going to create some synonyms and packages. After installation of script  we need to set smtp server parameter and grants.

2.PRACTICE

2.1. Going to connect database through sqlplus and starting utlmail.sql script.

2.1.1. Content of utlmail.sql

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle, Single Node Tagged With: CES, database email, ORA-06502, ORA-06512, UTL_MAIL

Installation of Logical Standby

11:46 AM By Bugra Canbakal Leave a Comment

1.PURPOSE AND SCOPE
At another article of mine ,I explained  installation of Physical standby and this article we are going to convert physical standby database to logical standby.

2.PRACTICE

2.1. At primary database we need to execute a query to see which tables are not supported by logical standby

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle, Standby - Dataguard Tagged With: dataguard, logical dataguard, logical standby

Add a new disk to asm diskgroup

12:43 PM By Bugra Canbakal 4 Comments

1.PURPOSE AND SCOPE

In this article i am going to explation how to add new disk to the diskgroup which used by database.Before starting i wanted to give some informations about our steps. In this practice we had got a disk named DISK4 and this isnt belong to single diskgroup.First of all i am going to check the stability of DISK4, if disk success i am going to create a different diskgroup and try to add it there.If this step also succeed we are going to add this disk to diskgroup which used by production diskgroup.

2.PRACTICE

2.1. Time to control stability of  DISK4 . (If you have got RAC env, you need to do this every single node)

[Read more…]

Share this:

  • LinkedIn
  • Twitter

Filed Under: Oracle, RAC - Real Application Cluster, Single Node Tagged With: asm, disk, diskgroup, new diskgroup

Next Page »

About Me



Language:

  • English
  • Turkish

Categories

  • Oracle
    • RAC – Real Application Cluster
    • RMAN
    • Single Node
    • Standby – Dataguard
  • OS
    • Linux

Blogroll

  • Emre Baransel
  • Gökhan Atıl
  • H. Tonguc Yılmaz
  • Kamil Türkyılmaz
  • Tanel Poder
  • Turkce Oracle
  • Turkish Oracle User Group
  • Uwe Hesse
  • Zekeriya Beşiroğlu

Archives

  • April 2014
  • March 2014
  • August 2013
  • June 2013
  • March 2013
  • January 2013
  • December 2012
  • November 2012
  • July 2012
  • June 2012
  • May 2012
  • January 2012
  • November 2011
  • October 2011
  • August 2011
  • July 2011
  • June 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • June 2010
OCP
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

[footer_backtotop]

Copyright © 2010-2014 Bugra Canbakal. All rights reserved.