Scotech Scotech
Knowledge Base
[ Home | KB | Tools | Requests? ]


Oracle 10g STARTUP and SHUTDOWN tiers


STARTUP tiers

STARTUP NOMOUNT # Backup, recovery, etc
STARTUP MOUNT # Control files open (no data files)
STARTUP OPEN # All files (including data) are open

SHUTDOWN tiers

SHUTDOWN ABORT # Only use this as a last resort
SHUTDOWN IMMEDIATE # Forces a checkpoint and closes
SHUTDOWN TRANSACTIONAL # Waits on current transactions
SHUTDOWN NORMAL # Waits on current sessions (Zzz!)

- Scotech



[ Home | KB | Tools | Email: info@scotech.com ]

© 1996-2010 Scotech. All rights reserved.