Oracle DBA pocket guide
The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becomin...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2005.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009649834406719 |
Tabla de Contenidos:
- Contents; Oracle DBA Pocket Guide; Introduction; Acknowledgments; Conventions; Oracle Architecture; Database Versus Instance; Background Processes; System Global Area; Database buffer cache; Shared pool; Redo log buffer; Large pool; Files; Parameter files; Control file; Datafiles; Redo log files; Logical Database Structures; Software Options; Base Product; Licensing; Version Numbers; Configuration Planning; Availability; Replication; Hot standby database; Real Application Clusters (RAC); Backup and Recovery; Performance; Memory; Disk layout; Installation; Planning
- Installing the Oracle SoftwareCreating a Database; Using the DBCA; Creating a database manually; Initialization Parameters; INIT.ORA: The Initialization File; SPFILE: The Server Parameter File; Dynamic and Static Parameters; Backup and Recovery; Export (EXP) and Import (IMP); EXP and IMP commands; Common Export/Import parameters; Export-only parameters; Import-only parameters; Data Pump Export and Import; Data Pump features; Data Pump privileges; Data Pump Export and Import commands; Export comparison; Import comparison; User-Managed Backup and Recovery; Archivelog mode
- What files should be backed up?Backing up datafiles; Backing up log files; Backing up the control file; Backing up miscellaneous files; Restoring datafiles; Restoring the control file; Tablespace point-in-time recovery; Backup and Recovery Commands; ALTER DATABASE BACKUP CONTROLFILE; ALTER DATABASE OPEN; ALTER SYSTEM; CREATE CONTROLFILE; DBVERIFY; OCOPY; RECOVER; STARTUP MOUNT; Recovery Manager; RMAN fundamentals; Running RMAN; Using RMAN scripts; RMAN commands; Security; Authentication; CREATE USER; ALTER USER; Profiles; CREATE PROFILE; ALTER PROFILE; DROP PROFILE; Privileges
- System privilegesAUDIT; CLUSTER; CONTEXT; DATABASE; DATABASE LINKS; DEBUG; DIMENSION; DIRECTORY; INDEX; INDEXTYPE; LIBRARY; MATERIALIZED VIEW; OPERATOR; OUTLINE; PROCEDURE; PROFILE; RESOURCE COST; ROLE; ROLLBACK SEGMENT; SEQUENCE; SESSION; SYNONYM; SYSTEM; TABLE; TABLESPACES; TRIGGER; TYPES; USER; VIEW; Miscellaneous privileges; Special system privileges; Schema object privileges; Directories; External tables; Indextypes; Libraries; Materialized views; Operators; Procedures, functions, and packages; Sequences; Tables; User-defined types; Views; Privilege commands; GRANT; REVOKE; Roles
- CREATE ROLEALTER ROLE; DROP ROLE; SET ROLE; Auditing; AUDIT; NOAUDIT; Other Security Features; Views; Stored procedures; Fine-grained access control and security policy; Virtual Private Database; Label security and Policy Manager; Application contexts; Fine-grained auditing; LogMiner; Oracle Advanced Security; Oracle Internet Directory; Invoker rights; The Data Dictionary; Static Views; Families of views; Advisor views; Change Data Capture views; Constraint views; Data dictionary views; Index views; Jobs and Advanced Queuing views; Lock views; Log group views; Materialized view views
- Networking and distributed transaction views
