Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 5 and 8 (spanning 3 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 5 as of 2006-06-09 03:07:20 → 
  Size: 521
  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 9:
+Line 8:
-'''rman''' '' ''
+'''rman'''
-Line 13:
+Line 12:
-''mount ''
+''mount database ''
-Line 22:
+Line 21:
-'''Create Oracle database for Control sql backend''' __ __
+'''Create Oracle database for Control sql backend (not available in free version)''' __ __
-Line 26:
+Line 25:
-'' sqlplus /nolog'' '' ''

''connect sysadmin/sql as sysdba ''

''startup nomount ''
+{{{
sqlplus /nolog
connect sysadmin/sql as sysdba
startup nomount
}}}