Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 3 and 5 (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

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 5 as of 2006-06-09 03:07:20 → ⇥
  Size: 521
  Editor: fuzzy
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-''connect as sysdba'' ''
startup nomount''
+''connect as sysdba'' '' ''
-Line 8:
+Line 7:
-'''rman''' ''
connect tearget /
mount
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''
+''startup nomount''

'''rman''' '' ''

''connect target / ''

''mount ''

''BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''
-Line 14:
+Line 18:
-all the same, then
''recover database;''
-Line 17:
+Line 19:
-'''Create Oracle database for Control sql backend''' __start sqlplus:__
+ . all the same,
then ''recover database;''
-Line 19:
+Line 22:
-''sqlplus /nolog'' ''
connect sysadmin/sql as sysdba
startup nomount ''
+'''Create Oracle database for Control sql backend''' __ __

__start sqlplus:__

'' sqlplus /nolog'' '' ''

''connect sysadmin/sql as sysdba ''

''startup nomount ''