Re: RMAN problems

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Wed, 30 Apr 2003 16:41:09 +0200
Message-ID: <3eafe08b$0$49115$e4fe514c@news.xs4all.nl>

Mark Nguyen <carmaboy_at_yahoo.com> schreef in berichtnieuws a7a509f7.0304300621.6a22893_at_posting.google.com...
| 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.

Apparently you do not get my point.
With what you do, you restore the db from a backup and roll it forward again completely, ending with a db that looks exactly as it was the moment you begun.
So suppose

01-jan 10:00 backup
02-jan 11:00 drop table
03-jan 12:00 you find you have a problem.

You do: (looked up the syntax in the RMAN manual; the format of the date/time must match the current NLS date format settings).

-  restore database;
-  recover database until time '02-JAN-2003 10:59:59";
-  sql "alter database open resetlogs";

And you will have your database as it was just before the drop table, but lost everything that happened afterwards. Received on Wed Apr 30 2003 - 09:41:09 CDT