Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 4 and 6 (spanning 2 versions)

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

then recover database;

Create Oracle database for Control sql backend

start sqlplus:

sqlplus /nolog

connect sysadmin/sql as sysdba

startup nomount

-  ⇤ ← Revision 4 as of 2006-06-09 02:48:32 → 
  Size: 531
  Editor: fuzzy
  Comment:
+   ← Revision 6 as of 2006-06-09 03:12:03 → ⇥
  Size: 530
  Editor: fuzzy
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-''connect as sysdba'' ''
''
+''connect as sysdba'' '' ''
-Line 10:
+Line 9:
-'''rman''' ''
''
+'''rman''' '' ''
-Line 13:
+Line 11:
-''connect tearget /
''
+''connect target / ''
-Line 16:
+Line 13:
-''mount
''
+''mount database ''
-Line 21:
+Line 17:
-'''recover
'''
+'''recover '''
-Line 24:
+Line 19:
- all the same,
+ . all the same,
-Line 28:
+Line 22:
-'''Create Oracle database for Control sql backend''' __
__
+'''Create Oracle database for Control sql backend''' __ __
-Line 33:
+Line 26:
-''
sqlplus /nolog'' ''
''
+'' sqlplus /nolog'' '' ''
-Line 37:
+Line 28:
-''connect sysadmin/sql as sysdba
''
+''connect sysadmin/sql as sysdba ''