Differences between revisions 6 and 7
⇤ ← Revision 6 as of 2006-06-09 03:12:03 →
Size: 530
Editor: fuzzy
Comment:
← Revision 7 as of 2006-06-21 06:58:38 → ⇥
Size: 513
Editor: FayezMoussa
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: 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!) ===
Line 9: Line 9:
'''rman''' '' '' '''rman'''
Line 25: Line 25:
{{{
sqlplus /nolog
Line 26: Line 28:
'' sqlplus /nolog'' '' '' connect sysadmin/sql as sysdba
Line 28: Line 30:
''connect sysadmin/sql as sysdba ''

''startup nomount ''		 startup nomount
}}}

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;

Create Oracle database for Control sql backend

start sqlplus: 

sqlplus /nolog

connect sysadmin/sql as sysdba

startup nomount

OracleDatabase (last edited 2013-09-18 06:09:33 by localhost)