Hi all, after long time I am finally back with something very interresting. Upgrade to 12c(12.1 /12.2) through RMAN Duplicate using BACKUP LOCATION with NOOPEN clause (Doc ID 2022820.1) If you check this note, you get a pretty simple upgrade scenario. The funny thing is, as described here or in the docs, it simply does…
There is not much to write about this. It’s a purge job for the audit trail 😀 E: it will not work 😅 i have changed it a little 😅 DECLARE lat TIMESTAMP := TO_TIMESTAMP(’30-06-17 00:00:00.00′,’DD-MM-YYYY HH24:MI:SS.FF’); BEGIN dbms_audit_mgmt.init_cleanup(AUDIT_TRAIL_TYPE => dbms_audit_mgmt.audit_trail_aud_std, DEFAULT_CLEANUP_INTERVAL => 1); DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, last_archive_time => lat); DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, AUDIT_TRAIL_PURGE_INTERVAL =>…
.While reading Oracle 12.2 New Features I discovered that we can create filesystems on tablespaces. So I had to try it and it works, but somehow wrong. Docs used: Database PL/SQL Packages and Types Reference In the Large Objects guide you will not find very much: 😀 Database SecureFiles and Large Objects Developer’s Guide I…
Yesterday I have installed GI for Standalone, I wanted to install my VBox with AFD, but I got this error. I don’t know, it’s sad I think. AFD-620: AFD is not supported on this operating system version: 3.10.0-514.10.2.el7.x86_64 So I had to install asmlib and continue with. I don’t understand why I had to restart…
First let’s check my disks. [root@nfs01 ~]# lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 20G 0 disk ├─sda1 8:1 0 500M 0 part /boot └─sda2 8:2 0 19.5G 0 part ├─ol-root 252:0 0 17.5G 0 lvm / └─ol-swap 252:1 0 2G 0 lvm [SWAP] sdb 8:16 0 30G 0 disk └─sdb1…
First, let’s install logstash, I have changed my yum repository to have access to their server. Now install and configure filebeat on the database host, I have to install an Oracle database too, I found somewhere on my disk SE2 install files so I used them and configured a very simple database Installing database… Our…
Hi, today I want to show how I think it’s possible to migrate a RAC to single. First let’s identify free disks Install GI and DB Home Prepare your spfile Prepare listener Create a passwordfile Define your connect identifiers Once you can login from these aliases without problems you can duplicate the DB Register this…
Hi, today(08.02.2017) I start to create a python script (because I want to learn little bit python too) if you are interrested you can check my github repositiories https://github.com/thedarkmucko
Yeees, I got my Expert level recently on community.oracle.com .. I would like to thank everyone who believes in me, it was a hard path to get 10 correct answers and 10 Helpful 😀 with this mission I finally moved to the Expert level. Thanks again
