Online Apps DBA

One Stop Shop for Apps DBA’s

Custom Search





Error: ORA-00354 - (Oracle Hidden Parameter : _allow_resetlogs_corruption)

Posted in November 18th, 2008
by Muhammad Rawish Siddiqui in Disaster Recovery, advanced, backup, database

NOTE: This is One of the Hidden Oracle Parameters. DO NOT use it until and unless instructed by Oracle Support. You are trying to start your DATABASE, you found the aforementioned error i.e. ORA-00354.
.

Required Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but not including, […]

Popularity: 6% [?]

read more from this topic.....

1 Comment

Recover an accidentally deleted file when the database is still open.

Posted in October 22nd, 2008
by Rupesh in Disaster Recovery, Unix, backup, database

On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed.
But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd .
In the following example, we use that behavior […]

Popularity: 12% [?]

read more from this topic.....

11 Comments

Oracle Database - RMAN overview

Posted in October 5th, 2008
by Atul Kumar in backup, database

Solution available for backup and recovery of Oracle Database
i) RMAN (Recovery Manager)
ii) User Managed backup (using o.s. commands like cp, copy..)
.
RMAN (Recovery Manager) - is Oracle Database client that perform backup & restore task of oracle database.
.
Components in RMAN
1. Target Database - is Oracle database which you want to backup or restore. You use RMAN […]

Popularity: 7% [?]

read more from this topic.....

1 Comment

Backup & Recovery in Oracle Apps Database

Posted in September 12th, 2006
by Atul Kumar in Disaster Recovery, backup

Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps 11i database & application tier.
I’ll discuss on How to troubleshoot load balancer in oracle Apps after Backup & Recover.
You might have read in Oracle Documentation lot of time to backup your system before applying patch […]

Popularity: 5% [?]

read more from this topic.....

14 Comments