Differences between revisions 7 and 10 (spanning 3 versions)
Revision 7 as of 2006-06-21 06:58:38
Size: 513
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 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:
Line 32: 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)