Re: RMAN problems

I appreciate the advice of learning an os backup first, but what I'm trying to get at is if RMAN is reliable or not. A respondant asked me if I was doing a restore and not doing a recovery. Unfortunately, I am doing both...the syntax I use is thus:

run {
allocate channel c0 type disk format 'xxx'; restore database;
recover database;
}

Everything runs perfect without any indiciations of errors. I shall try the point in time recovery, but it doesn't seem logical, unless this is an oracle thing, that you would have to specify a point in time if you wanted the point in time when you took the full hot backup. More importantly, I am using EM to run the full hot backup and you would think that EM could do a full restore. Part of the problem is that this is a 24/7 system and the vendor recommended we use RMAN instead of scripts (which I had implemented but had to remove). So after spending weeks getting scripts to work perfectly, I had to configure RMAN which appears to but does not work. I guess its TAR time.

Thanks for the continued postings, any further insight or opinions are greatly appreciated.

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:<3eaef8a6$0$49101$e4fe514c_at_news.xs4all.nl>...
> Mark Nguyen <carmaboy_at_yahoo.com> schreef in berichtnieuws
> a7a509f7.0304291343.4c349dd2_at_posting.google.com...
> | Oracle Enterprise 8.1.7.0
> | Sun Solaris 5.8 Spark 64-bit
> |
> | Has anyone ever heard of this? After running a restore, the tables
> | that I deleted after the backup does not appear. No errors are return
> | from the backup or restore from RMAN.
> |
> | Sequence of events:
> | -Backup database - hot backup using RMAN
> | -Removed tables
> | -Restore database
> | --TABLE STILL NOT THERE.
> |
> | Fortunately, I am testing this on a developement server. I pray that
> | this is not going to happen when I need to do a restore on my
> | production server. Any advice anyone?
> |
> | TAI
>
> I've not worked with rman (yet) but if you say "restore database" I think
> the db will be restored completely.
> You must restore the database until a timestamp, the timestamp just before
> you dropped the tables.
Received on Wed Apr 30 2003 - 09:21:57 CDT