Help, Dropped some users and all its objects on a Production Database

[anuragmin]

Hi,

I dropped some users along with all their objects on a production database thinking that I am working on a Test database.

How Do I recover it to the point in time without losing any data.

Just for your information I take a daily Cold backup.

Please Suggest.

Thanks
Anurag

[sambavan]

Is your DB in archive mode? Then recover the cold backup and then apply all those archive logs to the point that you droped the users.

Sam

[kmesser]

1. create a second database using your backups.
2. export the user and all objects
3. import into production instance.