Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 2 and 3

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 all the same, then recover database;

Create Oracle database for Control sql backend start sqlplus:

sqlplus /nolog connect sysadmin/sql as sysdba startup nomount

-  ⇤ ← Revision 2 as of 2006-06-09 02:46:35 → 
  Size: 475
  Editor: fuzzy
  Comment:
+   ← Revision 3 as of 2006-06-09 02:47:34 → ⇥
  Size: 465
  Editor: fuzzy
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-''connect as sysdba''
''startup nomount''
+''connect as sysdba'' ''
startup nomount''
 Line 8:
-'''rman'''
''connect tearget /
+'''rman''' ''
connect tearget /
 Line 11:
-BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
''
+BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''
-Line 14:
+Line 13:
-'''recover
'''all the same,
+'''recover '''
all the same, then
-Line 18:
+Line 17:
-'''Create Oracle database for Control sql backend'''
__start sqlplus:__
+'''Create Oracle database for Control sql backend''' __start sqlplus:__
-Line 21:
+Line 19:
-''sqlplus /nolog''
''connect sysadmin/sql as sysdba
shutdown abort
startup nomount
''
+''sqlplus /nolog'' ''
connect sysadmin/sql as sysdba
startup nomount ''