Differences between revisions 4 and 13 (spanning 9 versions)
⇤ ← Revision 4 as of 2006-06-09 02:48:32 →
Size: 531
Editor: fuzzy
Comment:
← Revision 13 as of 2006-07-03 01:56:31 → ⇥
Size: 2697
Editor: fuzzy
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
'''Backup database using rman (always make at least one backup even on empty database!)''' === Install Oracle database server ===
Line 3: Line 3:
'''''sqlplus''''' Make sure that you have at least 1G swap space on your machine.
Install oracle on separate machine if there are not to much memory available
minimum reasonable config for XE: 1G if this machine will be used only as oracle server
and 1.5 G if we will to run CONTROL on the same machine
Line 5: Line 8:
''connect as sysdba'' ''
''		 {{{
rpm -U /u2/programs/databases_and_odbc/oracle-xe-10.2.0.1-1.0.i386.rpm
}}}
Set password for user oracle.
Move datafile to somewhere where you have enough space (if there are more than 1 hard drive it is much better to use one for oracle database):
{{{
/etc/init.d stop
mv /usr/lib/oracle/xe/oradata /u2/somewhere
ln -s /u2/somewhere/oradata /usr/lib/oracle/xe/oradata
/etc/init.d start
}}}
Line 8: Line 20:
''startup nomount'' === Install Oracle database client ===
(if we want to run CONTROL and database on separate machines)
Line 10: Line 23:
'''rman''' ''
''		 {{{
rpm -U /u2/programs/databases_and_odbc/oracle-xe-client-10.2.0.1-1.0.i386.rpm
}}}
Line 13: Line 27:
''connect tearget /
''
Line 16: Line 28:
''mount
''		 ---- /!\ '''Edit conflict - other version:''' ----
include in .bash_profile following line:
{{{
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh
}}}
include in .bash_profile for all users who will use sql or control program:
{{{
. /usr/lib/oracle/????/app/oracle/product/10.2.0/server/bin/oracle_env.sh # (if database on the same machine) OR
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh # (if database located on different machine)
}}}
Line 19: Line 39:
''BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; '' . /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh
}}}
include in .bash_profile for all users who will use sql or control program:
{{{
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh # (if database on the same machine)
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh # (if database located on different machine)
}}}
Line 21: Line 47:
'''recover
'''		 ---- /!\ '''Edit conflict - your version:''' ----
include in .bash_profile for all users who will use sql or control program:
{{{
. /usr/lib/oracle/????xe???/app/oracle/product/10.2.0/server/bin/oracle_env.sh (if database on the same machine) OR
. /usr/lib/oracle/????xe???/app/oracle/product/10.2.0/client/bin/oracle_env.sh (if database located on different machine)
}}}
Line 24: Line 54:
 all the same,
Line 26: Line 55:
---- /!\ '''End of edit conflict''' ----

=== Backup database using rman (always make at least one backup even on empty database!) ===
{{{
sqlplus
connect as sysdba
SHUTDOWN IMMEDIATE;
startup nomount;
quit

rman
connect target /
mount database
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
}}}
=== Recover ===
all the same,
Line 28: Line 74:
'''Create Oracle database for Control sql backend''' __
__		 '''Create Oracle database for Control sql backend (not available in free version)'''
Line 31: Line 76:
__start sqlplus:__
Line 33: Line 77:
''
sqlplus /nolog'' ''
''

''connect sysadmin/sql as sysdba
''

''startup nomount ''		 ----
CategorySql

Install Oracle database server

Make sure that you have at least 1G swap space on your machine. Install oracle on separate machine if there are not to much memory available minimum reasonable config for XE: 1G if this machine will be used only as oracle server and 1.5 G if we will to run CONTROL on the same machine 

rpm -U /u2/programs/databases_and_odbc/oracle-xe-10.2.0.1-1.0.i386.rpm

Set password for user oracle. Move datafile to somewhere where you have enough space (if there are more than 1 hard drive it is much better to use one for oracle database): 

/etc/init.d stop 
mv /usr/lib/oracle/xe/oradata /u2/somewhere
ln -s /u2/somewhere/oradata /usr/lib/oracle/xe/oradata
/etc/init.d start

Install Oracle database client

(if we want to run CONTROL and database on separate machines) 

rpm -U /u2/programs/databases_and_odbc/oracle-xe-client-10.2.0.1-1.0.i386.rpm

/!\ Edit conflict - other version:

include in .bash_profile following line: 

. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh

include in .bash_profile for all users who will use sql or control program: 

. /usr/lib/oracle/????/app/oracle/product/10.2.0/server/bin/oracle_env.sh # (if database on the same machine) OR
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh # (if database located on different machine)

. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh }}} include in .bash_profile for all users who will use sql or control program: 

. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh # (if database on the same machine)
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh # (if database located on different machine)

/!\ Edit conflict - your version:

include in .bash_profile for all users who will use sql or control program: 

. /usr/lib/oracle/????xe???/app/oracle/product/10.2.0/server/bin/oracle_env.sh (if database on the same machine) OR
. /usr/lib/oracle/????xe???/app/oracle/product/10.2.0/client/bin/oracle_env.sh (if database located on different machine)

/!\ End of edit conflict

Backup database using rman (always make at least one backup even on empty database!)

sqlplus
connect as sysdba
SHUTDOWN IMMEDIATE;
startup nomount;
quit

rman
connect target /
mount database 
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;

Recover

all the same, then recover database;

Create Oracle database for Control sql backend (not available in free version)

CategorySql

OracleDatabase (last edited 2013-09-18 06:09:33 by localhost)