- CREATE DATABASE MANUALLY IN ORACLE 10G HOW TO
- CREATE DATABASE MANUALLY IN ORACLE 10G INSTALL
- CREATE DATABASE MANUALLY IN ORACLE 10G MANUAL
- CREATE DATABASE MANUALLY IN ORACLE 10G PASSWORD
Install Oracle database software without the starter database on the standby server and patch it if necessary. Make sure the operating system and platform architecture on the primary and standby systems are the same Ģ.
The Primary database is called PRIM and the Standby database is called STAN. The Primary database and Standby database are located on different machines at different sites. In this example the database version is 10.2.0.3. I would like to share my experience with the other DBAs. I have been working on Data Guard/Standby databases using both Grid control and SQL command line for a couple of years, and my latest experience with Data Guard was manually creating a Physical Standby Database for a Laboratory Information Management System (LIMS) half a year ago. Oracle 10g Data Guard is a great tool to ensure high availability, data protection and disaster recovery for enterprise data.
CREATE DATABASE MANUALLY IN ORACLE 10G HOW TO
Step-by-step instructions on how to create a Physical Standby Database on Windows and UNIX servers, and maintenance tips on the databases in a Data Guard Environment. Suggestions and Corrections are welcome.Oracle 10g - Manually Create a Physical Standby Database Using Data Guard SQL> Creating set your asm environment and you can see all these files from asmcmd. If something goes wrong with the creation, Oracle will write an error into the alert log.Ĭompleting the DB creation In order to complete the db creation, the following scripts must be run as sys Undo tablespace undo datafile '+DATA' size 10M
Sysaux datafile '+DATA ' size 10M autoextend on next 10M maxsize unlimited Creating the database SQL>create database orclĭatafile '+DATA' size 50M autoextend on next 10M maxsize unlimited extent management local This created the SGA (System Global Area) and the background processe s. SQL> startup nomount pfile='/home/oracle/pfile.ora' ORACLE instance started. We have to start the instance without mounting ( nomount) as there is no database we could mount at the moment. SQL*Plus tells us that we're connected to an idle instance. SQL> connect sys/password as sysdba Connected to an idle instance.
CREATE DATABASE MANUALLY IN ORACLE 10G PASSWORD
Make sure you create the password file before you proceed with the instance startup. Note : Make sure you create the dump file directories( adump,udump,bdump,cdump) *.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)' export ORACLE_SID=ORCL Creating the initialization parameter file *.audit_file_dest='/u01/oracle/product/10.2.0/db_1/admin/orcl/adump' The SID can be set through the ORACLE_SID environment variable. SQL> select group_number,name,state,total_mb/1024 TOTAL_GB,free_mb FREE_GB from v$asm_Diskgroup
CREATE DATABASE MANUALLY IN ORACLE 10G MANUAL
Just for the understading of junior members in my present team.!!īefore Proceeding with Manual Database Creation Make sure you have the asm instance is running, Diskgroup is mounted and Sufficient space available for creating the database.
0 kommentar(er)
