Re: RMAN recovery after total loss

Sander Aiaots wrote:
> Hello everybody,
> I am now trying to understand oracle RMAN backups (using oracle 10g),
> but some things are still unclear to me.
> Backuping seems to be easy, but recovery, for me it seems impossible
> after full crach.
>
> Could someone explain (or maybe there is some manual for that), how
> should I start recovery procedure after full crach on new machine?
> Lets us presume that I have all RMAN backup files, conrolfiles and so on.
> So I install Oracle on new machine, must this installation use same
> database and rman backup location as oldone had?
> Because till now I still do not understand where is that point where new
> oracle instance (to where backup is made) is configured about where
> these rman backup files are located.
>
> With exp/imp it is easy,

It is easy because it is not doing anything like what RMAN is doing. Import is not a recovery mechanism (in the sense of bringing data up to date without loss of committed transactions).

> for destination instance just need to create
> tabelspaces, by names of ole database and do full import. But with RMAN
> I am still not clear, do I need particularly the same machine to
> restore, for example from window to linux restore is impossible?
>
> Hope someone has some answers; I would greatly appreciate that :)
>
> Best regards,
> Sander Aiaots

Go to http://tahiti.oracle.com

Click the 10g documentation link.

Click the Search tab.

Type in the words 'Disaster Recovery'

Click the link to the Backup and Recovery Advanced Users guide.

Have a read of the stuff about recovering a database to a new host.

Regards
HJR Received on Wed Dec 08 2004 - 15:34:33 CST