Diff for "OracleDatabase" - Creative Computing Wiki

Differences between revisions 4 and 9 (spanning 5 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 4 as of 2006-06-09 02:48:32 → 
  Size: 531
  Editor: fuzzy
  Comment:
+   ← Revision 9 as of 2006-06-25 23:23:45 → ⇥
  Size: 484
  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!)'''

'''''sqlplus'''''

''connect as sysdba'' ''
''

''startup nomount''

'''rman''' ''
''

''connect tearget /
''

''mount
''

''BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; ''

'''recover
'''

 all the same,
+=== 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,
-Line 28:
+Line 15:
-'''Create Oracle database for Control sql backend''' __
__
+'''Create Oracle database for Control sql backend (not available in free version)''' __ __
-Line 33:
+Line 19:
-''
sqlplus /nolog'' ''
''

''connect sysadmin/sql as sysdba
''

''startup nomount ''
+{{{
sqlplus /nolog
connect sysadmin/sql as sysdba
startup nomount
}}}