- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Can Oracle RMAN archive backups be applied to...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2011 11:23 AM
тАО03-09-2011 11:23 AM
Can Oracle RMAN archive backups be applied to a Split Mirror DB Clone?
Our DBAs often would ask us to restore filesystem based backups of oracle archive logs to bing up the cloned database on top of the HW based Split mirror.
My question is -- can't the DBAs just simply peruse of their RMAN archive backups to bring up the cloned database instead of asking us to restore from filesystem backups?
TIA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2011 03:01 PM
тАО03-09-2011 03:01 PM
Re: Can Oracle RMAN archive backups be applied to a Split Mirror DB Clone?
It depends on whether the archive log files are being backed up.
A db restoration is restore the database from rman or other source and then apply archive logs generated since the last cold backup.
Archive log files are large, sequential, and many shops don't back them up or move them regularly to avoid running out of disk space.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2011 11:49 AM
тАО03-21-2011 11:49 AM
Re: Can Oracle RMAN archive backups be applied to a Split Mirror DB Clone?
So, the trick would be for your DBAs to extract the archive logs from the RMAN catalog, instead of just using a regular file recovery from the sys admins...
this is the idea:
RMAN> run {
2> ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
3> restore archivelog sequence XXXXX;
}
Here is a really nice link that explains it all very well, and it would allow your DBAs to recover archive logs into FILE form back onto disk from RMAN.
http://www.schemathings.com/?p=16
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2011 11:55 AM
тАО03-21-2011 11:55 AM
Re: Can Oracle RMAN archive backups be applied to a Split Mirror DB Clone?
It turns out it's a skills set issue.
Some of our DBAs simply do not have that much RMAN skillz.
I brought in HP Business Copy Sol'n for our VLDB backups coz I was pretty sure such solutions along with RMAN are the only platinum solutions for VLDB backups.
Our venerable DBAs however insist that RMAN to tapes is the uber best way and I had that impression it was not possible for a split mirror backup of an Oracle DB to be brought live/current with RMAN archive log backups.
Thanks also for the tip on how to make RMAN archive logs restored "file-like".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-21-2011 01:08 PM
тАО03-21-2011 01:08 PM
Re: Can Oracle RMAN archive backups be applied to a Split Mirror DB Clone?
Re: source split mirror not split mirror, etc. It doesn't much matter, you can always recover the database into a new database name, with all new and different data paths, or new aliases for data paths. Lots and lots of options there.
My guess is that they like using RMAN from tape b/c of it's simplicity (once it's set up), and it is a valid point.