Differences between revisions 9 and 10
⇤ ← Revision 9 as of 2006-06-25 23:23:45 →
Size: 484
Editor: FayezMoussa
Comment:
← Revision 10 as of 2006-06-29 00:43:28 → ⇥
Size: 503
Editor: FayezMoussa
Comment:
Deletions are marked like this. Additions are marked like this.
Line 24: Line 24:
----
CategorySql

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

CategorySql

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