Simple RMAN backup and recovery. [message #475078] |
Sun, 12 September 2010 16:25 |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi,
Need a basic level guidance.
Eg-
A) Retention policy is 1.
B) Before copying the backup from disk to TAPE. I Perform incremental backup.
Question:
1) How to copy the backup from disk to TAPE in windows xp?
2) After this where I can copy it, like another temp database?
2a) Where else I can store this backup from tape?
3) incase of recovery, can I recover from that alternative locations directly or should I copy back to TAPE and then recover it....
4) instead of these, can we make a backup directly to the tape or the alternative locations (eg- temp database) simultaneously taking backup to disk also?
Thanks is advance
|
|
|
|
Re: Simple RMAN backup and recovery. [message #475081 is a reply to message #475078] |
Sun, 12 September 2010 16:36 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>1) How to copy the backup from disk to TAPE in windows xp?
Use a backup tool. Like net backup. You can directly backup to tape with rman too. Just need to spend more on MML license.
>>2) After this where I can copy it, like another temp database?
Upto you.
>>2a) Where else I can store this backup from tape?
Again, upto your imagination. But I would send it to offsite storage after a certain days of local retention.
>> 3) incase of recovery, can I recover from that alternative locations directly or should I copy back to TAPE and then recover it....
Whatever that works for you faster and reliable.
[Updated on: Sun, 12 September 2010 16:36] Report message to a moderator
|
|
|
Re: Simple RMAN backup and recovery. [message #475225 is a reply to message #475081] |
Mon, 13 September 2010 15:24 |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hey Buddies,
Thanks a lot...
2A) What do you mean by "offsite storage"?
1) Is it another database, which is exclusive for storing backup datas?
2) or can we use Datawarehousing for it (Hope can't be)?
3) what cause the difference in performance between "Connecting tape directly to the target db" and copying through Disk and to the tape?
Thanks
|
|
|
|
|
|
|
|