Bugra Canbakal's Oracle Blog

You are here: Home / Archives for 2013

Archives for 2013

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

By 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…]

Oracle 12c Database download

By Leave a Comment

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

https://edelivery.oracle.com/

 

[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>

11.2.0.3 Auto archivelog deletion bug

By 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…]

User managed backup and restore

By 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@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…]

Flashback database

By 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…]