Johannes Ahrends

Oracle

Recovery with RMAN is easy!

In this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. In my last blog “Backup and Recovery with RMAN is easy!” I wrote how easy it is to backup a database using RMAN if “Oracle” can take care of the file structure. The third blog will than give some details about database cloning / database restore. Let’s start with a curruped database first. Linux is very handy so to destroy or corrupt a data file you can simply use the following command: dd if=/dev/zero of=/u02/oradata/PAUL/88ECC48AE4632772E0530D63A8C04AEF/datafile/o1_mf_users_gfqznp2m_.dbf’ bs=8192 count=1000 Please don’t test

Recovery with RMAN is easy! Blogbeitrag lesen »

By • • 4 minutes of reading
Oracle

Backup and Recovery with RMAN is easy!

About 8 years ago I wrote a blog named: It’s so Easy to use RMAN for Backups. So it’s time for a revisit and to show how easy it is to restore a database. Oracle Managed Files (OMF) Let’s start with some easy tasks: the naming and location of Oracle database files. There might be some few reasons (e.g. Oracle 12.1 with Multitenant) why you want to explicitly name the data files. But for the majority of database its more useful to handle over naming to the Oracle database.There are three parameters: db_create_file_dest: The parameter specifies the location of data

Backup and Recovery with RMAN is easy! Blogbeitrag lesen »

By • • 5 minutes of reading
Oracle

No RAC for Standard Edition!

If you read through the actual Oracle 19c documentation, esp. the “Database Licensing Information User Manual” you might notice that for Standard Edition Two (SE2) the feature “Oracle Real Application Clusters” (RAC) is set to “N” (No). Anyone who – like me – thought this was a documentation bug is unfortunately wrong. After talking to some Oracle representatives I was told that starting with version 19 RAC is indeed no longer available for Standard Edition 2. Existing customers using RAC need to stay with version 18 or downgrade to single instance. More critical is that Version 19c is the long

No RAC for Standard Edition! Blogbeitrag lesen »

By • • 2 minutes of reading
Oracle

Oracle 12.2 Grid Inventory without NodeList

As most of you probably already know, the installation of Grid Infrastructure has changed with Oracle 12.2. The software has to be unpacked in the GRID_HOME and installed from there. In conjunction with this change the Oracle Inventory or more precise  inventory.xml file (mostly in the directory /u01/app/oraInventory/ContentsXML) has been changed as well. Up to Version 12.1 the nodes for all installed components (e.g. GI, Database, Client, etc.) have been listed in the NODE_LIST. But since 12.2 this information is no longer available. More information can be found in MOS: 12.2: Oracle inventory does not have references for cluster nodes (Doc ID 2264757.1).

Oracle 12.2 Grid Inventory without NodeList Blogbeitrag lesen »

By • • 2 minutes of reading
Oracle

Data Guard is easy

Data Guard is easy! Every Oracle database with a certain value for the business should be protected with a standby database. How you can set up a standby environment for Standard Edition Two will be covered in a dfiferent blog. Today the goal is to create a Data Guard configuration fast, easy and repeatable.

Data Guard is easy Blogbeitrag lesen »

By • • 7 minutes of reading
Uncategorized

Automatic Diagnostic Repository Management

With Release 11g Oracle introduced the concept of the Automatic Diagnostic Repository (ADR) which is an independent directory structure for all kinds of logs and traces for the database, listener and other Oracle products. The directory diag is located in $ORACLE_BASE so you should ensure that that variable has been set to the correct directory. If it’s not set the files will be stored in $ORACLE_HOME/diag.

Automatic Diagnostic Repository Management Blogbeitrag lesen »

By • • 3 minutes of reading
General

Oracle 12.2 Standby Database for Standard Edition Two

High Availability for Standard Edition Two It’s a nasty discussion whenver it comes to Desaster Recovery or High Availability with Standard Edition Two. Even though RAC is available there is no real Desaster Recovery as Oracle does not allow to use Data Guard. So the only real alternative today is dbvisit Standby. … and than Oracle released Multitenant Database!

Oracle 12.2 Standby Database for Standard Edition Two Blogbeitrag lesen »

By • • 3 minutes of reading
Scroll to Top