Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Tag Archives: restore
Recover a dropped table without flashback enabled.
You don’t have to restore the whole database to get back a dropped table without flashback. But there is quite a bit of work involved. It may prove not to be worth the effort.
Posted in Recovery Manager
Tagged DROPPED~TABLE, FLASHBACK, Recovery, RECOVER~TABLE, restore
Comments Off
How to restore an Spfile from autobackup older than 7 days
Whenever we issue in RMAN, RMAN> restore spfile from autobackup; then restoring from autobackup stops at seven days and then it arises message channel ORA_DISK_1: no autobackup in 7 days found.
Rman and Ulimit Problem
Had an interesting one, Rman states that the backup piece’s do not exist, but they are on the OS. Why could I not catalog them ? ….. Here’s where I tried to get them available for restoring. run { allocate … Continue reading
Posted in Configuration., Oracle, Parameters, Recovery Manager
Tagged crosscheck, REGISTER, restore, ulimit
Comments Off
