Home » RDBMS Server » Backup & Recovery » rman (oracle 10g,solaris)
rman [message #490347] Mon, 24 January 2011 04:17 Go to next message
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
Re: rman [message #490350 is a reply to message #490347] Mon, 24 January 2011 04:33 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: rman [message #490351 is a reply to message #490350] Mon, 24 January 2011 04:39 Go to previous messageGo to next message
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)
Re: rman [message #490353 is a reply to message #490351] Mon, 24 January 2011 04:50 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: rman [message #490359 is a reply to message #490353] Mon, 24 January 2011 05:03 Go to previous messageGo to next message
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
Re: rman [message #490364 is a reply to message #490359] Mon, 24 January 2011 05:14 Go to previous messageGo to next message
bas_vbs
Messages: 27
Registered: January 2011
Location: india
Junior Member
error:can not create datafile 1
thanks
Re: rman [message #490365 is a reply to message #490359] Mon, 24 January 2011 05:15 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: rman [message #490368 is a reply to message #490365] Mon, 24 January 2011 05:21 Go to previous messageGo to next message
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
Re: rman [message #490371 is a reply to message #490368] Mon, 24 January 2011 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman [message #490372 is a reply to message #490371] Mon, 24 January 2011 05:35 Go to previous messageGo to next message
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
Re: rman [message #490374 is a reply to message #490372] Mon, 24 January 2011 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman [message #490379 is a reply to message #490374] Mon, 24 January 2011 05:51 Go to previous messageGo to next message
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;
}

Re: rman [message #490383 is a reply to message #490379] Mon, 24 January 2011 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: rman [message #490384 is a reply to message #490383] Mon, 24 January 2011 06:00 Go to previous messageGo to next message
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
Re: rman [message #490388 is a reply to message #490384] Mon, 24 January 2011 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman [message #490394 is a reply to message #490388] Mon, 24 January 2011 06:37 Go to previous messageGo to next message
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
Re: rman [message #490407 is a reply to message #490394] Mon, 24 January 2011 09:58 Go to previous messageGo to next message
John Watson
Messages: 8922
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.

Re: rman [message #490424 is a reply to message #490347] Mon, 24 January 2011 21:31 Go to previous message
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
Previous Topic: rman backup script suggestion
Next Topic: Rman backup status
Goto Forum:
  


Current Time: Fri Mar 29 09:25:53 CDT 2024