Archive for 09/01/2009 - 10/01/2009

Hot Topics Of My Oracle Diary - 2


Restricting “root” access to database
Today’s first topic is about access restriction. Bazlur asked on OTN forum, if he can restrict root users’ access to database. He’s the vendor (owner of the database) who doesn’t want the customer (owner of the os) to connect his database. (It seems familiar to me:))
The result comes with Oracle Database Vault with no other option.

Restore Only One Tablespace From a Cold Backup to Another Database?
This topic is about partial restore of a database backup. It’s not possible to restore “just” 1 tablespace from a full RMAN backup, but if you have time and space issues and you need just 1 tablespace, you can restore just SYSTEM, SYSAUX, UNDO + a particular TS. Metalink doc 102786.1 (Partial Restore Of A Database) describes the steps clearly for this case. The “purpose” part of this document also describes a possible scenario:
“The purpose of this article is to show how to partially restore a database backup. When you've accidentally dropped some objects or deleted rows from a table you can restore a backup of that database as a copy. Using the archivelog files you can rollforward until a time just before the drop or delete. After the rollforward you can export the data from that copy of the database. That export can be used to import the data into the live database. When the database is very large and you're only after a few objects it might not make sense to restore the full backup.”

Hot Topics Of My Oracle Diary - 1

Flashback on a Physical Standby Database

First topic is about using flashback feature on a physical standby database.
Metalink note "How To Open Physical Standby For Read Write Testing and Flashback" (805438.1) is one of the helpful sources. Another useful doc is "Oracle® Data Guard Concepts and Administration 10g Release 2 (10.2)" with the section "Using a Physical Standby Database for Read/Write Testing and Reporting" . And the last one comes from Alejandro Vargas : "Using a 10g R2 Oracle Physical Standby Database For Read/Write Testing and Reporting"

What they said :
"it's basically the manual process of doing what oracle's "snapshot standby" feature does in 11g."
"Just be sure to drop the restore point when you're done, or Oracle will fill up your FRA with flashback logs."

Discussion in Oracle-l group (freelists.org).

---------------------

SAN Level Replication vs. Dataguard?

Discussion in Oracle-l group (freelists.org) with "Replicating Live Oracle DataFiles/LUNs to remote site via SAN tool?" topic, has a nice discussion about comparison of SAN replication and Dataguard.

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -