Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 3 and 4

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 3 as of 2006-06-09 02:47:34 → 
  Size: 465
  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 6:
-startup nomount''
+''

''startup nomount''
-Line 9:
+Line 11:
-connect tearget /
mount
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''
+''
 Line 13:
-'''recover '''
all the same, then
''recover database;''
+''connect tearget /
''
-Line 17:
+Line 16:
-'''Create Oracle database for Control sql backend''' __start sqlplus:__
+''mount
''
 Line 19:
-''sqlplus /nolog'' ''
connect sysadmin/sql as sysdba
startup nomount ''
+''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 ''