CLICK HERE TO DOWNLOAD PPT ON ORACLE DATABASE 10g
Oracle Database 10g Presentation Transcript
1.Oracle Database 10g
2.Oracle Database 10g
“g” Stands for Grid.
Grid computing is a new IT architecture that produces more resilient and lower cost enterprise information system.
Benefits of Grid Computing :
Higher quality of services.
Lower cost.
Easy to manage.
Oracle’s grid computing technology includes:
Automatic Storage Management (ASM)
Real Application Clusters (RAC)
Oracle Streams
Enterprise Manager Grid Control
“g” Stands for Grid.
Grid computing is a new IT architecture that produces more resilient and lower cost enterprise information system.
Benefits of Grid Computing :
Higher quality of services.
Lower cost.
Easy to manage.
Oracle’s grid computing technology includes:
Automatic Storage Management (ASM)
Real Application Clusters (RAC)
Oracle Streams
Enterprise Manager Grid Control
3.Oracle Database and its Architecture
An Object Relational Database Management System (ORDBMS).
Runs on more than 80 platforms.
Consists of Memory and Process.
Memory exists in the main memory of computer that constitute database server.
Processes are jobs that work in the memory of these computers.
An Object Relational Database Management System (ORDBMS).
Runs on more than 80 platforms.
Consists of Memory and Process.
Memory exists in the main memory of computer that constitute database server.
Processes are jobs that work in the memory of these computers.
4.Creating a Oracle Database
As a DBA, one must plan:
The logical storage structure of the database and its physical implementation:
How many disk drives do you have for this?
How many data files will you need? (Plan for growth.)
How many tablespaces will you use?
Which type of information will be stored?
Are there any special storage requirements due to type or size?
The overall database design.
A backup strategy for the database.
As a DBA, one must plan:
The logical storage structure of the database and its physical implementation:
How many disk drives do you have for this?
How many data files will you need? (Plan for growth.)
How many tablespaces will you use?
Which type of information will be stored?
Are there any special storage requirements due to type or size?
The overall database design.
A backup strategy for the database.
5. Oracle database have six main files
6. Using the DBCA to Create a Database
7.Using the DBCA to Create a Database
8. Oracle Database and User Security
Database user account
Each database user account has:
A unique username
An authentication method
A default tablespace
A temporary tablespace
A user profile
A lock status
Database user account
Each database user account has:
A unique username
An authentication method
A default tablespace
A temporary tablespace
A user profile
A lock status
9.Privileges
A privilege is a right to execute a particular type of SQL statement or to access another user’s object.
The Oracle database enables you to control what users can or cannot do within the database.
There are two types of user privileges:
System: Enables users to perform particular actions in the database
Object: Enables users to access and manipulate a specific object
A privilege is a right to execute a particular type of SQL statement or to access another user’s object.
The Oracle database enables you to control what users can or cannot do within the database.
There are two types of user privileges:
System: Enables users to perform particular actions in the database
Object: Enables users to access and manipulate a specific object
10. Creating a user account
Using Graphical interface :
Using Graphical interface :
11. What are Role ?
A role is a named group of related privileges that are granted to users or to other roles.
Roles can be granted to and revoked from users or other roles as though they were system privileges.
A role can consist of both system and object privileges.
A role can be enabled or disabled for each user who is granted the role.
Benefits :
Easier privilege management
Dynamic privilege management
Selective availability of privileges
A role is a named group of related privileges that are granted to users or to other roles.
Roles can be granted to and revoked from users or other roles as though they were system privileges.
A role can consist of both system and object privileges.
A role can be enabled or disabled for each user who is granted the role.
Benefits :
Easier privilege management
Dynamic privilege management
Selective availability of privileges
12. Database Backup and Recovery
Categories of Failure:
Failures can be divided into a few broad categories:
Statement failure: A single database operation (select, insert,
update, or delete) fails.
User process failure: A single database session fails.
Network failure: Connectivity to the database is lost.
User error: A user successfully completes an operation, but the
operation (dropping a table or entering bad data) is incorrect.
Instance failure: The database instance shuts down
unexpectedly.
Media failure: One or more of the database files are lost (that is,
the files have been deleted or the disk has failed).
Categories of Failure:
Failures can be divided into a few broad categories:
Statement failure: A single database operation (select, insert,
update, or delete) fails.
User process failure: A single database session fails.
Network failure: Connectivity to the database is lost.
User error: A user successfully completes an operation, but the
operation (dropping a table or entering bad data) is incorrect.
Instance failure: The database instance shuts down
unexpectedly.
Media failure: One or more of the database files are lost (that is,
the files have been deleted or the disk has failed).
13. Backups can be performed by using:
Recovery Manager
Oracle Secure Backup
A user-managed scenario
Recovery Manager
Oracle Secure Backup
A user-managed scenario
14. Recovery Manager (RMAN)
Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations.
RMAN:
Is a command-line client for advanced functions.
Has powerful control and scripting language.
Has a published API that enables interface with most popular backup software.
Backs up data, control, archived log, and server parameter files.
Backs up files to the disk or tape.
Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations.
RMAN:
Is a command-line client for advanced functions.
Has powerful control and scripting language.
Has a published API that enables interface with most popular backup software.
Backs up data, control, archived log, and server parameter files.
Backs up files to the disk or tape.
Posts
0 comments