Re: Recovering a user

Hi,
 I did the same.
 I have one more query how do i recover only 1 user. I have a hot backup for each user. My archive logs are enabled. Let's say I dropped a user. I want to recover that user alone. Is that possible? Can I import the user and recover user until some time?

Regards,
Sathya

Brian Peasland wrote:
> 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
> >
>
> One option is to restore the cold backup to another database server.
> Then use export to create a dump file containing just the user in
> question. Take the dump file to your main database server and import its
> contents there.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Fri Jul 21 2006 - 00:04:27 CDT