Doubt on RMAN Recovery

Printable View

05-10-2003, 11:42 AM
coolboy

Doubt on RMAN Recovery

Hi,

I am very new to oracle.

Currently I am learning RMAN.

My doubt is

I took two backups using the following commands
run
{
allocate channel c1 type disk;
backup database format='c:\full\%d_%u';
}

Another one
run
{
allocate channel c1 type disk;
backup tablespace users format='d:\part|%d_%u';
}

Now just imagine I have some problem with my users datafile. So that I want to recover the data from the backup file called 'd:\part\ '

But I have gone through RMAN document and found out the following

run

{
allocate channel c1 type dis;
recover tablespace users;
}

My problem is How can I tell oracle to recover the data from the specified backup ie) d:\part\

Cool
05-10-2003, 12:26 PM
marist89

It knows what is the most current backup.
05-10-2003, 01:09 PM
coolboy

Hi jeff,

Sorry to disturb u again

suppose sunday I took one backup.

Again wednesday I took another one.

Later I came to know I had some problem with wednesday backup

In this case I want to restore it from sunday backup.

How is it possible with RMAN?

Cool
05-10-2003, 02:38 PM
adewri

Then tell RMAN to delete the WED backupset from the catalog so that it can restore from SUN backup.

RTFM, its all there baby...
05-10-2003, 03:21 PM
coolboy

Hi adweri,

Thanks for ur answer.

RTFM--Do u think from ur childhood u know everything?

Don't insult others feelings.

Cool
05-10-2003, 04:00 PM
pando

Quote:

Originally posted by coolboy
.

RTFM--Do u think from ur childhood u know everything?

And do you think everyone ask in a forum to learn? RTFM would you?
05-10-2003, 04:20 PM
coolboy

Quote:

Originally posted by pando
And do you think everyone ask in a forum to learn? RTFM would you?

Hi pando,

If u don't want do answer for some thread, just ignore it. Or u can reply as "we don't want to answer"

But don't act like a uneducated person

Cool
05-10-2003, 04:23 PM
adewri

Quote:

Originally posted by coolboy
But don't act like a uneducated person

Look who's talking...
05-10-2003, 04:38 PM
coolboy

Quote:

Originally posted by adewri
Look who's talking...

Yes Adewri,

I am(coolboy) the one talking

coolboy=Zero knowledge in backup & recovery
coolboy=Zero knowledge in Performance & Tuning
coolboy=Zero knowledge in Oracle Architecture.

But this coolboy never ever talks like u people. Try to change ur behaviour.

Cool
05-10-2003, 05:27 PM
pando

ZERO Knowledge then RTFM or go to school okE!
05-11-2003, 12:17 AM
akhadar

cooooooolboy.Try to think why they say for RTFM.It only helps u not them.AS u are new to DBA u need to have lot of patience.Its only a forum not a training centre.
05-11-2003, 01:17 AM
coolboy

Hi pando,

Don't talk like a cheap person.
Don't behave like a third-rate person. Yes, before I study RTFM, first u have to join in some school and learn how to behave.

Hi ackthar,

Yes, I accept it. If I study the documentation then only I can improve myself.

But thease people should not use that word. That is my point.

Cool
05-11-2003, 02:26 AM
guru_heaven

RTFM uneducated person
05-11-2003, 04:32 AM
coolboy

Hi guru,

Change ur name as guru_hell.

Don't think that I don't know bad words. But I don't want to use.

I don't want to corrupt this forum

Cool
05-11-2003, 05:18 AM
DaPi

Hey coolboy, suggest you live up to your name and stay cool.
Read this http://www.catb.org/~esr/faqs/smart-questions.html
and then perhaps appologise?
05-11-2003, 05:35 AM
coolboy

Hi dapi,

Thanks for ur link. I know this link before.

Yes, there is way to ask a question. Sametime there is a way to answer also.

My point is if they don't want to answer let them ignore it. Nobody is 100% perfect in any subject.

You want me to apologize? For what? Tell them to applogize?
It a worldly rule all shake their head to the wealthier. Money is more worth than attitutes they think. But in education the more a person knows anything the more mature he becomes and does not stay like kids using unparilimentary words.

But no need. Tell them to change their attitude. That is enough.

Cool
05-11-2003, 06:02 AM
DaPi

Quote:

Originally posted by coolboy
I know this link before.

Quite! But have you read it ALL and understood it?

QUOTE:
There is an ancient and hallowed tradition: if you get a reply that reads "RTFM", the person who sent it thinks you should have Read The ****ing Manual. He is almost certainly right. Go read it.

You shouldn't be offended by this; by hacker standards, he is showing you a rough kind of respect simply by not ignoring you. You should instead thank him for his grandmotherly kindness.
:UNQUOTE

You might not like the F-word - tough! There are those that use it who are kind and helpful. There those that find it offensive who are rude and ungrateful. So, if you don't like the heat, stay out of the kitchen.

(P.S. those **** aren't mine - the forum software censored my post!)
05-11-2003, 06:20 AM
Sweetie

Quote:

Originally posted by coolboy
But no need. Tell them to change their attitude. That is enough.
Cool

Hi

I think you are the one who needs to change attitude. People who have tell you to RTFM have been contributing to this forum for years, I dont think they are the ones corrupting the forum, rather it's you. If you dont like the replies (we see RTFM here quite often) I suggest you to unregister.

Regards
05-11-2003, 09:22 AM
coolboy

Hi Dapi,

This word do u think is kind and helpful.

That means from ur point of view, it is kind.

Can u ask ur father f....father?
Can u ask ur mother f....mother?

As per your point of view it is kind. As per my point of view it should not be used in a common places like forums. May be u can use it in bar with ur parents.

Why should I stay out of the kitchen? As a user it is my rights I can share my views here.

Hi sweetie,

ya, I know these people are contributing for this forum for years. I agree with u...Do u think because they are contributing for this forums for a year, I have to accept their bad words also...No need...

You suggest me to unregister...Nice to hear...It is administrator duty to block me if he finds mistakes on my side.

I agree he is a knowledgeble person....But that does not means I have to accept all his words

Cool
05-11-2003, 10:07 AM
doraemona

Quote:

Originally posted by Sweetie
Hi

I think you are the one who needs to change attitude. People who have tell you to RTFM have been contributing to this forum for years, I dont think they are the ones corrupting the forum, rather it's you. If you dont like the replies (we see RTFM here quite often) I suggest you to unregister.

Regards

Cant be more agree with this
Coolboy as sweetie said we see RTFM very often here, if you cant accept that you might as well unregister for your own sake. Your attitude is very bad for this excellent forum. As Pando said, you think everyone learn their way through asking on a forum? Certainly not. This is not a school.
05-11-2003, 10:43 AM
coolboy

Hi dora,

Because we see this word RTFM often here, we can't say this is correct.

I accept everything as u said. This is excellent forum. They are all very knowledgeble people in Oralce.

My only point is why can't they use RTM instead of RTFM

Cool
05-11-2003, 02:56 PM
marist89

What's wrong with RTFM; Read The Friendly Manual? Why don't you put your energy into learning instead of whining about how you think you should be treated.
05-12-2003, 03:09 AM
coolboy

Hi jeff,

Thanks for your reply.

So today onwards

RTFM means Read the Friendly Manual. Thanks for ur suggestion.

Cool
05-12-2003, 03:17 AM
DaPi

Quote:

Originally posted by coolboy
So today onwards RTFM means Read the Friendly Manual.

. . . et lux erat

(Of course irony might be wasted on some people . . .)
05-12-2003, 03:54 AM
Thomasps

Quote:

Originally posted by coolboy
Hi jeff,

Sorry to disturb u again

suppose sunday I took one backup.

Again wednesday I took another one.

Later I came to know I had some problem with wednesday backup

In this case I want to restore it from sunday backup.

How is it possible with RMAN?

Cool

Coolboy: Your question is really valid. But better don't get into the trap of argument.

Check it out this.

1. First ensure that your backup is taken with a tag every day. example

Backup 1
Backup database format '/ora1/RMANBKUP/full_db_old_%d_%s_%p' tag = 'old';

Backup 2
Backup database format '/ora1/RMANBKUP/full_db_new_%d_%s_%p' tag = 'new';

2. While restoring mention the unique tag to identify the backup set which you are refering. example
RMAN> run
{
sql "alter session set nls_date_format=''MON DD YY HH24:MI:SS''";
sql "alter session set nls_language=american";
set until time 'JULY 19 01 17:58:45';
allocate channel recodb1 type disk;
restore controlfile;
restore database from tag = 'old';
alter database mount;
recover database;
release channel recodb1;
}

Will restore from the 'old' backup and the latest backup is 'new'.

Version tested: oracle 9i (9.2.0)

I think this will solve your doubt.

Note: RTFM is applicable to everybody. .... :D:D:D

Regards

Thomas
05-12-2003, 04:07 AM
SANJAY_G

Quote:

Originally posted by DaPi
Hey coolboy, suggest you live up to your name and stay cool.
Read this http://www.catb.org/~esr/faqs/smart-questions.html
and then perhaps appologise?

That's a good link Dapi. Worth reading.
Thanks.
05-12-2003, 04:26 AM
julian

Quote:

Originally posted by Thomasps

RMAN> run
{
sql "alter session set nls_date_format=''MON DD YY HH24:MI:SS''";
sql "alter session set nls_language=american";
set until time 'JULY 19 01 17:58:45';
allocate channel recodb1 type disk;
restore controlfile;
restore database from tag = 'old';
alter database mount;
recover database;
release channel recodb1;
}

Why do you allocate the channels if you use 9.2.0?
05-12-2003, 04:54 AM
Thomasps

Julian,

Thanks.
True.. No need for the channels.. My concentration was in the original question..

However, If I want to take the backup "not in the default" (rman: show all) location , need to define the channels.

Regards
Thomas
05-12-2003, 05:09 AM
coolboy

Hi Thomasps,

Thanks for your reply!

Ya, I got the point now.

Thanks again

Hi pinky,

Don't spoil this forum. Try to change.

Cool
05-12-2003, 12:39 PM
BJE_DBA

Read The Furnished Manual

Nothing wrong with Furnished or F*****

What is wrong is growing up on gaming forums then coming in here and stating over and over again that everyone here should 'Do this and Do that' to suit your sensibilities.

Respect is a 2-way street, you wont get any this way.

They are telling you to ask 'intelligent questions'.

Meaning before I post I try to read the pertinent manuals and put into my question what I think the answer might be or what I find conflicting about the info in the Furnished Manual.
05-12-2003, 01:17 PM
stmontgo

somebody please shoot this thread, it's giving me a headache
05-12-2003, 01:29 PM
coolboy

Hi all,

I thougt over all what i said and i felt so bad of talking like that to so much senior persons who have contributed to this forum.I ask my sincere apologzies to all who were hurt by my statements in this thread.

Cool
05-12-2003, 01:53 PM
adewri

Welcome aboard!