Re: Recovering a user

Sathya wrote:
> Hi,
>
> I want to know whether we can restore a user from cold backup. I will
> put my question this way. I have 2 DBs. DB1 has user1. I have taken
> coldbackup of DB1. I want to create that user in DB2 from coldbackup
> without affecting other things in DB2.
> It is really urgent. Your timely help is greatly appreciated.
>
> Regards,
> Sathya

Generally speaking during backup the database is considered as a whole. This means you can't recover individual users. You can recover individual tablespaces, but either in the original database, or in a partial restore of the original database in a new different database (not DB2). You could perform Tablespace Point in Time Recovery, provided you have a RMAN backup.
Typically one would do this with export import, or with export using transportable tablespaces.

There is no such thing as 'urgent' here, as this is a volunteer forum. If it's really urgent submit a service request with Oracle.

-- 
Sybrand Bakker
Senior Oracle DBA