New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 23:33, 8 November 2019 Monitoring RMAN Job Progress (hist) [295 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sid , serial# , context , sofar , totalwork , round(sofar/totalwork*100,2) "%_Complete" FROM v$session_longops WHERE opnam...")
- 23:33, 8 November 2019 RMAN Archivelog Deletions (hist) [263 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> rman nocatalog<< DATA connect target delete noprompt archivelog until time 'SYSDATE-n'; DATA </pre></blockquote> <blockquote><pre> rman nocatalog<< DATA con...")
- 23:33, 8 November 2019 Flashback Table (10g) (hist) [2,352 bytes] Admin (talk | contribs) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_ret...")
- 23:32, 8 November 2019 Flashback Schema (10g) (hist) [873 bytes] Admin (talk | contribs) (Created page with "Technically there is no schema level flashback feature available. However, provided your recovery period does not include any data dictionary changes DDL) then you could actua...")
- 23:32, 8 November 2019 Flashback Row (10g) (hist) [2,586 bytes] Admin (talk | contribs) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_rete...")
- 23:31, 8 November 2019 Check Space Fast Recovery Area (hist) [363 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT name , floor(space_limit/1024/1024) "Size_MB" , ceil(space_used/1024/1024) "Used_MB" , floor(space_limit/1024/1024) - ceil(space_used/1...")
- 23:30, 8 November 2019 RMAN - Point in Time Duplicate (11.2.0.2.0 (hist) [1,264 bytes] Admin (talk | contribs) (Created page with "I've spent weeks struggling with a point-in-time rman duplicate where for some obscure reason the duplicate would fail to apply point-in-time logs after midnight. FINALLY -...")
- 23:29, 8 November 2019 RMAN - Diagnosing Failures (11g) (hist) [219 bytes] Admin (talk | contribs) (Created page with "The commands you can use through RMAN to list, seek advice on and in some cases repair Database Failures .. <blockquote><pre> RMAN> list failure [detail]; RMAN> advise failur...")
- 23:28, 8 November 2019 Automatic Guaranteed Restore Point (11g) (hist) [1,365 bytes] Admin (talk | contribs) (Created page with "-- Script to schedule the creation of a guaranteed restore point on a database -- and to remove the oldest guaranteed restore point when there are more than 2 -- restore point...")
- 23:27, 8 November 2019 Restore in between Upgrades (hist) [3,866 bytes] Admin (talk | contribs) (Created page with "'''Requirement''' Had to restore a database to a point-in-time from a hotbackup. Followed Steps: * Copied datafiles to target * Created a New Controlfile * Recovered using...")
- 23:27, 8 November 2019 Snapshot Standby Database (11g) (hist) [4,939 bytes] Admin (talk | contribs) (Created page with "'''Introduction''' <br> One of the best new features of Oracle 11g is the introduction of Snapshot Standby Databases. This feature allows you to take a normal Physical Standb...")
- 23:26, 8 November 2019 Recovery-Tasks (hist) [1,915 bytes] Admin (talk | contribs) (Created page with "=== Database Restores/Refreshes/Recovery === Snapshot Standby Database (11g) Restore in between Upgrades | Restore in between Upgrades...")
- 23:09, 8 November 2019 Database Size (2) (hist) [161 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT TARGET_NAME , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB FROM MGMT$db_datafiles_all GROUP BY TARGET_NAME </pre></blockquote>")
- 23:09, 8 November 2019 Database Size (1) (hist) [1,111 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select a.DTTM , trim(substr(a.target_name, instr(a.target_name,'.')+1,20)) HOST_NAME , trim(substr(a.target_name, 1, instr(a.target_name,'.')-1))...")
- 23:08, 8 November 2019 Clearing Alerts (hist) [421 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||''' , p_key_value...")
- 23:08, 8 November 2019 Datafile Size (hist) [345 bytes] Admin (talk | contribs) (Created page with "In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M. <blockquote><pre> SELECT target_name , file_name...")
- 23:07, 8 November 2019 Tablespace Allocated and Used (hist) [844 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT A.RT , A.ALLOCATED , B.USED FROM (SELECT TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM') RT , AVG(AVERAGE) ALLOCATED FROM MGMT$...")
- 23:07, 8 November 2019 User Defined Metrics (hist) [287 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT * FROM mgmt$metric_current WHERE metric_name like '%UDM%'; </pre></blockquote> <blockquote><pre> SELECT * FROM mgmt$metric_hourly WHERE target...")
- 23:06, 8 November 2019 List DBs on AIX (hist) [1,173 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select target_name , host_name from mgmt$target where target_type='oracle_database' and host_name in (select target_name...")
- 23:06, 8 November 2019 UDM Collection Interval (hist) [581 bytes] Admin (talk | contribs) (Created page with "You may have noticed that User Defined Metrics (UDM) in Oracle Enterprise Manager (OEM) have a minimum collection time of '''5''' minutes. If you wish to change this interva...")