Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 1 and 4 (spanning 3 versions)

Backup database using rman (always make at least one backup even on empty database!)

sqlplus

connect as sysdba

startup nomount

rman

connect tearget /

mount

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 1 as of 2006-06-09 02:45:43 → 
  Size: 471
  Editor: fuzzy
  Comment:
+   ← Revision 4 as of 2006-06-09 02:48:32 → ⇥
  Size: 531
  Editor: fuzzy
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-''connect as sysdba
startup nomount''

'''rman'''
''connect tearget /
mount
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
+''connect as sysdba'' ''
-Line 14:
+Line 8:
+''startup nomount''

'''rman''' ''
''

''connect tearget /
''

''mount
''

''BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''
-Line 15:
+Line 22:
-'''all the same,
''recover database;''
+'''
-Line 18:
+Line 24:
-'''Create Oracle database for Control sql backend'''
+ all the same,

then ''recover database;''

'''Create Oracle database for Control sql backend''' __
__
-Line 21:
+Line 33:
-''sqlplus /nolog''
+''
sqlplus /nolog'' ''
''
-Line 23:
+Line 38:
-shutdown abort
startup nomount
-Line 26:
+Line 39:
+''startup nomount ''