Oracle: verschil tussen versies
Uit Documents
| Regel 1: | Regel 1: | ||
== Oracle == | == Oracle == | ||
| + | |||
| + | === Startup / Shutdown === | ||
| + | |||
| + | Login to SQL prompt: sqlplus / as sysdba | ||
| + | |||
| + | Startup normally | ||
| + | SQL> startup | ||
| + | |||
| + | Startup without actually mounting | ||
| + | SQL> startup nomount | ||
| + | |||
| + | Use additional initialization file: | ||
| + | SQL> startup nomount pfile='/path/to/init.ora' | ||
| + | |||
| + | Shutdown: | ||
| + | SQL> shutdown | ||
| + | |||
| + | Shutdown and terminate existing connections | ||
| + | SQL> shutdown immediate; | ||
| + | |||
| + | Shutdown and abort everything (last resort): | ||
| + | SQL> shutdown abort; | ||
=== RMAN === | === RMAN === | ||
Versie van 1 apr 2011 om 19:44
Inhoud
Oracle
Startup / Shutdown
Login to SQL prompt: sqlplus / as sysdba
Startup normally SQL> startup
Startup without actually mounting SQL> startup nomount
Use additional initialization file: SQL> startup nomount pfile='/path/to/init.ora'
Shutdown: SQL> shutdown
Shutdown and terminate existing connections SQL> shutdown immediate;
Shutdown and abort everything (last resort): SQL> shutdown abort;
RMAN
Segmentation Fault while restoring
Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.[1]
