Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB
I lost one datafile i dont have backup how can you recover that???
You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
Give the stages of instance startup to a usable state where
normal users may access it.
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?