Differences between revisions 7 and 8
⇤ ← Revision 7 as of 2006-06-21 06:58:38 →
Size: 513
Editor: FayezMoussa
Comment:
← Revision 8 as of 2006-06-25 22:36:32 → ⇥
Size: 541
Editor: fuzzy
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
Line 22: Line 21:
'''Create Oracle database for Control sql backend''' __ __ '''Create Oracle database for Control sql backend (not available in free version)''' __ __
Line 25: Line 24:
Line 27: Line 27:
Line 29: Line 28:

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

sqlplus

connect as sysdba

startup nomount

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)

start sqlplus: 

sqlplus /nolog
connect sysadmin/sql as sysdba
startup nomount

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