Wednesday, June 6, 2012
Monday, May 21, 2012
Sunday, May 20, 2012
Saturday, May 5, 2012
Thursday, May 3, 2012
What is the better Career Path? DBA vs Software Engineer?
I think the following discussion is worth reading...
http://www.coderanch.com/t/32120/Jobs/careers/better-Career-Path-DBA-vs
Saturday, April 21, 2012
Tuesday, April 10, 2012
Thursday, March 29, 2012
Friday, March 16, 2012
Thursday, March 15, 2012
Wednesday, March 14, 2012
Wednesday, March 7, 2012
Monday, February 27, 2012
Friday, February 24, 2012
Sunday, February 19, 2012
Friday, February 17, 2012
Sunday, January 22, 2012
Saturday, January 21, 2012
Monday, January 16, 2012
Sunday, January 15, 2012
Wednesday, January 11, 2012
Saturday, December 31, 2011
Friday, December 30, 2011
Friday, December 23, 2011
Thursday, December 15, 2011
How to find Oracle RAC Cluster name? --Moid
Depending on how you set up environment for CRS home in Linux, one of the following can be used to find the cluster name of you RAC environment.
$ORA_CRS_HOME/bin/cemutlo -n
or
$CRS_HOME/bin/cemutlo -n
--Moid
$ORA_CRS_HOME/bin/cemutlo -n
or
$CRS_HOME/bin/cemutlo -n
--Moid
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
Homework (Week-20) RMAN Restore and Recovery of Oracle Databases
Batch Specific Notes:
Batch-30: Sunday 10/18/15: Class Notes on RMAN settings and Management.
Batch-30: Saturday 10/24/15: Class Notes on RMAN restore
RMAN Tasks:
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
--Moid
Batch-30: Sunday 10/18/15: Class Notes on RMAN settings and Management.
Batch-30: Saturday 10/24/15: Class Notes on RMAN restore
RMAN Tasks:
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
--Moid
Homework (Week-19) | Redo Logs | Archive Logs | Oracle Cold and Hot Backup Strategy
Class work: In Class Notes
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
--Moid
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
--Moid
Homework (Week-18) [Export Import and Data Pump] --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.
Data Pump:
- 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
Archive:
- 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
--Moid Muhammad
Homework (Week-15) Row Chaining | Row Migration | Tablespace | Datafiles
Classwork and Homework
http://www.mydbanotes.com/2015/06/my-notes-on-tablespaces-and-logical.htmlWeek-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 --MoidMy notes on Temporary Tablespace --Moid
My notes on Undo Tablespace --Moid
Notes on Row Chaining and Row Migration
--Moid
Subscribe to:
Posts (Atom)