Home » RDBMS Server » Backup & Recovery » RMAN Incrementally Updated Backups (Windows 2008, oracle 10.2.0.4)
RMAN Incrementally Updated Backups [message #575141] Sun, 20 January 2013 02:07 Go to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Hi,

I am trying to learn about RMAN Incrementally Updated Backups. I created a database on Server A with the parameters and configurations as shown in image attached. I would like to restore full database on Server B (Test DB).The Server B is exactly same in directory structure as the Server A e.g ('E:\archive\','E:\incr_backup\'). I would like to automate this process so that it updates the Server B on daily basis for R&D purpose. Please guide me. or can i use database clone to update the backup from Server A to Server B?

./fa/10613/0/
  • Attachment: Server A.JPG
    (Size: 76.67KB, Downloaded 351 times)

[Updated on: Sun, 20 January 2013 02:08]

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575142 is a reply to message #575141] Sun, 20 January 2013 02:25 Go to previous messageGo to next message
John Watson
Messages: 4863
Registered: January 2010
Location: Global Village
Senior Member
Think this through. If the target is one machine and the backup is on another, RMAN would have to launch channels on both machines concurrently. That can be done, but how? Is it possible with the incrementally updated backup method?
Re: RMAN Incrementally Updated Backups [message #575459 is a reply to message #575142] Wed, 23 January 2013 07:54 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
i tried the following steps and succeeded. i copied password file,spfile thru OS copy command.

startup nomount;
SET DBID=1290639812
set controlfile autobackup format for device type disk to 'E:\incr_backup\%F';
restore controlfile from autobackup;
alter database mount;
run
{
restore database;
recover database;
alter database open resetlogs;
}
exit;

Everything works fine except last step i.e."alter database open resetlogs;". Its showing missing log.I have to login to sql and type this command to open the database.

Also i have a small doubt.

Suppose i restore and recover entire database on server B and didn't open the database thru resetlog option, can i copy new archives from Server A and apply them on Server B. Please show me the steps if we can do it.
Re: RMAN Incrementally Updated Backups [message #575462 is a reply to message #575459] Wed, 23 January 2013 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can.

Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575463 is a reply to message #575462] Wed, 23 January 2013 08:10 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
could you please show me the steps and how rman identifies new archives in server B.

Thanks,

[Updated on: Wed, 23 January 2013 08:11]

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575467 is a reply to message #575463] Wed, 23 January 2013 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't use RMAN but the RECOVER command in SQL*Plus
2/ Place them in the archive destination directory you define

Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575482 is a reply to message #575467] Wed, 23 January 2013 10:02 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
i copied archives on Server A to the backup location (E:\incr_backup\) using rman script. then i copied that archive file to same location in server B (E:\incr_backup\). When i run the following command in sql:

recover database until cancel using backup controlfile;
, its looking for archives in other location i.e ("E:\archives\") and says file cannot be found.

Please guide..

[Updated on: Wed, 23 January 2013 10:04]

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575486 is a reply to message #575482] Wed, 23 January 2013 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter archive


Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575563 is a reply to message #575486] Thu, 24 January 2013 02:36 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
./fa/10619/0/
  • Attachment: archive.JPG
    (Size: 12.76KB, Downloaded 293 times)
Re: RMAN Incrementally Updated Backups [message #575564 is a reply to message #575563] Thu, 24 January 2013 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please, post text in text mode, inline, but formatted as per How to use [code] tags and make your code easier to read.

Michel Cadot wrote on Wed, 23 January 2013 15:19
1/ Don't use RMAN but the RECOVER command in SQL*Plus
2/ Place them in the archive destination directory you define
...


Not in the original destination, in the target destination as defined in your post which I cannot copy as it is an image, too bad.

Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575721 is a reply to message #575564] Sat, 26 January 2013 01:10 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
1) I placed the backup archives in E:\archive\ (log_archive_dest_1)
2) catalog start with 'E:\archive\';
3) when i backup new archives on server A, its also copying controlfile and spfile (since autobackup on)
4) sql> recover database until cancel;

archives applied.

I still cannot find the new table i created on server A.

Please correct my steps in order.

Best Regards,



Re: RMAN Incrementally Updated Backups [message #575722 is a reply to message #575721] Sat, 26 January 2013 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2) is useless as you don't use RMAN to recover.
3) same thing

you need to copy the ARCHIVED LOGs not the backups of them.

Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575724 is a reply to message #575722] Sat, 26 January 2013 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Actually what you want to do is a standby database which is something that is well-known and easy to do since 20 years.
Have a look at the following video: http://www.youtube.com/watch?v=6uekQo_OZ10

Regards
Michel
Re: RMAN Incrementally Updated Backups [message #575749 is a reply to message #575724] Sun, 27 January 2013 00:48 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Since i am using Oracle 10.2.0.4 standard edition, i cannot use Dataguard. I would like to test as much as possible to make my servers recover ASAP in emergencies/failures without loss of data.

Thats the reason i am testing these scenarios.

I copied the archives into the log_archive_dest_1 location and from sql prompt, i ran the following command.

recover database until cancel using backup controlfile;


Its applying only few archives and asking for completely new archives which are not present in that folder. Anyway i ll keep testing with different approaches.

Thanks for the support.
Re: RMAN Incrementally Updated Backups [message #575750 is a reply to message #575749] Sun, 27 January 2013 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i am using Oracle 10.2.0.4 standard edition, i cannot use Dataguard.


Who has talked about Data Guard here?
You didn't watch the video I pointed you to, did you? Too bad!
If you don't take into account what we post you I wonder why you post the question in a forum.

Regards
Michel

[Updated on: Sun, 27 January 2013 01:12]

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575857 is a reply to message #575750] Mon, 28 January 2013 09:18 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
Thanks Michel,

I was successful in applying all the new archives from Server A to Server B. I will try to create a script to do all these steps.
Re: RMAN Incrementally Updated Backups [message #575862 is a reply to message #575857] Mon, 28 January 2013 09:44 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just convert the Linux script of the video to Windows cmd/bat file and use Windows scheduler (or winat it you prefer).

Regards
Michel
Previous Topic: Recover lost controlfile
Next Topic: Need help with rman backup script
Goto Forum:
  


Current Time: Sun Dec 21 13:12:26 CST 2014

Total time taken to generate the page: 0.08697 seconds