Installation and Upgrade

Creating a 11g Database Manually by Scripts (2/3) – Create and check the new database

Posted on
Creating a 11g Database Manually by Scripts (1/3) – Prepare three files for creating the new databaseWhen the three files are ready, we can use them to create a new database “smalldb”.Set the environment profile.[oracle@primary01 ~]$ . smalldb_profile[oracle@primary01 ~]$ echo $ORACLE_SIDsmalldb[oracle@primary01 ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1Do other preparation works and create pfile.[oracle@primary01 ~]$ ./create_init.sh[oracle@primary01 ~]$ cat $ORACLE_HOME/dbs/initsmalldb.oracontrol_files […]
Installation and Upgrade

Creating a 11g Database Manually by Scripts (1/3) – Prepare three files for creating the new database

Posted on
Go Back to Overview Page – Creating a 11g Database Manually by Scripts (0/3) – An overviewHere are the three files we prepared for facilitating the creation of the database.An environmental profile can set the environment vairables of the new database.[oracle@primary01 ~]$ vi smalldb_profileORACLE_SID=smalldb; export ORACLE_SIDORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOMEWe call the new database “smalldb” and keep […]
Data Guard

Building a Physical Standby Database (14/14) – Verify all settings are correct

Posted on
Building a Physical Standby Database (13/14) – Configure data guard brokerAfter configuring the broker, let’s restart both the primary and standby databases and see whether the broker can persist across a shutdown.[oracle@standby01 ~]$ srvctl stop database -d compdb…[oracle@primary01 ~]$ srvctl stop database -d compdb…[oracle@standby01 ~]$ srvctl start database -d compdb -o mount…[oracle@primary01 ~]$ srvctl start […]
Data Guard

Building a Physical Standby Database (11/14) – Create spfile for both primary and standby database

Posted on
Building a Physical Standby Database (10/14) – Create standby redo logs on standby databaseSince the two pfiles are ready in the step 3, we can use them to create spfiles for the primary and standby database.On primary database.[oracle@primary01 ~]$ srvctl stop database -d compdb[oracle@primary01 ~]$ sqlplus / as sysdba…SQL> create spfile=’+data/compdb/spfileprimdb.ora’ from pfile=’/tmp/init-prim.ora’;File created.SQL> exit;…[oracle@primary01 […]
Data Guard

Building a Physical Standby Database (10/14) – Create standby redo logs on standby database

Posted on
Building a Physical Standby Database (09/14) – Copy standby controlfile into standby databaseBefore we create standby redo logs, lets restart the standby database to mount and check the current database role.[oracle@standby01 ~]$ srvctl stop database -d compdb[oracle@standby01 ~]$ srvctl start database -d compdb -o mount[oracle@standby01 ~]$ sqlplus / as sysdba…SQL> select inst_id, open_mode, database_role from […]
Data Guard

Building a Physical Standby Database (09/14) – Copy standby controlfile into standby database

Posted on
Building a Physical Standby Database (08/14) – Copy data files into standby databaseCopying a standby controlfile into the standby database is the same as copying individual data files into a standby database. So here we introduce only RMAN operations.Copy the standby controlfile from the primary server to either node of the standby RAC.[oracle@primary01 ~]$ scp […]