OraFAQ Forum: Backup & Recovery » rman

Home » RDBMS Server » Backup & Recovery » rman (oracle 10g,solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman [message #490347]

Mon, 24 January 2011 04:17

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

Good evening to all

I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am

other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm

if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)

if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)

I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)

Please give steps

Thanks

Report message to a moderator

Re: rman [message #490350 is a reply to message #490347]

Mon, 24 January 2011 04:33

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I don't understand your problem: rman should work it all out for you. Within a run block, set your UNTIL TIME to the time you want, then restore and recover.
What are you actually doing? Presumably something different?

Report message to a moderator

Re: rman [message #490351 is a reply to message #490350]

Mon, 24 January 2011 04:39

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

Thanks john
i tried that , is steps what i am following is correct else can you brief me with steps in scenerio i had mentioned
to recover using 2 backup2 say bkp1(datfiles) and bkp2 (archives)

Report message to a moderator

Re: rman [message #490353 is a reply to message #490351]

Mon, 24 January 2011 04:50

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I've told you what to do, and you have said that you have already done that. If you won't give more detail of what you did and what you want to achive, I don't think anyone can help. Sorry.

Report message to a moderator

Re: rman [message #490359 is a reply to message #490353]

Mon, 24 January 2011 05:03

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

same as mentioned by you in the run block i set UNTIL TIME i set to 8pm and try to restore and recover
first backup of only db files restore without any issue when restoring second backup of archive it gives
error data file (system01.dbf) already exist
in short i want to restore datafiles (which are from backup taken at 10 am) and restore archive (bkup taken at 8 pm)
and apply archive logs to open database from restore/recovery at 8pm state

Thanks

Report message to a moderator

Re: rman [message #490364 is a reply to message #490359]

Mon, 24 January 2011 05:14

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

error:can not create datafile 1
thanks

Report message to a moderator

Re: rman [message #490365 is a reply to message #490359]

Mon, 24 January 2011 05:15

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Look, if you won't give the detail of what you are doing, this is hopeless. Use copy/paste! Show the rman session!
I have no more time for this, I have to catch the Eurostar. Perhaps someone else can help - if you show what you are doing.

Report message to a moderator

Re: rman [message #490368 is a reply to message #490365]

Mon, 24 January 2011 05:21

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

hello john

can you atleast confirm steps i mentioned is correct or i am missing something or not in sequence

i had given as much detail i could ,i also copy paste rman session

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>

allocated channel: c1
channel c1: sid=510 devtype=DISK

allocated channel: c2
channel c2: sid=509 devtype=DISK

allocated channel: c3
channel c3: sid=508 devtype=DISK

Starting restore at 24-JAN-11

creating datafile fno=1 name=/mydata/u01/app/oracle/oradata/proddata/system01.dbf
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/24/2011 12:13:10
ORA-01180: can not create datafile 1
ORA-01110: data file 1: /mydata/u01/app/oracle/oradata/proddata/system01.dbf

Report message to a moderator

Re: rman [message #490371 is a reply to message #490368]

Mon, 24 January 2011 05:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ You don't post the beginning: the command
2/ You don't post the end: the error message does not stop there.

Regards
Michel

Report message to a moderator

Re: rman [message #490372 is a reply to message #490371]

Mon, 24 January 2011 05:35

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

begining i just run the script after running its rman prompt and then this message and in the end no other message this is last line of error message after this message rman prompt
are you expecting rman should give more error message ,if so please let me know some details even if message is not displayed i will try to check if that is causing any problem
thanks

Report message to a moderator

Re: rman [message #490374 is a reply to message #490372]

Mon, 24 January 2011 05:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

begining i just run the script after running its rman prompt

And you don't bother to post the script.

Quote:

are you expecting rman should give more error message

Yes, the reason why it failed. There are ALWAYS something after that.

Regards
Michel

Report message to a moderator

Re: rman [message #490379 is a reply to message #490374]

Mon, 24 January 2011 05:51

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

Ok Michel i was expecting restoring rman backup is standard command or script below is basic script i am using
but i had also tried with options like just restoring without recovering or opening in reset logs and using
SET UNTIL TIME "TO_DATE('define_time','yyyy-mm-dd:hh24:mi:ss')";

./rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 24 11:23:11 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: proddb (DBID=5508233344, not open)

RMAN> catalog start with '/mydata/data' noprompt;

run {
allocate channel c1 device type disk format '/mydata/data';
allocate channel c2 device type disk format '/mydata/data';
allocate channel c3 device type disk format '/mydata/data';
restore database;
recover database ;-- i tried removing this lines also
alter database open resetlogs;-- i tried removing this lines also
release channel c1;
release channel c2;
release channel c3;
}

Report message to a moderator

Re: rman [message #490383 is a reply to message #490379]

Mon, 24 January 2011 05:56

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Post the script you actually executed in your previous post.
2/ Still waiting for what comes after the error message.
3/ Also have a look at alert.log file

Regards
Michel

Report message to a moderator

Re: rman [message #490384 is a reply to message #490383]

Mon, 24 January 2011 06:00

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

there is no other message after the error message i sent in previous post and i executed same script just now again and sent you output screen so its same script and message i will check alert.log and update you

Report message to a moderator

Re: rman [message #490388 is a reply to message #490384]

Mon, 24 January 2011 06:07

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And you did it in interactive (not from a script), and you got the RMAN prompt after the last message?

Regards
Michel

Report message to a moderator

Re: rman [message #490394 is a reply to message #490388]

Mon, 24 January 2011 06:37

bas_vbs
Messages: 27
Registered: January 2011
Location: india

Junior Member

i copied to this block of rman code on rman prompt and yes after last error message i sent i got rman prompt

Report message to a moderator

Re: rman [message #490407 is a reply to message #490394]

Mon, 24 January 2011 09:58

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

In your first post, you said Quote:

I want to restore database upto 8pm time

which is an incomplete recovery, so you must use SET UNTIL TIME. You have said you did that, but the script you posted doesn't. So, what did you do? Please, if you want help, you must do as Michel and I have asked: show what you did! Copy/paste the entire rman session, from beginning to end. Show the logon, everything you do, the output, and the logoff. Do not cut out anything! Until then, it is impossible to offer any advice.

Report message to a moderator

Re: rman [message #490424 is a reply to message #490347]

Mon, 24 January 2011 21:31

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

If bkp2 has only archivelogs you would not be getting a "datafile exists" error. This has nothing to do with whether there's a controlfile included in the backup.

Please present
a. The Restore and Recover command you issued -- *all* of them, in the right sequence
b. The messages that Oracle returned for each set of commands.

Hemant K Chitale

Report message to a moderator

Previous Topic:	rman backup script suggestion
Next Topic:	Rman backup status

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:14:53 CST 2024