| Point in time Recovery! Help [message #53019] |
Fri, 23 August 2002 13:41  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Hi,
Our oracle database is running in archived log mode. We do cold backups every week and export of the database every day. Could someone direct me to documentation which has step by step procedure for point-in-time recovery? If not could you please list the steps? Also I tried to use rman to get to the RMAN prompt, and was unsuccessful. Where do I find this?
Thanks in advance.
|
|
|
|
| Re: Point in time Recovery! Help [message #53030 is a reply to message #53019] |
Sun, 25 August 2002 18:19  |
P
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
1 way to do it
restore the cold backup, but use the current online redo and control file. I am assuming you have pfile seeting corect and arch logs
startup the database in mount mode.
recover database until time 'xxxxx';
(use auto) when prompt comes up
or
recover database until cancel;
keep hitting enter until you recover to where you want
(hint you can cancel check where you are (v$recover_file) and continue
or
recover database until change <scn>;
use auto
then when you are happy... alter database open resetlogs;
(you must use this when performing incomplete recovery)
If you don't have the controlfile and only have a text version then re-create controlfile then use the
recover database until <cancel|time|change> using backup controlfile;
Hope this helps a little
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
