Home » RDBMS Server » Backup & Recovery » Simple RMAN backup and recovery. (Oracle 9i.2, Windows. )
Simple RMAN backup and recovery. [message #475078] Sun, 12 September 2010 16:25 Go to next message
muktha_22
Messages: 396
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 #475079 is a reply to message #475078] Sun, 12 September 2010 16:30 Go to previous messageGo to next message
BlackSwan
Messages: 22789
Registered: January 2009
Senior Member
1) Refer to Media Management Library documentation
2) see above
3) see above
4) see above

Please post URL to your Media Management Library documentation
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Simple RMAN backup and recovery. [message #475081 is a reply to message #475078] Sun, 12 September 2010 16:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
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 Go to previous messageGo to next message
muktha_22
Messages: 396
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
Re: Simple RMAN backup and recovery. [message #475229 is a reply to message #475225] Mon, 13 September 2010 17:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.businessdictionary.com/definition/offsite-storage.html
Re: Simple RMAN backup and recovery. [message #475386 is a reply to message #475229] Tue, 14 September 2010 14:49 Go to previous messageGo to next message
muktha_22
Messages: 396
Registered: December 2009
Senior Member
Hi Mahesh,

Thanks for you are help.
1) what is the difference in terms of performance and convenience, b/w using the Tape connected directly to the target DB and through the hard disk of backup.
Re: Simple RMAN backup and recovery. [message #475388 is a reply to message #475386] Tue, 14 September 2010 14:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only a benchmark can answer this; so do it and tell us.

Regards
Michel
Re: Simple RMAN backup and recovery. [message #475391 is a reply to message #475386] Tue, 14 September 2010 15:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I cannot answer this in generic terms.
Depends on your *disks* and *tapes*. RMAN handles them differently
and the buffer values are OS dependent.
Oracle documentation has some succinct information.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtunin.htm#CACJCBDB
Re: Simple RMAN backup and recovery. [message #475569 is a reply to message #475391] Wed, 15 September 2010 15:07 Go to previous message
muktha_22
Messages: 396
Registered: December 2009
Senior Member
Great Mahesh...
Previous Topic: How to duplicate from an obsolete backupset?
Next Topic: database switching into noarchivelog mode after restart
Goto Forum:
  


Current Time: Thu Sep 18 15:28:07 CDT 2014

Total time taken to generate the page: 0.11803 seconds