Differences between revisions 7 and 9 (spanning 2 versions)
⇤ ← Revision 7 as of 2006-06-21 06:58:38 →
Size: 513
Editor: FayezMoussa
Comment:
← Revision 9 as of 2006-06-25 23:23:45 → ⇥
Size: 484
Editor: FayezMoussa
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:

'''''sqlplus'''''

''connect as sysdba'' '' ''

''startup nomount''

'''rman'''

''connect target / ''

''mount database ''

''BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''

'''recover '''		 {{{
sqlplus
connect as sysdba
startup nomount
rman
connect target /
mount database
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
recover
}}}
Line 22: Line 15:
'''Create Oracle database for Control sql backend''' __ __ '''Create Oracle database for Control sql backend (not available in free version)''' __ __
Line 25: Line 18:
Line 27: Line 21:
Line 29: Line 22:

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)