Continuation of Part 2 ORACLE – Creating a Data Guard Physical Standby environment – Part2 Standby Database Steps Create a Control File from Primary database for the Standby Database. The standby database will use a control file that is generated on… Read More
STORAGE MANAGEMENT In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments. Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More
Continuation to the Data Guard Physical standby creation ORACLE – Creating a Data Guard Physical Standby environment – PART1 Enable Archiving On 10g you can enable archive log mode by mounting the database and executing the archivelog command:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> startup mount; ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 75499088 bytes Database Buffers 205520896 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Archive Mode Database log mode Automatic archival Enabled Archive destination /test/PRIMARYDB/archdest/arch Oldest online log sequence 92 Next log sequence to archive 94 Current log sequence 94 |
Set… Read More
Creating a Data Guard Physical Standby environment Once you have your primary database up and running these are the steps to follow. Enable Forced Logging Create a Password File Configure a Standby Redo Log Enable Archiving Set Primary Database Initialization Parameters… Read More
Dear Readers, In this article, we will see the following Multitenant Database Introduction A Container database (CDB) is made up of the following containers: There is one root container which stores the Oracle supplied metadata like the PL/SQL data dictionary packages and the common users.… Read More
Introduction to Oracle Data Guard Data Guard gives us the high availability, data protection and disaster recovery for the data. Configuring one or more standby databases for the production database can help in surviving the disasters and data corruptions. The Oracle Data Guard can… Read More
Cross Platform Transportable Tablespace Transportable Tablespace is used to move a large amount of data between databases where the tablespace is copied from source database to the target database. A Tablespace can be Transport between databases on the same Platform from version 8i.… Read More
DATABASE CREATION Oracle Database can create by using the following 3 methods Manual database creation OMF method (Oracle Managed database Files) DBCA method (Database Configuration Assistance) Steps to create database in manual method. Declare or specify variables or set up environmental variables:… Read More
TRANSPORTABLE TABLESPACE IN ORACLE Transportable Tablespace is used to move large amount of data between… Read More
Oracle provides a trial cloud account worth USD 300 to individuals and organizations to test the cloud services. This is a good starting point to be familiar and have a hands on with oracle cloud services. The trial account provides complete spectrum of services to play with. Sign up… Read More
