Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 2 and 10 (spanning 8 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 2 as of 2006-06-09 02:46:35 → 
  Size: 475
  Editor: fuzzy
  Comment:
+   ← Revision 10 as of 2006-06-29 00:43:28 → ⇥
  Size: 503
  Editor: FayezMoussa
  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!) ===
{{{
sqlplus
connect as sysdba
startup nomount
rman
connect target /
mount database 
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
recover
}}}
 . all the same,
then ''recover database;''
-Line 3:
+Line 15:
-'''''sqlplus'''''
+'''Create Oracle database for Control sql backend (not available in free version)''' __ __
-Line 5:
+Line 17:
-''connect as sysdba''
''startup nomount''

'''rman'''
''connect tearget /
mount
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
''

'''recover
'''all the same,
''recover database;''

'''Create Oracle database for Control sql backend'''
-Line 21:
+Line 19:
-''sqlplus /nolog''
''connect sysadmin/sql as sysdba
shutdown abort
+{{{
sqlplus /nolog
connect sysadmin/sql as sysdba
-Line 25:
+Line 23:
-''
+}}}
----
CategorySql