fabiordeoliveira
ADSM.ORG Member
Hi,
how to restore an Oracle database
how to restore an Oracle database
-
-
Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Rstore Database Oracle
- Thread starter fabiordeoliveira
- Start date
gimlet
ADSM.ORG Member
- Joined
- Apr 25, 2008
- Messages
- 154
- Reaction score
- 4
- Points
- 0
- Location
- St. Louis, Missouri
- Website
- www.lanigera.com
How was the database backed up?
terlisimo
ADSM.ORG Member
Oracle backup/restore with TSM is much like backup/restore with a regular tape device.
You use Oracle's RMAN as you normally would, you just need to set up a data channel to TSM which acts like a tape device. Look at the script that does the backup to see how it's done in your implementation.
Should be something like
Restoring an Oracle DB should be done by an Oracle DB admin... it's so trivial for someone who's never done it before. It depends whether you're restoring the database to latest state or to a point-in-time. Also whether you have any recovery logs left on client system or not.
You use Oracle's RMAN as you normally would, you just need to set up a data channel to TSM which acts like a tape device. Look at the script that does the backup to see how it's done in your implementation.
Should be something like
Code:
[I] allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=c:\TSM\tdpo.opt)';
[/I][I] restore database;[/I]
[I] recover database;[/I]
[I] alter database open;[/I]Restoring an Oracle DB should be done by an Oracle DB admin... it's so trivial for someone who's never done it before. It depends whether you're restoring the database to latest state or to a point-in-time. Also whether you have any recovery logs left on client system or not.
