OraFAQ Forum: Backup & Recovery » RMAN Incrementally Updated Backups

Home » RDBMS Server » Backup & Recovery » RMAN Incrementally Updated Backups (Windows 2008, oracle 10.2.0.4)

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

RMAN Incrementally Updated Backups [message #575141]

Sun, 20 January 2013 02:07

ateeqrahman786
Messages: 52
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?

/forum/fa/10613/0/

/forum/fa/10613/0/

Attachment: Server A.JPG
(Size: 76.67KB, Downloaded 3584 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

John Watson
Messages: 8974
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?

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575459 is a reply to message #575142]

Wed, 23 January 2013 07:54

ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India

Member

i tried the following steps and succeeded. i copied password file,spfile thru OS copy command.

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575462 is a reply to message #575459]

Wed, 23 January 2013 08:08

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

Senior Member
Account Moderator

Yes you can.

Regards
Michel

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575463 is a reply to message #575462]

Wed, 23 January 2013 08:10

ateeqrahman786
Messages: 52
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

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

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

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575482 is a reply to message #575467]

Wed, 23 January 2013 10:02

ateeqrahman786
Messages: 52
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:

Code: [Select all] [Show/ hide]

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

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

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

show parameter archive

Regards
Michel

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575563 is a reply to message #575486]

Thu, 24 January 2013 02:36

ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India

Member

/forum/fa/10619/0/

Attachment: archive.JPG
(Size: 12.76KB, Downloaded 3365 times)

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575564 is a reply to message #575563]

Thu, 24 January 2013 02:49

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

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

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575721 is a reply to message #575564]

Sat, 26 January 2013 01:10

ateeqrahman786
Messages: 52
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,

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575722 is a reply to message #575721]

Sat, 26 January 2013 01:18

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

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

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575724 is a reply to message #575722]

Sat, 26 January 2013 01:23

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

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

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575749 is a reply to message #575724]

Sun, 27 January 2013 00:48

ateeqrahman786
Messages: 52
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.

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575750 is a reply to message #575749]

Sun, 27 January 2013 01:12

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

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

ateeqrahman786
Messages: 52
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.

Report message to a moderator

Re: RMAN Incrementally Updated Backups [message #575862 is a reply to message #575857]

Mon, 28 January 2013 09:44

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

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

Report message to a moderator

Previous Topic:	Recover lost controlfile
Next Topic:	Need help with rman backup script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 03 04:30:22 CDT 2025