-
Recent Posts
Archives
Categories
- Adding Linux hosts
- AWR
- Backup and recovery
- Configure reverse lookup DNS zone
- Configure VNCserver
- Configure with Grid Control
- Create ASM diskgroup
- Create database
- Create RAC database
- Database administration
- Database security
- Dataguard Broker
- devlinks
- DNS configuration
- DNS configuration
- DNS configuration
- General
- Generate AWR report
- Install Grid Infrastructure
- Install Grid Infrastructure
- Install Oracle database software
- Install packages
- Install RAC database software
- Installation
- Installing Oracle Cloud Control 12c Agent
- iSCSI
- Join Windows Server domain
- Join Windows Server domain
- Listener administration
- Locking
- Logical standby database
- Migrate AWR snapshots
- Network configuration
- Oracle 10g Grid Control
- Oracle 10g Release 2
- Oracle 11g Grid Control
- Oracle 11g Release 2
- Oracle database silent installation
- Oracle Dataguard
- Oracle Dataguard
- Oracle errors
- Oracle Grid Control
- Oracle Linux 5
- Oracle Net Services configuration
- Oracle RAC
- Oracle Solaris 10
- Oracle Solaris 11
- OS error messages
- OS user creation
- Partitioned index
- Partitioning
- Patch installation
- Performance monitoring
- RAC network configuration
- Recovery Manager (RMAN)
- Recovery Manager (RMAN)
- RHEL 5
- RHEL/OEL error messages
- RPM management
- RPM management
- Solaris DNS server
- Transparent Data Encryption
- Uncategorized
- Update date settings (NTP)
- Update date settings (NTP)
- Upgrade 11g Repository
- Upgrading 11g Grid Control
- Upgrading 11g OMS
- User administration
- Volume groups
- Windows Server 2008
- YUM repository
- YUM repository
- ZFS filesystem
Tag Archives: restore spfile
Oracle 11g RMAN: Restore SPFILE using AUTOBACKUP with non-default location and non-default name
One of the common scenarios for recovering from database failures is the loss of the spfile and/or controlfile, usually following failures on the database storage media (for example a SAN storage failure). Therefore it is very useful to have an … Continue reading
oracletempspace (or my adventures with Oracle) 