| 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?
-
Attachment: Server A.JPG
(Size: 76.67KB, Downloaded 3528 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: 8960
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 |
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.
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 #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:
recover database until cancel using backup controlfile;
Please guide..
[Updated on: Wed, 23 January 2013 10:04] 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,
|
|
|
|
|
|
|
|
| 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.
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 |
 |
Michel Cadot
Messages: 68716
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
