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.”
