MiDBA
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Wednesday, August 23, 2017
something new related AWR setting in 12c multitenant DB
12c Consolidated AWR report with PDBs
Enabling Automatic AWR Snapshots on PDB
below is not unique to 12c, but advanced ...
To see AWR settings query DBA_HIST_WR_CONTROL
Newer Post
Older Post
Home
About Me
MiDBA
View my complete profile
Save your time!
Enter your search terms
Web
midba.blogspot.com
Submit search form
Translate
Popular Posts
ORA-12034 and Complete Materialized View Refresh Generates Lots Of Archive Logs and Rollback/Undo
1. Refresh group failed with FAST REFRESH mode . SQL> exec dbms_refresh.refresh('"ARBOR"."ARBOR_DAILY_REF"...
Point-in-time recovery using RMAN command
Summary: 1.) In my first test, the recovery time is too close (8 seconds) to the INSERT statement, "hence" after recovery the las...
Amazing Automatic Block Media Recovery by Active Data Guard
Oracle Database 11g Release 2 now has the capability to automatically repair corrupt data blocks in your production database as soon as the ...
RMAN-03009 and ORA-00245 of 11gR2 RAC RMAN backup
RMAN> backup database plus archivelog; channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 RMAN-00571: ======================...
Re-Configure data guard broker after re-create physical standby database
SYS@DGS> startup mount ORACLE instance started. Total System Global Area 680607744 bytes Fixed Size 2229600 bytes Varia...
solutions for handling RMAN-08138
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
RMAN-20020: database incarnation not set
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
ORA-14064: Index with Unusable partition exists on unique/primary constraint key
Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object...
RMAN-06214 of controlfile snapshot from RMAN duplication
My case is very similar to Strange RMAN snapshot controlfile issue This happend on a 11gR2 database installed under a Linux x86 platf...
11gR2 :Create Physical standby from Active database using RMAN
Lots of such article in internet, also can refer to " F.3 Using the DUPLICATE Command to Create a Standby Database" in Oracle...
Labels
10g
(35)
11g
(13)
12c
(9)
4.3
(1)
ACHI
(1)
AIX
(3)
Android
(1)
APEX
(8)
Architecture
(2)
ASM
(3)
audit
(1)
automation
(1)
AWR
(4)
backup and recovery
(15)
Basic
(22)
Best Practices
(3)
bind variable
(2)
BIOS
(1)
Bleeding Case
(20)
bug
(3)
career
(2)
case
(7)
centos
(4)
character set
(1)
cloud control
(11)
clusterware
(1)
Concept
(1)
cron
(1)
Cygwin
(1)
Data Guard
(13)
data management
(6)
DBConsole
(5)
dbua
(2)
delphix
(2)
Edge
(2)
Error latch
(1)
events
(1)
Exam
(1)
Experience
(2)
firmware
(1)
flashback
(3)
Fun
(1)
Fundamental
(36)
HDD
(1)
health check
(1)
Hidden Parameter
(2)
Howto
(2)
install
(1)
instantclient
(1)
ITIL
(2)
itpub
(2)
ITSM
(2)
Java
(1)
jmeter
(1)
joomla
(2)
knives
(3)
knowledge gained
(1)
labs
(5)
latch
(1)
Lazarus
(2)
life
(6)
Linux
(36)
Listener
(3)
LogMiner
(1)
management
(5)
migration
(7)
mind
(1)
mview
(3)
mysql
(3)
NewFeature
(3)
ODBC
(1)
OEM
(9)
oerr
(27)
opatch
(2)
ora600
(1)
OS
(1)
outline
(1)
Partition
(4)
performance
(5)
PGA
(2)
PL/SQL
(5)
postgresql
(1)
Price
(1)
programming
(1)
qnap
(2)
question
(2)
RAC
(6)
raw device
(3)
Recovery
(23)
RHCE
(1)
RMAN
(50)
SAP Basis
(1)
scripts
(1)
security
(7)
Server-Generated Alert
(2)
shared server
(3)
Software Engineering
(4)
sql developer
(3)
sql*plus
(2)
sqlnet
(1)
sqlserver
(13)
SSD
(2)
SSD IO
(1)
standards
(1)
statistics
(5)
statspack
(2)
Stock
(1)
storage
(2)
timesten
(2)
tips
(45)
Tools
(38)
Trace
(3)
Tuning
(17)
Ubuntu
(24)
Unix
(5)
vertica
(1)
vmware
(2)
vnc
(1)
WhatIs
(1)
XServer
(1)
zabbix
(1)
Blog Archive
►
2019
(5)
►
December
(1)
►
October
(4)
►
2018
(6)
►
January
(6)
▼
2017
(31)
►
December
(2)
►
November
(1)
►
September
(1)
▼
August
(12)
some links for APEX 5.0 upgrade to 5.1
something new related AWR setting in 12c multitena...
Create stacked bar in APEX 5.1
install sql server 2017 RC2 in CentOS 7.3
Install sqlcmd and bcp the SQL Server command-line...
30 Things to Do After Minimal RHEL/CentOS 7 Instal...
auto dbstart stop in centos 7 (systemd)
SQL server audit related links
SQL commands for getting bind variable value
Using bind variables in SQL*Plus
amazing server side result cache (2) - benchmark
amazing server side result cache (1)
►
July
(1)
►
June
(6)
►
May
(3)
►
April
(2)
►
March
(2)
►
February
(1)
►
2016
(42)
►
December
(1)
►
November
(2)
►
September
(3)
►
August
(2)
►
June
(3)
►
May
(11)
►
April
(11)
►
March
(2)
►
February
(4)
►
January
(3)
►
2015
(24)
►
December
(2)
►
November
(6)
►
October
(2)
►
September
(12)
►
July
(2)
►
2014
(15)
►
August
(2)
►
July
(2)
►
June
(1)
►
May
(1)
►
April
(5)
►
March
(2)
►
February
(2)
►
2013
(81)
►
December
(1)
►
November
(1)
►
October
(8)
►
September
(4)
►
August
(3)
►
June
(3)
►
May
(1)
►
April
(16)
►
March
(19)
►
January
(25)
►
2012
(30)
►
December
(3)
►
November
(1)
►
August
(5)
►
July
(4)
►
June
(3)
►
April
(10)
►
March
(2)
►
January
(2)
►
2011
(25)
►
October
(4)
►
September
(7)
►
August
(4)
►
June
(2)
►
May
(2)
►
April
(6)
►
2010
(72)
►
December
(1)
►
November
(6)
►
October
(2)
►
July
(26)
►
June
(6)
►
May
(2)
►
April
(12)
►
March
(7)
►
January
(10)
►
2009
(43)
►
December
(4)
►
November
(3)
►
September
(2)
►
August
(8)
►
July
(6)
►
May
(4)
►
April
(3)
►
February
(1)
►
January
(12)
►
2008
(93)
►
October
(2)
►
September
(11)
►
August
(13)
►
June
(5)
►
May
(30)
►
April
(32)
►
2007
(89)
►
December
(3)
►
November
(3)
►
October
(3)
►
September
(5)
►
August
(3)
►
July
(21)
►
June
(36)
►
May
(15)
►
2006
(6)
►
November
(1)
►
October
(4)
►
September
(1)
►
2005
(4)
►
October
(4)
Structured Data
Oracle Database Real-World Performance & Scalability Blog
vongtes 学习笔记