ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH
export PATH
BKUP_DEST=/home/mohan/backups
find $BKUP_DEST -name 'backup*.dmp' -mtime +10 -exec rm {} \;
cd /home/mohan/backups && /u01/app/oracle/product/11.2.0/xe/bin/exp schema/password FILE=backup_`date +'%Y%m%d-%H%M'`.dmp STATISTICS=NONE
startup nomount pfile=/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
/
create database
maxinstances 1
maxloghistory 2
maxlogfiles 16
maxlogmembers 2
maxdatafiles 30
datafile '/u01/app/oracle/oradata/XE/system.dbf'
size 200M reuse autoextend on next 10M maxsize 600M
extent management local
sysaux datafile '/u01/app/oracle/oradata/XE/sysaux.dbf'
size 10M reuse autoextend on next 10M
default temporary tablespace temp tempfile
'/u01/app/oracle/oradata/XE/temp.dbf'
size 20M reuse autoextend on next 10M maxsize 500M
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/XE/undotbs1.dbf'
size 50M reuse autoextend on next 5M maxsize 500M
character set cl8mswin1251
national character set al16utf16
set time_zone='00:00'
controlfile reuse
logfile '/u01/app/oracle/oradata/XE/log1.dbf' size 50m reuse
, '/u01/app/oracle/oradata/XE/log2.dbf' size 50m reuse
, '/u01/app/oracle/oradata/XE/log3.dbf' size 50m reuse
user system identified by oracle
user sys identified by oracle
/
create tablespace users
datafile '/u01/app/oracle/oradata/XE/users.dbf'
size 100M reuse autoextend on next 10M maxsize 11G
extent management local
/
exit;
Recent Comments