Re: rman recover/restore from backup

From: Ron <support_at_dbainfopower.com>
Date: Mon, 23 Feb 2004 17:07:36 -0800
Message-ID: <j66dnZuYfIrfP6fdRVn-tA@comcast.com>

Hello Howard,

Quite opposite. I do read. You do interpret.

Read *WHAT user said:

>>>>>>>>>>>>>>>>

#1:
"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."

#2:

"This is a development db so if a few things got lost it was no big deal. Somebody should have said (and in so many words they did)"
>>>>>>>>>>>>>>

Anything is not CLEAR? Does this looks like a question on HOW to RECOVER database? Does this say I can TRASH database at will?

This WAS a REAL database, real USERS, real LIFE. Development database considered INTERNAL PRODUCTION.

In a big company you'd have enormous pressure to get it back - both from employees and management.

If DBA can not recover database and decide recreated it - it is back in use IMMEDIATELY. It is not a TOY. Touch it again - and consequences can be dare.

User was very LUCKY to be able to follow your advice that required him to dispose NEW database and start recovery again. In many places doing this he would risk his career.

If you need some data from the old database - Best you can do is to perform TSPIRT on tablespaces you need and move them to the NEW database.

Doing TSPITR you DO NOT IMPACT PRODUCTION DATABASE - this is what is important.

Anything else that requires additional production downtime is RECKLESS!

Hope you can face these facts.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:14a1f766.0402231538.3f4bff5a_at_posting.google.com...
> "Ron" <support_at_dbainfopower.com> wrote in message
news:<uvOdnXDtf7atp6fdRVn-jw_at_comcast.com>...

> > Hello Kapiza,
> >
> >   The situation is that new database is already created and potentially

> > use by users.
>

> "Potentially". Not according to the original poster it wasn't. See:

> this is the problem, Ron. I *read* the original post, and you
> *interpreted* it.
>
> Your point is valid for perhaps other users at other times. But not
> for this poster at this particular time.
>
> See my other post this evening on the same lines. If you will just
> acknowledge that the advice you offered was not actually of relevance
> to the original poster, then I will happily acknowledge that your
> approach has merit for someone who maniacally creates a new database,
> and connects dozens of users to it, whilst still puzzling out how to
> populate said new database with anything actually worth using.
>
> Oh, and if you could apologise for calling me "reckless" in my advice,
> then that would help too.
>
> HJR

Received on Mon Feb 23 2004 - 19:07:36 CST