Monday, June 16, 2014
Subscribe to:
Posts (Atom)
Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Translate
Popular Posts
-
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....
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
backup piece The physical file format used to store RMAN backup sets backup set A backup of one or more datafiles, control files, SPFILEs...
-
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
Security related values in the 12c SYS.USER$ table are CTIME: Date & Time when user was created PTIME: Date & Time when user pas...
-
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
Lots of such article in internet, also can refer to " F.3 Using the DUPLICATE Command to Create a Standby Database" in Oracle...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...
-
According to one case study, this is a best pracitice. So I give it try, although there is minal overhead from "check logical". ...
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)