New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 23:37, 8 November 2019 Foreign Archive Logs (11g) (hist) [747 bytes] Admin (talk | contribs) (Created page with "A colleague of mine recently noticed in our Fast Recovery Area (aka Flash Recovery Area) that some FOREIGN ARCHIVED LOGS were taking up space. We knew from a recent implement...")
- 23:36, 8 November 2019 Cloning Schema (11g) (hist) [4,585 bytes] Admin (talk | contribs) (Created page with "Found an interesting way to clone a schema '''in the same database''' using datapump with a database link. Could be considered a highly unsupported method, but it worked for...")
- 23:36, 8 November 2019 Available db recovery file dest (hist) [475 bytes] Admin (talk | contribs) (Created page with "A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space. <blockquote><pre> SELECT name , floor(space_limit/1024/102...")
- 23:35, 8 November 2019 Manually Create a Controlfile via SQL (hist) [2,887 bytes] Admin (talk | contribs) (Created page with "Something I no doubt cobbled together many years ago for reasons I cannot recall. Could be useful though! <pre> declare cursor log_files is select v$log.group#...")
- 23:35, 8 November 2019 Datapump Dynamic List of Tables (hist) [832 bytes] Admin (talk | contribs) (Created page with "In PeopleSoft, I needed to export out all configuration/system-owned tables as a backup each week. To achieve this, my first step was to create a view listing all these tables...")
- 23:34, 8 November 2019 Monitoring Import Job Progress (hist) [436 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT substr(sql_text, instr(sql_text,'INTO "'),30) table_name , rows_processed , round( (sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss')...")
- 23:34, 8 November 2019 Pipe Database Export to Zip (hist) [335 bytes] Admin (talk | contribs) (Created page with "Using fifo (first in first out) you can redirect your database exports through a pipe straight to zip. '''Make fifo pipe:''' mkdir fifo db.fifo '''Write the file output...")
- 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>")