| Author |
Message |
Sathya
*nix forums beginner
Joined: 20 Jul 2006
Posts: 2
|
 Posted: Thu Jul 20, 2006 6:24 am Post subject:
Recovering a user
|
|
|
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 |
|
| Back to top |
|
 |
Guitarator
*nix forums beginner
Joined: 16 Jun 2006
Posts: 5
|
| Posted: Thu Jul 20, 2006 7:29 am Post subject:
Re: Recovering a user
|
|
|
Hi
Why from cold backup, why not from dump and exp/imp utility ?
Regards
Denis
Sathya wrote:
| Quote: | 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 |
|
|
| Back to top |
|
|
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Thu Jul 20, 2006 8:15 am Post subject:
Re: Recovering a user
|
|
|
Sathya wrote:
| Quote: | 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 |
|
| Back to top |
|
|
Brian Peasland
*nix forums Guru
Joined: 04 Apr 2006
Posts: 301
|
| Posted: Thu Jul 20, 2006 1:32 pm Post subject:
Re: Recovering a user
|
|
|
Sathya wrote:
| Quote: | 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@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 |
|
| Back to top |
|
|
Sathya
*nix forums beginner
Joined: 20 Jul 2006
Posts: 2
|
| Posted: Fri Jul 21, 2006 5:04 am Post subject:
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:
| Quote: | 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@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 |
|
|
| Back to top |
|
|
Jerome Vitalis
*nix forums addict
Joined: 03 Jun 2005
Posts: 58
|
| Posted: Fri Jul 21, 2006 9:39 am Post subject:
Re: Recovering a user
|
|
|
Sathya wrote:
| Quote: | I have one more query how do i recover only 1 user. I have a hot
backup for each user.
|
I assume you meant an export dump file. That's not a hot backup.
| Quote: | My archive logs are enabled. Let's say I dropped
a user. I want to recover that user alone. Is that possible?
|
Yes, but you can't use your dump file for that purpose. You'd have to
restore and recover the related tablespaces in an auxiliary database
from your cold backup and archived logs. Then you could exp/imp your
user schema.
| Quote: | Can I import the user and recover user until some time?
|
No. Imp loads your data at a logical level. Recover works at a physical
one. If you imported this user schema, the database state would be
totally new, different from its state at the time of the export. Oracle
wouldn't be able to recover the changes you had made after the export. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
