rman auxiliary (for duplicate)

I just do some tests with the Oracle 12.2 Release and while doing tests it is all the time better to have a second database and that is the time for rman. So I looked around and found an easy way to duplicate a database from a Backup. Here the details:

My environment

OL 7.3 with an Oracle 12.2 + DATABASE BUNDLE PATCH: 12.2.0.1.170516 (25862693)

I setup an database via dbca and use Standards including the fast recovery area. Oh yes the FRA is a standard now

Next I did a backup and here I did a few tests with image copied and „backup as copy database“. While doing this I had a full backup on disk and that is the point to start with the duplicate.

What are the steps?

First I created a initdb2.dup

Yes, for testing I create only one controlfile
initdb2.dup
*.audit_file_dest='/u01/app/oracle/admin/db2_s1/adump'
*.audit_trail='NONE'
*.db_name='db2'
*.db_unique_name='db2_s1'
*.control_files='/u01/app/oracle/fast_recovery_area/db2_s1.ctl'
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_recovery_file_dest_size=8G
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.enable_pluggable_database=true
*.large_pool_size=256M
*.sga_target=2G

Next I created a few directories and then I started the new instance


sqlplus / as sysdba

startup nomount pfile=/u01/app/oracle/admin/db2/pfile/initd2.dup'

finally I start the duplicate from „BACKUP LOCATION“

 



rman auxiliary /

RMAN>duplicate database to db2 backup location '/u01/app/oracle/fast_recovery_area';

 

That’s it finished :-)

Keep in mind that I set my environment before starting the rman duplicate and the connection is done against the auxiliary instance. Yes, it is very easy to do a duplicate to a new database when you have a full backup on disc.

 

 

 

Advertisements
Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit , | Kommentar hinterlassen

Oracle Engineered Systems Production

I found a old video concerning the „real“ production of an Oracle Engineered System but it’s really good and cool stuff.

https://vimeo.com/46778003

Have fun

 

Veröffentlicht unter Engineered Systems, Exadata, General | Kommentar hinterlassen

neue DOAG Webseite ist online

Die neue DOAG Webseite ist Online.

https://www.doag.org/de/home/

 

 

Veröffentlicht unter General | Kommentar hinterlassen

Let’s start with Oracle Database 12c Release 2

bildschirmfoto-2017-03-02-um-13-40-33

Yes and now Oracle 12.2 is available (Linux x86_64) for download from OTN.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html

Let’s start with Installation and Setup ….

 

 

Veröffentlicht unter General, Oracle 12.2, Oracle Database | Verschlagwortet mit | Kommentar hinterlassen

Oracle DBSAT first experience

dbsat_chart

Last year in October Oracle released the Oracle Database Security Assessment Tool (DBSAT) to analyzes database configurations and security policies to improve the security in your environment.

Real benefits

  • quickly identify security configuration errors in the database environment
  • lauch Security best practices
  • increase the security level of your Oracle Databases
  • reduce the attack and exposure risk

What does DBSAT check

  • User Accounts, Privileges and Roles
  • Authorization Control
  • Data Encryption
  • Fine-grained Access Control
  • Auditing Policies
  • Database Configuration
  • Listener Configuration
  • Operating System*

Installation and Requirements

DBSAT runs on
Solaris x64 and Solaris SPARC
Linux x86-64
Windows x64
HP-UX IA (64-bit)
IBM AIX & zSeries Based Linux

Supported Database Versions
on Oracle Database 10.2.0.5 and later releases.

Download DBSAT
Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Installation and Setup

create directory on the target System
mkdir -p /home/oracle/dbsat

unzip dbsat.zip
unzip dbsat.zip -d /home/oracle/dbsat

cd /home/oracle/dbsat

Run the Collector

Set your Oracle environment

./dbsat collect „sys/manager as sysdba“ orcl

DBSAT Collector completed successfully.

Calling /u01/app/oracle/product/12.1.0/dbhome_1/bin/zip to encrypt orcl.json…

Enter password:

Verify password:

  adding: orcl.json (deflated 87%)

zip completed successfully

The .json file was created and is the base of the report

Create the report

./dbsat report orcl

Archive: orcl.zip
[orcl.zip] orcl.json password:
inflating: orcl.json
Database Security Assessment Tool version 1.0.2 (October 2016)
DBSAT Reporter ran successfully.

Calling /usr/bin/zip to encrypt the generated reports…

Enter password:
Verify password:
adding: orcl.txt (deflated 76%)
adding: orcl.html (deflated 82%)
adding: orcl.xlsx (deflated 3%)
zip completed successfully.

-rw——-. 1 oracle oracle 63075 Feb 1 22:22 orcl_report.zip

Transfer the files to your local PC

Here an example  I converted the XLS File as PDF

orcl

Start reviewing the security report and fix the critical findings

Summary

  • easy and fast setup
  • really good reports in  different layout (html, csv, etc.)
  • fix real security issues
  • no extra costs if you have a support contract
  • findings are highlighted (green, red, yellow, blue)

Note

While running dbsat in a 12c Multitenant environment you must create the report on every PDB, otherwise you will get only a report from the CDB

Try it and have fun :-)

 

 

 

Veröffentlicht unter General | Verschlagwortet mit | 1 Kommentar

What new?

Oracle_DB1

Interesting news about the coming Oracle 12 Release.

Release Schedule of Current Database Releases (Doc ID 742060.1)

Take a look :-)

Veröffentlicht unter Exadata, General, Oracle 12.2, Oracle Database | Kommentar hinterlassen

CFP für Exaday 2017 gestartet

exaday_2017-banner_468x180

Es geht los bis zum 13.2.2017 können Vorträge für den Exaday 2017 rund um das Thema Oracle Engineered Systems eingereicht werden

Ich freue mich auf viele spannende Vorträge …

http://exaday.doag.org/de/home/

Der Exaday 2017 findet dieses Jahr am 20. Juni 2017 in Frankfurt – Mörfelden statt

 

The Call for Paper is opened until 13.2.2017

Please submit for the Exaday 2017 all around the topic Oracle Engineered Systems

http://exaday.doag.org/de/home/

The Exaday 2017 will be this year on the 20 June 2017 in Frankfurt – Mörfelden (near by the airport)

 

 

 

 

Veröffentlicht unter Engineered Systems, Exadata | Verschlagwortet mit , , | Kommentar hinterlassen

Oracle Exadata Statement of Direction

There is a very interesting paper about the way of direction of the Exadata Database Machine.

http://www.oracle.com/technetwork/database/exadata/exadata-statementofdirection-2417679.pdf

 

Thanks a lot Günther Stürner.

Veröffentlicht unter Exadata, General | Kommentar hinterlassen

Exadata GI Upgrade 11.2.0.4 to 12.1.0.2 + PSU Jul2016

giupg

Recently I did a upgrade to Grid Infrastructure 12.1.0.2 on a few Exadata Clusters

Here my summary of the installation

Before you start please read the following MOS note 1681467.1. This note is very helpful and describes the whole procedure in a Exadata environment

It’s not only the Upgrade to 12.1.0.2. In the same „session“ I also install the GI PSU Jul 2016 and the Oneoff Patch 23273686 because there is a known BUG in the SCAN Listener area (see below)

At the end of the article some „real news“ from GI 12.1.0.2 (see below „real“ news)

So let’s start

First of all keep in mind that the clusterware must be „up and running”

Step 1 Oracle environment

 

 export SRVM_USE_RACTRANS=true 

 unset ORACLE_HOME ORACLE_BASE ORACLE_SID 

./runInstaller 

Step 2 GI Software Installation

The next slides show the GI Installation Procedure

gi_upg_1

gi_upg_2

gi_upg_3

gi_upg_4

gi_upg_5

gi_upg_6

gi_upg_7

gi_upg_8

gi_upg_9

gi_upg_10

gi_upg_12

gi_upg_13

If the Setup is at that point you need to do the following but

please don’t close the Installer window

Step 3 Install latest opatch tool

Download opatch tool  Patch 6880880 (better you did it before)

On a Exadata the Installation can be done in one step via dcli


dcli -l oracle -g dbs_group unzip -oq -d /u01/app/12.1.0.2/grid p6880880_121010_LINUX.zip -d /u01/patchdepot

Step 3 Install GI PSU JUL 2016 23273686


Node 1 srvdb01

[root@srvdb01]# /u01/app/12.1.0.2/grid/OPatch/opatch napply -oh /u01/app/12.1.0.2/grid -local /u01/patchdepot/23273686

Node 2 srvdb02

[root@srvdb02]# /u01/app/12.1.0.2/grid/OPatch/opatch napply -oh /u01/app/12.1.0.2/grid -local /u01/patchdepot/23273686

While there is a known BUG you should directly install the following Oneoff Patch 20734332 here the Doc ID 2166451.1 with the details

(SCAN Listener or local listener fails to start after applying Patch 23273629 – Oracle Grid Infrastructure Patch Set Update 12.1.0.2.160719 (Jul2016))

Step 4 rootupgrade.sh 

After you finish the PSU Jul 2016 & Oneoff Patch installation the rootupgrade.sh must be started


Node 1 srvdb01

[root@srvdb01 grid]# /u01/app/12.1.0.2/grid/rootupgrade.sh

Node 2 srvdb02

[root@srvdb02 grid]# /u01/app/12.1.0.2/grid/rootupgrade.sh

The rootupgrade.sh script works around 15 minutes so stay calm

It finished with the following messages here as example from the last Node 2 srvdb02

….

Successfully accumulated necessary OCR keys.

Creating OCR keys for user ‚root‘, privgrp ‚root‘..

Operation successful. 14:53:13 CLSRSC-474: Initiating upgrade of resource types

14:54:33 CLSRSC-482: Running command: ‚upgrade model  -s 11.2.0.4.0 -d 12.1.0.2.0 -p first‘

14:54:33 CLSRSC-475: Upgrade of resource types successfully initiated.

14:54:35 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster … succeeded

gi_upg_14

Step 5 final tasks

finally some configuration tool runs and finished the GI Upgrade including PSU Jul 2016 and Oneoff Patch

And now the „real news“ in 12.1.0.2 

The most notable change belongs to the GIMR  (Grid Infrastructure Management Repository) 

Beginning with 12.1.0.1 it was an option installing the GIMR Database – MGMTDB

Starting with 12.1.0.2 it is mandatory and the MGMTDB database is automatically created as part of the upgrade installation process of 12.10.2 Grid Infrastructure. If you start a installation from scratch the GIMR Database is directly configured

Some interesting GI & MGMTDB commands

[oracle@srvdb01 ~]$ crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [12.1.0.2.0]

[oracle@srvdb01 ~]$ crsctl query crs releaseversion

Oracle High Availability Services release version on the local node is [12.1.0.2.0]

[oracle@srvdb01 ~]$ crsctl query crs activeversion -f

Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3351897854].

MGMTDB Checks


[oracle@srvdb01 ~]$ srvctl status mgmtdb -verbose
Database is enabled
Instance -MGMTDB is running on node srvdb01. Instance status: Open.

[oracle@srvdb01 ~]$ srvctl config mgmtdb
Database unique name: _mgmtdb
Database name:
Oracle home: <CRS home>
Oracle user: oracle
Spfile: +DBFS_DG/_MGMTDB/PARAMETERFILE/spfile.268.926345767
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Type: Management
PDB name: srv_cl12
PDB service: srv_cl12
Cluster name: srv-cl12
Database instance: -MGMTDB

Veröffentlicht unter Exadata, General, Grid Infrastructure, Oracle 12.1 | Verschlagwortet mit , , | Kommentar hinterlassen

DOAG Konferenz 2016

bildschirmfoto-2016-11-05-um-15-16-56

Noch eine Woche und ein paar Tage dann startet die DOAG Konferenz 2016.

Es warten viele Interessante Themen rund um das Thema Oracle.

Einfach mal über den Link ins Vortragsprogramm schauen.

http://2016.doag.org/de/home/

 

 

Veröffentlicht unter DOAG, Engineered Systems, Exadata | Kommentar hinterlassen