Minimalistic Oracle

Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.

Thursday, November 20, 2014

How to flash the database back to a guaranteed restore point

›
After a week of testing their new release, my customer wanted their database reset to the state it was previously in. Earlier this week, I...
Wednesday, November 19, 2014

How to increase the SMB space budget

›
When the message below shows up in the database alert.log, you should increase the SMB space budget. Message: SPM: SMB space usage (13523...
Monday, November 3, 2014

How to create a tarball - short description

›
To create a tarball, for example of an Oracle Home, do the following: # become root su - # cd to the directory in which you keep your fil...
Saturday, November 1, 2014

Step by step: how to switchover from primary to standby with Oracle 10g

›
Based on the guide found in the official Oracle 10g documents found here This is a classic Oracle 10g two-node Ph...
Wednesday, October 22, 2014

Step by step: how to create a physical standby database with Oracle 10g

›
I recently had to create an Oracle 10g standby database to support a simultaneous move and upgrade of the database...
Tuesday, October 21, 2014

How to view stored scripts in RMAN

›
Three different ways to print scripts stored in your recovery catalog: list all script names; list global script names; print script my_sc...
Friday, October 17, 2014

Script example: create database

›
CREATE DATABASE "mydb" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE...
‹
›
Home
View web version

About Me

My photo
Name: Vegard Kåsa
My career as an Oracle DBA startet in 2001, when I acceptet a request to take on the responsibility as my current employer's DBA. From that point and onwards, managing Oracle databases has kept me busy and engaged. I enjoy my work, and particulary appreciate the constant learning and devlopment that comes with the job. From 2014, I am self-employed through my company Oric Consulting AS (Norway), and from 2024 Oric Consulting AB (Sweden) I currently live in Göteborg, Sweden, with my family.
View my complete profile
Powered by Blogger.