Posts tagged 10gR2
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. These backups go to an NFS share, and not straight to tape. Everything is running fine until one day a new release of one of the applications messes up its data. Let’s assume that happened on a Wednesday evening.
Application management want’s you to restore the data of app_schema to just before the new misbehaving release went live.
DBA: Say what? Mgmt: Yes, we have a backup don’t we? So please put the data back to just before this release went live. We’ll come back with the exact time we want you to go back to.
What are your options? (more…)
A few years ago I was lucky to be able to start working for a client that has Oracle RAC clusters. There we encountered lot’s of interesting issues, and one of them was that several client applications couldn’t seem to connect to the RAC cluster whenever a service was failed over to an other instance then the default.
The network environment was a bit different then I was used to work with. There are three domains in use: - domainA for the RAC and other servers, - domainB for the desktop pc’s and laptops - domainC for the citrix farm and the applications hosted there
The tnsnames.ora for domainB and domainC contained an entry like: