|
How to create 9i database with Automatic Undo Management feature
In Oracle 9i, you can create database with AUM (Automatic Undo Management) feature. AUM is one of the nice features of Oracle 9i.
Steps:
1. Edit init.ora file and set the value of the following parameters.
UNDO_MANAGEMENT = AUTO
UNDO_TABLESPACE = UNDOTBS
Here UNDOTBS is rhe name of your undo tablespace.
2. Creating an undo tablespace during database creation:
In the CREATE DATABASE statement, use the UNDO TABLESPACE clause to specify the name of the tablespace to be created and used for AUM.
Note: If you do not specify any UNDO TABLESPACE clause, an undo tablespace with the name SYS_UNDOTBS is automatically created (with a filename 'DBU1.dbf').
Database creation script:
CREATE DATABASE prod
LOGFILE '/u01/oradata/prod/redo01.log' SIZE 1024K,
'/u01/oradata/prod/redo02.log' SIZE 1024K,
'/u01/oradata/prod/redo03.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE '/u01/oradata/prod/system01.dbf' SIZE 264M REUSE
AUTOEXTEND ON NEXT 10240K
UNDO TABLESPACE rbs DATAFILE '/u01/oradata/prod/rbs01.dbf' SIZE 400M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16;
Use above script to create the database. It will create UNDOTBS tablespace with database creation.
|
About author:
Vigyan Kaushik is an Oracle certified professional serving IT industry for more than 10 years as an Oracle DBA and System Administrator. He has expertise in Database Designing, Administration, Networking, Tuning, Implementation, Maintenance with web deployment activities on different Unix flavors as well as on Windows Operating Systems.
|
|
|
