All public logs

Jump to navigation Jump to search

Combined display of all available logs of NazimWIKI. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

Logs
(newest | oldest) View ( | ) (20 | 50 | 100 | 250 | 500)
  • 23:54, 8 November 2019 Admin talk contribs created page Creating an Oracle Database with Apex on AWS RDS (Created page with "'''Steps to create an Oracle Standard Edition Two database on AWS with APEX as an option. These notes are for Apex version 5.1.2.v1''' '''PRE-REQUISITIES''' If you don't a...")
  • 23:53, 8 November 2019 Admin talk contribs created page SQL Server Backup Script for AWS RDS (Created page with "<blockquote><pre> DECLARE @dbs TABLE (dbname VARCHAR(50)) DECLARE @currentDB VARCHAR(50) declare @SQL1 nvarchar(3000) declare @SQL2 nvarchar(3000) declare @BUCKET nvarchar(2...")
  • 23:53, 8 November 2019 Admin talk contribs created page Auto Refresh of Oracle DB across VPCs (Created page with "<blockquote><pre> #!/bin/ksh # # Shell script for Snapshot of Databases # Nazim Merchant # 26 Jul 2018 # # Usage script.ksh instance-name source_db_name target_db_name e.g. or...")
  • 23:52, 8 November 2019 Admin talk contribs created page Datapump Export to S3/Glacier (Created page with "Another script that has been documented for preservation more than anything else. '''Pre-requisites''' * ec2 Instance with Oracle XE installed * Access to the RDS Databases u...")
  • 23:51, 8 November 2019 Admin talk contribs created page Dynamic Profile Creation Script (Created page with "<blockquote><pre> set serveroutput on declare cursor prof is select dbms_metadata.get_ddl('PROFILE', profile) as profile from (select distinct profile from dba_...")
  • 23:51, 8 November 2019 Admin talk contribs created page Deploy Amazon Web Services Plugin to Cloud Control (Created page with "To monitor AWS RDS Database via Cloud Control (13c), a plugin needs to be deployed on OEM. Here are some rough notes, for my own reference. '''Download Plug-in''' <blockquot...")
  • 23:50, 8 November 2019 Admin talk contribs created page Dynamic Tablespace Creation Script (Created page with "This script generates a dynamic Tablespace Creation (with multiple datafiles) script from my target database for my RDS instance. It deals with smallfile tablespaces. <block...")
  • 23:49, 8 November 2019 Admin talk contribs created page Create a DB Link on RDS DB (Created page with "<blockquote><pre> create database link test connect to <username> identified by "<password>" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=1521))(CONNECT...")
  • 23:49, 8 November 2019 Admin talk contribs created page General-Tasks (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
  • 23:46, 8 November 2019 Admin talk contribs created page Disable Auto SQL Tuning Advisor (Created page with "<pre> select * from dba_autotask_operation EXEC dbms_auto_task_admin.disable( 'sql tuning advisor', NULL, NULL ); </pre>")
  • 23:44, 8 November 2019 Admin talk contribs created page Check Bind Variables (Created page with "Here's a way you can check on what bind variable values have been parsed in a query. <blockquote><pre> SELECT a.sql_id , a.sql_text , b.name , b.value_string...")
  • 23:44, 8 November 2019 Admin talk contribs created page Tuning-Tasks (Created page with " Check Bind Variables Disable Automatic SQL Tuning Advisor")
  • 23:39, 8 November 2019 Admin talk contribs created page RMAN - Create Standby Database (Created page with "These are just rough notes for my own benefit. They are not well researched and are only posted as a reminder for myself. Had to convert a database to a physical standby usi...")
  • 23:39, 8 November 2019 Admin talk contribs created page Resize Online Redo Logs (10g) - Rough Notes (Created page with "To resize redo log files, we have to drop and recreate them. The status of these files is critical. Files with a status of: * CURRENT - cannot/must not be dropped. To ch...")
  • 23:39, 8 November 2019 Admin talk contribs created page READ ONLY Before RESETLOGS (11g) (Created page with "A new feature in Oracle 11g is that after incomplete recovery of a database, you can now open the database in read only mode before opening in resetlog mode. This now enables...")
  • 23:38, 8 November 2019 Admin talk contribs created page Check Recovery Time (Created page with "It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery. <blockquote><pre> SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM...")
  • 23:38, 8 November 2019 Admin talk contribs created page Manually Create Standby Database from Hotbackup (9i) (Created page with "This is basically a "Note-To-Self". High Level Steps for Reference, are: * Copy Datafiles across. * On Target, set up env variables, password file, oratab entry etc. *...")
  • 23:38, 8 November 2019 Admin talk contribs created page Lost spfile and pfile (Created page with "''Handy Tip'': If you have lost your spfile and pfile, you can recover the non-default values previously set from the database Alert Log, as these values are spooled to the al...")
  • 23:37, 8 November 2019 Admin talk contribs created page Log Mining (10g) (Created page with "'''Please note the database parameter log_parallelism needs to be set at 1 for this to work''' In this day and age of flashback configuration, log mining almost seems like...")
  • 23:37, 8 November 2019 Admin talk contribs created page Check Last Applied Archive Log (Created page with "<blockquote><pre> SELECT max(sequence#) FROM v$log_history; </pre></blockquote> OR ... <blockquote><pre> SQL> archive log list; </pre></blockquote>")
  • 23:37, 8 November 2019 Admin talk contribs created page Foreign Archive Logs (11g) (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 Admin talk contribs created page Cloning Schema (11g) (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 Admin talk contribs created page Available db recovery file dest (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 Admin talk contribs created page Manually Create a Controlfile via SQL (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 Admin talk contribs created page Datapump Dynamic List of Tables (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 Admin talk contribs created page Monitoring Import Job Progress (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 Admin talk contribs created page Pipe Database Export to Zip (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 Admin talk contribs created page Monitoring RMAN Job Progress (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 Admin talk contribs created page RMAN Archivelog Deletions (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 Admin talk contribs created page Flashback Table (10g) (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 Admin talk contribs created page Flashback Schema (10g) (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 Admin talk contribs created page Flashback Row (10g) (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 Admin talk contribs created page Check Space Fast Recovery Area (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 Admin talk contribs created page RMAN - Point in Time Duplicate (11.2.0.2.0 (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 Admin talk contribs created page RMAN - Diagnosing Failures (11g) (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 Admin talk contribs created page Automatic Guaranteed Restore Point (11g) (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 Admin talk contribs created page Restore in between Upgrades (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 Admin talk contribs created page Snapshot Standby Database (11g) (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 Admin talk contribs created page Recovery-Tasks (Created page with "=== Database Restores/Refreshes/Recovery === Snapshot Standby Database (11g) Restore in between Upgrades | Restore in between Upgrades...")
  • 23:09, 8 November 2019 Admin talk contribs created page Database Size (2) (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 Admin talk contribs created page Database Size (1) (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 Admin talk contribs created page Clearing Alerts (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 Admin talk contribs created page Datafile Size (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 Admin talk contribs created page Tablespace Allocated and Used (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 Admin talk contribs created page User Defined Metrics (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 Admin talk contribs created page List DBs on AIX (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 Admin talk contribs created page UDM Collection Interval (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...")
  • 23:04, 8 November 2019 Admin talk contribs created page High Level Steps to Migrate Datafiles (Disk Groups) (Created page with "Just some notes for my own reference. Had to migrate all my datafiles on a database from one Disk Group (DATA) to Another (DATAR), using RMAN to copy the datafiles. '''Pre-...")
  • 23:03, 8 November 2019 Admin talk contribs created page Check Disk Groups (Created page with "<blockquote><pre> SELECT NAME, HEADER_STATUS, PATH, OS_MB FROM V$ASM_DISK ORDER BY NAME; </pre></blockquote>")
  • 23:01, 8 November 2019 Admin talk contribs created page DBLinks not in Use (Created page with "<pre> select db_link from dba_db_links where db_link not in (select db_link from dba_db_links where db_link in (select referen...")
(newest | oldest) View ( | ) (20 | 50 | 100 | 250 | 500)
Retrieved from "http://www.nazimcricket.com/wiki/Special:Log"