clouddba:-DBA blog on Oracle,Oracle cloud,DevOps,PostgreSQL and Other Databases – Page 11 – This is mainly Oracle DBA blog which also cover performance tuning,oracle cloud dbaas,oracle rac dataguard,active dataguard,RMAN and other topics like Linux,AWS,Cassandra and other databases.Please subscribe below to get update on my blog.

Script to clean or truncate unified audit record table

debasis maity / December 21, 2017

exec dbms_audit_mgmt.clean_audit_trail(audit_trail_type=>dbms_audit_mgmt.audit_trail_unified, use_last_arch_timestamp=>FALSE);

SCRIPTS

script to get query for reclaim space from auto extensible datafile

debasis maity / December 21, 2017

set linesize 1000 pagesize 0 feedback off trimspool on with hwm as ( — get highest block id from each

Technology

Implementing the Golden Gate plug-in monitor for Oracle Cloud Control 13cR2(13.2.0.0.0)

debasis maity / December 20, 2017

This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 13cR2. These versions are required for

oracle 12c

Upgrade of Oracle 11g RAC database to Oracle 12c RAC DBUA

debasis maity / December 17, 2017

This document will help you providing guideline to upgrade Oracle 11g RAC to Oracle 12c RAC clusterware and Database .

Dataguard, Troubleshooting

ORA-01111: name for data file is unknown – rename to correct file

debasis maity / December 11, 2017

Error in dataguard alert log/start managed recovery process:- SYS@XXX>alter database recover managed standby database; alter database recover managed standby database

Backup and Recovery, Cloning, oracle 12c

Active RMAN duplicate clone 12c using section size and compress backupset

debasis maity / December 10, 2017

Overview of New PULL method The original “push” process is based on image copies.With Oracle Database 12c, a “pull” (or

Backup and Recovery

rman command reference

debasis maity / December 8, 2017

##Connecting RMAN############## rman TARGET SYS/target_pwd@target_str # connects in NOCATALOG mode rman TARGET / CATALOG rman/rman@rcat rman TARGET / CATALOG rman/rman@rcat

Backup and Recovery, Cloning