Business WordPress Theme

   
CREATING LOGICAL STANDBY DATABASE – ORACLE 10GR2

CREATING LOGICAL STANDBY DATABASE – ORACLE 10GR2
Creating a Logical Standby Database   Database DB_UNIQUE_NAME Oracle Net Service Name Host name Primary s2idm s2idm svlidmdb01-stg Logical standby s1idm s1idm sacidmdb01-stg   1.     Prerequisite Conditions on Primary database 1.1   Determine Support for Data Types and Storage Attributes for Tables See “Oracle Data Guard concepts and Administration 10g Release 2(10.2)” Appendix C for a complete list of data type and storage type considerations. 1.2    Ensure Table Rows in the Primary Database Can Be Uniquely Identified 1.2.1 Find tables without unique logical identifier in the primary database. [SQL1]  SQL> SELECT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_NOT_UNIQUE     WHERE (OWNER, TABLE_NAME) NOT IN (SELECT DISTINCT OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED...
Read More

   
Refresh an Oracle Database using a hot backup and NDMPCOPY

Refresh an Oracle Database using a hot backup and NDMPCOPY
Refresh an Oracle Database using a hot backup and NDMPCOPY SOURCE_SID s2idm TARGET_SID s1idm SOURCE_SERVER SVLIDMDB01-STG TARGET_SERVER SVLIDMDBS SOURCE_VOL svlstgflr11:/vol/s2idm_stg_oradata01svlstgflr12:/vol/s2idm_stg_oradata02 TARGET_VOL svlstgflr506-data1:/vol/s1idm_stg_oradata01/s1idm SOURCE_SNAPSHOT svlstgflr11:/vol/s2idm_stg_oradata01/.snapshot/s2idm_daily.0svlstgflr12:/vol/s2idm_stg_oradata02/.snapshot/s2idm_daily.0 TARGET FILER PASSWORD $ sudo rsh <filer name> ndmpd password ndmpuser Script for creating TEMP tablespaceon TARGET_SERVER /u/oracle/refresh_idm/cr_temp.sql Script for creating new controlfile on TARGET_SERVER /u/oracle/refresh_idm/cr_s1idm.sql   1.      Clean disk spaces on target server.   svlidmdbs{oracle}:  rm /or...
Read More

   
19 Topics for Database Administrators and Developers

19 Topics for Database Administrators and Developers
source : http://docs.oracle.com The previous parts of this manual described the basic architecture of Oracle Database. This chapter summarizes common database topics that are important for both database administrators and developers, and provides pointers to other manuals, not an exhaustive account of database features. This chapter contains the following sections: Overview of Database Security Overview of High Availability Overview of Grid Computing Overview of Data Warehousing and Business Intelligence Overview of Oracle Information Integration See Also: Concepts for Database Administrators for topics specific to DBAs, and Concepts for Database Developers for topics specific to database developers   Overview of Database Security In general, database security involves user ...
Read More

   
18 Overview of the Multitenant Architecture

18 Overview of the Multitenant Architecture
source : http://docs.oracle.com This section contains the following topics: Overview of Containers in a CDB Overview of Services in a CDB Overview of Commonality in a CDB Overview of Database Files in a CDB Overview of Containers in a CDB A container is a collection of schemas, objects, and related structures in a multitenant container database (CDB) that appears logically to an application as a separate database. Within a CDB, each container has a unique ID and name. The root and every pluggable database (PDB) is considered a container. PDBs isolate data and operations so that from the perspective of a user or application, each PDB appears as if it were a traditional non-CDB. This section contains the following topics: The Root PDBs Data Dictionary Architecture in a CDB Curre...
Read More

   
17 Introduction to the Multitenant Architecture

17 Introduction to the Multitenant Architecture
source : http://docs.oracle.com This chapter contains information specific to the Oracle Multitenant option. It includes the following topics: About the Multitenant Architecture Benefits of the Multitenant Architecture Path to Database Consolidation Multitenant Environment Documentation Roadmap   About the Multitenant Architecture The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB). A CDB includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs. Video: Oracle Database 12c: Introduction to a Multitenant Environment w...
Read More

   
16 Application and Networking Architecture

16 Application and Networking Architecture
source : http://docs.oracle.com/ This chapter defines application architecture and describes how an Oracle database and database applications work in a distributed processing environment. This material applies to almost every type of Oracle Database environment. This chapter contains the following sections: Overview of Oracle Application Architecture Overview of Global Data Services Overview of Oracle Networking Architecture Overview of the Program Interface   Overview of Oracle Application Architecture In the context of this chapter, application architecture refers to the computing environment in which a database application connects to an Oracle database. This section contains the following topics: Overview of Client/Server Architecture Overview of Multitier Architecture ...
Read More