Oracle: verschil tussen versies
Uit Documents
| Regel 3: | Regel 3: | ||
=== Startup / Shutdown === | === Startup / Shutdown === | ||
| − | Login to SQL prompt: sqlplus / as sysdba | + | Login to SQL prompt: |
| + | <syntaxhighlight lang="bash">sqlplus / as sysdba</syntaxhighlight> | ||
Startup normally | Startup normally | ||
| − | SQL> startup | + | <syntaxhighlight lang="sql">SQL> startup;</syntaxhighlight> |
Startup without actually mounting | Startup without actually mounting | ||
| − | SQL> startup nomount | + | <syntaxhighlight lang="sql">SQL> startup nomount;</syntaxhighlight> |
Use additional initialization file: | Use additional initialization file: | ||
| − | SQL> startup nomount pfile='/path/to/init.ora' | + | <syntaxhighlight lang="sql">SQL> startup nomount pfile='/path/to/init.ora';</syntaxhighlight> |
Shutdown: | Shutdown: | ||
| − | SQL> shutdown | + | <syntaxhighlight lang="sql">SQL> shutdown;</syntaxhighlight> |
Shutdown and terminate existing connections | Shutdown and terminate existing connections | ||
| − | SQL> shutdown immediate; | + | <syntaxhighlight lang="sql">SQL> shutdown immediate;</syntaxhighlight> |
Shutdown and abort everything (last resort): | Shutdown and abort everything (last resort): | ||
| − | SQL> shutdown abort; | + | <syntaxhighlight lang="sql">SQL> shutdown abort;</syntaxhighlight> |
=== RMAN === | === RMAN === | ||
Versie van 1 apr 2011 om 19:47
Inhoud
Oracle
Startup / Shutdown
Login to SQL prompt:
sqlplus / as sysdbaStartup 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]
