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

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.