Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 1 and 8 (spanning 7 versions)

sqlplus

connect as sysdba

startup nomount

rman

connect target /

mount database

BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;

recover

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

-  ⇤ ← Revision 1 as of 2006-06-09 02:45:43 → 
  Size: 471
  Editor: fuzzy
  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 1:
-'''Backup database using rman (always make at least one backup even on empty database!)'''
+=== Backup database using rman (always make at least one backup even on empty database!) ===
-Line 5:
+Line 4:
-''connect as sysdba
startup nomount''
+''connect as sysdba'' '' ''

''startup nomount''
 Line 9:
-''connect tearget /
mount
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
''
-Line 14:
+Line 10:
-'''recover
'''all the same,
''recover database;''
+''connect target / ''
-Line 18:
+Line 12:
-'''Create Oracle database for Control sql backend'''
+''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)''' __ __
-Line 21:
+Line 25:
-''sqlplus /nolog''
''connect sysadmin/sql as sysdba
shutdown abort
+{{{
sqlplus /nolog
connect sysadmin/sql as sysdba
-Line 25:
+Line 29:
-''
+}}}