- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- RMAN - simple recover test
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
тАО05-13-2006 03:38 PM
тАО05-13-2006 03:38 PM
I'm just looking to perform a simple recovery test for RMAN. I'm taking online backups right now and just to prove the tape is working correctly I'd simply like to recover an archive log to a different location on the server. I don't want to take the db down or cause any problems to my running system so I'm looking for a simple way to prove the backup is working (and yes, I know full backup tests are essential :) ). Thanks in advance.
Jeff
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2006 06:34 PM
тАО05-13-2006 06:34 PM
SolutionFor real proof, you need to restore the entire database, possibly to another server and see if you can bring it up.
You don't need a very fast server for this, it does not matter if the box takes 2 hours to start the database.
Its quite important to see that you can actually connect with sqlplus and pull up records.
Suggestion:
copy /etc/oratab and the oracle binaries to a test system.
Restore the database.
Adjust the init.ora to anything that is different, like the path to the data.
Start the database.
Do some simple lookup tests.
Shmuel
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
тАО05-14-2006 06:32 PM
тАО05-14-2006 06:32 PM
Re: RMAN - simple recover test
Before you do the restore the db to an other node,
obtain the following from your existing
db.
Alter database backup controlfile to trace
in the udump directory you will find a blueprint of your controlfile with path and name of datafiles. (Very handy)
If you didn't configure rman to change the
datafile path you can do it yourself.
Bring oracle to a mounted state and
rename the datafiles accordingly on your
new node.
Once you bring it up ,see if you can do an full export as well. (Say you wanted to restore some vital tables back to the original db)
Or you can create a db link between the clone and the existing and pump data's accross based on simple or complex query.
It is good to know you master all that.
A restore is one thing, to apply the correct
recover scenario is another.
Good luck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2006 02:12 AM
тАО05-15-2006 02:12 AM
Re: RMAN - simple recover test
Thanks for the great suggestions. However, I'm also very sure there is a way to restore a backed up and deleted archive log to the file system. Anyone know that command?
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2006 07:40 PM
тАО05-16-2006 07:40 PM
Re: RMAN - simple recover test
but they are in sequence. So you
cannot skip one.
You can also recover up to a certain point,
either time based or scn based.
It will then prompt you for the archive file to provide in sequence.
You find the commands in the recover clause
of the manual.
To restore a single archive log (This can be a redo log as well by the way):
Thus:
sqlplus> alter database recover logfile 'arch.nr' ;
To to this in Rman you will have to make a
restore script. To place the archive file
from tape to disk and apply the recover command.
Hope this gets you cooking :)