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).
(newest | oldest) View (newer 20 | older 20) (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>")