Saturday, December 31, 2011
Friday, December 30, 2011
Friday, December 23, 2011
Thursday, December 15, 2011
Thursday, December 1, 2011
Wednesday, November 30, 2011
Monday, November 28, 2011
Saturday, November 19, 2011
Thursday, November 10, 2011
Tuesday, November 8, 2011
Wednesday, November 2, 2011
Sunday, October 30, 2011
Tuesday, October 25, 2011
Saturday, October 22, 2011
Friday, October 21, 2011
Sunday, October 16, 2011
Saturday, October 15, 2011
Friday, October 14, 2011
Wednesday, October 12, 2011
Tuesday, October 11, 2011
Saturday, October 8, 2011
Batch-30: Sunday 10/18/15: Class Notes on RMAN settings and Management.
Batch-30: Saturday 10/24/15: Class Notes on RMAN restore
Create database using scripts -- Class Notes-1
Setting up RMAN Backup Configuration -- Class notes-2
My notes on RMAN -- Class Notes-3
Testing of Redo Logs generation -- Class Notes-4
RMAN Command Line Reference Guide -- Class Notes-5
How to restore db on a remote server? (Chicago to NY) -- Class Notes-6
How to restore db on a remote server? (NY to Chicago) -- Class Notes-6
How to restore db on remote server (Chicago to TN) --Class Notes-6
RMAN Scenario-16 | How to restore Oracle database? --Moid
RMAN: Scenario-17: How to restore Oracle tablespace? --Moid
RMAN: Scenario-18: How to restore Oracle datafile? --Moid
RMAN: Scenario-19: How to perform point in time recovery? --Moid
RMAN: Scenario-20: How to perform TABLESPACE point in time recovery? --Moid
Task: How to rename and/or move datafiles (ALL Datafiles) to a new directory? --Moid
Week-20 | RMAN Homework | Part-1 --Moid
Batch Specific Class Notes:
Batch-26: RMAN | Saturday and Sunday class notes | June 2014
Class work: How to perform Consistent (COLD) User Managed Backup and recover the database on a different host?
Class Work: My queries on Redo and Archive Logs --Moid
Homework: Change redo log size --Moid
Homework: Change redo log location --Moid
Homework: Change the datafile location --Moid
Homework: Perform a User Managed Hot Backup --Moid
Homework: Perform a User Managed Restore from a hot Backup --Moid
Homework: One of the control file is lost. Restore it and open database --Moid
Homework: All controlfiles are lost. Re-create them. --Moid
How to enable archivelog mode? --Moid
How to Disable archivelog mode? --Moid
How to recover database when a redo log is accidentally dropped? --Moid
Testing or Redo Log Generation (In class notes) --Moid
Batch Related Notes:
Export / Import:
- Click here for Export Import Notes-1
- Click here for Export Import Notes-2
- My notes on Oracle Export - Examples --Moid
- My notes on Oracle Import - Examples --Moid
- How to export (using Data Pump) a schema using parfile? --Moid
- Click here for Export Homework.
- Click here for Import Homework.
- Click here for Class notes on Data Pump - 12/29/13
- My notes on Data Pump
- Click here for the Schema level Export Import using DATA PUMP
- Click here for Data Pump Homework.
- How to name, start, stop, kill an export job using Oracle Data Pump? --Moid
- Data Pump: How to check the status of Data Pump export? --Moid
- Batch-28: Classwork on Export Import | 02/08/15
- Batch-27: Class work on Export Import | 10-12-14
- Batch-27: Class work on Export Import | 10-25-14
- Batch-30: Class work on Export Import | 10/10/15
- Batch-30: Class work on Export Import | 10/11/15
Classwork and Homeworkhttp://www.mydbanotes.com/2015/06/my-notes-on-tablespaces-and-logical.html
Week-15: Classwork on Tablespace and Datafiles
Week-15: Homework on Tablespace and Datafile.
Week-15: Classwork on Row Chaining
Other links:My notes on Tablespace and Datafiles --Moid
My notes on Temporary Tablespace --Moid
My notes on Undo Tablespace --Moid
Notes on Row Chaining and Row Migration
2. Click here for Homework Exercise-2
4. Security -- What object level permission are given to an oracle user?
6. Security -- How many (system level) permissions are assigned to a Role?
7. Security -- My queries on Oracle Roles
8. Security -- My queries on Oracle Grants, Roles and Privilege
9. Security -- How to copy / extract a user's Roles and permissions?
Homework (Week-9) [Oracle Client Side Networking Overview, Oracle Client Installation, Server Side Networking Overview] --Moid
- Download Oracle 11g R2 Client for 32/64-bit Windows
- Download Oracle 12c R1 Client for 32/64-bit Windows
- Click here for 11g R2 Client Installation on Windows 7
- Click here for 12c R1 Client Installation on Windows 8
- How to deinstall Oracle 11g R2 Client from Windows 7?
- How to deinstall Oracle 12g R1 Client from Windows 8?
- How to deinstall Oracle 11g client from Linux?
- How to deinstall Oracle 11g R2 "DATABASE" from Windows 7?
- How to deinstall Oracle 11g R2 "DATABASE" from Windows 8?
- How to deinstall (uninstall) 12c database home from Linux?
- How to create a TNS Entry (Database Address / Connect Identifier) on the Oracle Client Machine using netca?
- On Linux - How to register database on a non-default listener?
- Click here for Class Notes on Client Side Networking
- Click here for Class Notes on Server Side Networking
- Click here for the "Server Side Networking" homework.
- Click here for the "Client Side Networking" homework.
Part-1 Install 11g R2 on 64-bit CentOS 5.6 (Create Virtual CentOS Machine for Oracle)
Part-2 Install 11g R2 on 64-bit CentOS 5.6 (Oracle Pre-requisites & Kernel Parameter Changes)
Part-3 Install 11g R2 on 64-bit CentOS 5.6 (Create Oracle Directories and download 11g R2 software)
Part-4 Install 11g R2 on 64-bit CentOS 5.6 (Oracle 11g R2 Software Installation)
Part-5 Install 11g R2 on 64-bit CentOS 5.6 (Oracle 11g R2 Database Installation) --Final
Click here for Homework on Oracle Dictionary
Click here for Homework on CASE and DECODE
Click here for Homework on Sub-Queries (Part-1).
Click here for Homework on Joins (Part-1)
Batch-27: Click here for Saturday Notes.
Batch-27: Click here for Sunday Notes.
Batch-28: Click here for Saturday Class Work
Batch-28: Click here for Sunday Class work
Click here for class notes on Sub-Queries
Batch-29: Click here for Saturday Class Work (04/11/15)
Batch-29: Click here for Sunday Class Work (04/12/15)
What to read in Book?
Week-7 - Understanding Constraints Part-1
Week-7 - Understanding Constraints Part-2
Batch-30: Saturday: Week-7 Class Notes 7/25/15
Batch-30: Sunday: Week-7 Class Notes 7/26/15
Week-7 Part-1 Homework [Oracle Views and Concatenation]
Week-7 Part-2 Homework [Constraints]
Batch-29: Saturday Week-7 Class Notes (04-05-15)
Batch-29: Sunday Week-7 Class Notes (04-04-16)
Batch-26 Week-7 SQL Revision on 3/1/14 with Dictionary Views
Batch-26 Week-7 Class work 3/2/14 (concatenation)
Batch-26 Week-7 Class work 3/2/14 (Sub Query)
Batch-25 Week-7 Class work 9/28/13
Batch-31: Week-7: Sunday Class: 12/06/15
Week-6: Homework | Select, DDL, DML and Views -
Week-6: Homework: Question and Answers via email
Batch-24: Class work
Batch-27: Week-6: Saturday Class Notes: 06-07-14
Batch-27: Week-6: Sunday Class Notes: 06-08-14
Batch-28: Week-6: Classwork: Saturday 11/1/14 --Moid
Batch-28: Week-6: Classwork: Sunday 11/2/14 --Moid
Batch-29: Week-6: Saturday Class Notes: 03/14/15
Batch-29: Week-6: Sunday Class Notes: 03/15/15
- Batch-32: Week-5: Class Notes 03/05/16 and 03/06/16
- Document for Student Only: How to create a new schema and load tables?
- How to find the date format of Oracle Database Server?
- Week-5 Homework (SQL on select statements with conditions only)
- Oracle SQL Operators --Moid
- Oracle Functions --Moid
- Batch-31: Week-6: Class Notes | Saturday 11-04-15
- Batch-31: Week-6: Class Notes | Saturday 11-05-15
- Batch-30: Week-5 Class Notes | Saturday 06-27-15
- Batch-30: Week-5 Class Notes | Sunday 06-28-15
- Batch-29: Week-5 Class Notes | Saturday 03-07-15
- Batch-29: Week-5 Class Notes | Sunday 03-08-15
- Batch-28: Week-5 Class Notes: Saturday 10-25-2014
- Batch-28: Week-5 Class Notes: Sunday 10-26-2014
- Batch-27: Week-5 Class Note | Saturday 05/31/14
- Batch-27: Week-5 Class Note | Sunday 06/01/14
Please Note: Only my students has access to these document.
Class work Part-2: [User Management]
Class work Part-3: [Class Notes - Create Table]
Class work Part-4 [Different Ways of Inserting data into a table]
How to spool SQL output to a file?
How to transfer files from Linux to Windows using WinSCP?
Your homework for week-4 is:
- Login to your database schema.
- Start spool.
Spool output to /home/oracle/SpooledFiles/Khan_A13_spool_file.log.
Replace Khan_A13 with your schema name.
- Ceate and insert values in all tables mentioned on page 57, 58 and 58 in your book. Tables are also located at http://www.mydbanotes.com/2011/09/table-screenshots-of-indo-us-college.html
- Turn off spool.
- Transfer file from Server-223 to your laptop using WinSCP.
- Send me the file from Step-5 from your email as attachment.
- Batch 23: Week-4: Classwork: [Saturday and Sunday SQL Notes]
- Batch-28: Week-4: Classwork: [Saturday & Classwork | 10/11 and 10/12]
- Batch-29: Week-4: Classwork: [Saturday & Sunday Classwork | 02/28/15 and 03/01/15]
- Batch-30: Classwork: Week-4: [Saturday 06/13/15]
- Batch-30: Classwork: Week-4: [Sunday 06/14/15]
Click here for Classwork (Linux Commands)
Click here for Classwork (find Commands)
Click here for Classword (grep Commands)
Click here for Classwork (awk Commands)
Click here for Classwork (sed Command)
Click here for SSH & SCP Classwork
Click here for homework | Part-1
Click here for homework | Part-2
Friday, October 7, 2011
Click here for the networking class notes.
Basics of Linux:
Click here for the Linux class notes
Click here for the homework on Linux Basics
Wednesday, September 28, 2011
Tuesday, September 27, 2011
Saturday, September 24, 2011
Friday, September 23, 2011
Table screenshots of Indo US College Database (Page 55, 56 and 57) From Nilesh Shah's book
Sunday, September 18, 2011
Monday, August 22, 2011
Part-2) How to perform non-rolling ORACLE_HOME upgrade from 10.2.0.1 to 10.2.0.4?
Part-3) How to apply Latest CPU Patches and CRS Bundle Patch-4 on 10g R2 RAC?
Sunday, August 21, 2011
Sunday, August 14, 2011
Monday, August 8, 2011
Thursday, August 4, 2011
Thursday, July 28, 2011
Click here for the document.
Tuesday, July 26, 2011
Friday, July 22, 2011
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 11g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3
Monday, July 11, 2011
Wednesday, July 6, 2011
Tuesday, July 5, 2011
"TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.
In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools."
1) Go to http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
2) Click on "Accept License Agreement"
3) And then start browsing as per your need. Few links to download Oracle client are as follows:
Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip
Direct Download: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip
Click here for step-by-step Oracle 11g R2 Client Installation on Windows 7.
Click here for step-by-step Oracle 12c R1 Client Installation on Windows 8.
Note: In order for TOAD to work, use 32-bit client installation.
Monday, July 4, 2011
|$ export ORACLE_SID=PrimeDG
$ rman target /
RMAN> sql 'alter tablespace CT_COMMON_DATA offline';
set until time "to_date('FEB 28 2008 13:59:00','Mon DD YYYY HH24:MI:SS')";
recover tablespace CT_COMMON_DATA;
}RMAN> sql 'alter tablespace CT_COMMON_DATA online';
Backup and Recovery Scenario-7 | How to duplicate (clone) database on the DIFFERENT HOST from NON-ASM to ASM using RMAN? --Moid
Migrate NON-ASM to ASM on a different host.
Backup and Recovery Scenario-6 | How to duplicate (clone) database on the same server from NON-ASM to ASM using RMAN?
Migrate NON-ASM to ASM.
Backup and Recovery Scenario-4 | How to duplicate (clone) database on the same server using RMAN? --Moid
NON-ASM to NON-ASM
Thursday, June 16, 2011
Sunday, May 29, 2011
non-asm to non-asm
Saturday, May 28, 2011
Thursday, May 26, 2011
Wednesday, May 25, 2011
Saturday, May 21, 2011
Friday, May 20, 2011
Tuesday, May 17, 2011
Sunday, May 15, 2011
Friday, May 13, 2011
Tuesday, May 10, 2011
Monday, May 9, 2011
Sunday, May 8, 2011
Monday, May 2, 2011
Thursday, April 28, 2011
Tuesday, April 26, 2011
Monday, April 18, 2011
Sunday, April 10, 2011
Saturday, April 9, 2011
Sunday, April 3, 2011
Friday, April 1, 2011
Friday, March 25, 2011
Hope this helps.
non-asm to non-asm
Thursday, March 24, 2011
crs_unregister unregister remove ocr cleanup "srvctl remove database"
Tuesday, March 22, 2011
Sunday, March 20, 2011
Rename redo logs
Resize online redo logs
Friday, March 18, 2011
archivelogs are not backed up
Thursday, March 17, 2011
Monday, March 14, 2011
Sunday, March 6, 2011
Thursday, March 3, 2011
Monday, February 28, 2011
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-2
Build Your Own 10g R2 Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI Part-3
Also the cached pages are at my network at the following location:
Sunday, February 27, 2011
Saturday, February 26, 2011
Part-III Install 10.2.0.1 and upgrade to 10.2.0.4
Part-II Prepare Linux for Oracle (all prerequisites) v1.3
Part-I Operating System Install (RHEL4 Update-8) v1.2
Thursday, February 24, 2011
Tuesday, February 22, 2011
Friday, February 11, 2011
Friday, February 4, 2011
Thursday, February 3, 2011
Wednesday, February 2, 2011
How to change the protection mode from "maximum performance" to "maximum availability" in a 10g Data Guard environment?
Maximum Protection—This mode offers the highest level of data protection. Data is synchronously transmitted to the standby database from the primary database and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database. This mode ensures no-data-loss.
Maximum Availability—This mode is similar to the maximum protection mode, including zero data loss. However, if a standby database becomes unavailable (for example, because of network connectivity problems), processing continues on the primary database. When the fault is corrected, the standby database is automatically resynchronized with the primary database.
Maximum Performance—This mode offers slightly less data protection on the primary database, but higher performance than maximum availability mode. In this mode, as the primary database processes transactions, redo data is asynchronously shipped to the standby database. The commit operation of the primary database does not wait for the standby database to acknowledge receipt of redo data before completing write operations on the primary database. If any standby destination becomes unavailable, processing continues on the primary database and there is little effect on primary database performance.
How to change from "maximum performance" to "maximum availability"? Click here for the instructions.
Data Guard Protection Mode.
Monday, January 24, 2011
Wednesday, January 19, 2011
Keyword: VMWare Cloning with screenshot, VMWare Duplicate, VMWare Oracle Database Cloning, step-by-step VMWare Cloning, VMWare image, VM Machine Image