Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rman recover/restore from backup
Hello Joe,
Thanks for following up.
Hope that (subtracting all flames) you got some good new information on available recovery options and techniques.
Regards,
Ron
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html
"Joe Fischer" <jfischer@__fischerhome__.org> wrote in message
news:k4603019dl0blcsp64q5f5p1gkair41v4q_at_4ax.com...
> On Sat, 14 Feb 2004 23:03:09 GMT, Joe Fischer
> <jfischer@__fischerhome__.org> wrote:
>
> > I have an Oracle Enterprise 9.2 db running on Linux. It does
> >an RMAN level 0 backup weekly and level 1 backups nightly. Recently
> >the data partition failed and the data files, control files, etc are
> >gone. They are not on the tape backups because they were open when
> >the tape backup ran.
> > So I have the last full RMAN backup and the incremetals on a
> >partition that I was able to get to.
> > The basics of the commands are:
> >
> >$ORACLE_HOME/bin/rman TARGET / CMDFILE '/u03/bin/ora_level0.rcv' LOG
> >'/u04/rman/ora_level0.log'
> >
> >and the rman command file has:
> >
> >CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT =
> >'/u04/rman/level_0_%s_%t.bck';
> >BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;
> >
> > After creating a new partition for the data files, I ran dbca
> >to create new database files. I would like to get the users tablespace
> >stuff out of the backups and put it into the new database that was
> >created by dbca.
> > The docos are pretty confusing about all of this. Is there
> >not some way to basically take the .bck files, extract the users
> >tablespace and put it into the existing database? Sort of like what
> >you might do with import?
> > Thanks.
>
> I'm sorry that I created such a fuss with my problem/question.
> After reading through all of the posts, I deleted the new database and
> was able to restore the control files from the RMAN backups and then
> restore/recover everything else. So it looks like all is well, again.
> It was not easy, but it seems to be running.
> Thanks for the suggestions. Also sorry for not being clear on
> what I was trying to do.
> ------
> Joe F.
>
> Remove underscores from e-mail address.
Received on Mon Feb 16 2004 - 01:44:35 CST