Home » RDBMS Server » Backup & Recovery » RMAN (ORACLE 10G)
RMAN [message #499766] Wed, 16 March 2011 02:33 Go to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Hai,

Is it Possible to Maintain real Time Backup using RMAN ?

Regards,

Paules
Re: RMAN [message #499768 is a reply to message #499766] Wed, 16 March 2011 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Exactly define what you mean by "real Time Backup".

Regards
Michel
Re: RMAN [message #499818 is a reply to message #499768] Wed, 16 March 2011 05:52 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
We have an 10g Server database. And we are maintaining daily backups at midnight. In case if anything goes wrong in the day time, for example assume there is an Issue at 1:00 PM . We can bring back everything till the previous day using the dump file. But what about the morning session's transactions ?Is there any way to have a backup for each transaction and each operation going on in the Live Database Server ? This is my Question.......Can u help me ?

Regards,
Paules.
Re: RMAN [message #499828 is a reply to message #499818] Wed, 16 March 2011 06:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Backup your acrhivedlogs frequently or propagate your transactions/data to another database ( Streams).
Re: RMAN [message #499839 is a reply to message #499828] Wed, 16 March 2011 07:04 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
How to do it?

Regards,

Paules
Re: RMAN [message #499840 is a reply to message #499839] Wed, 16 March 2011 07:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put a BACKUP ARCHIVELOG ALL in crontab.

Regards
Michel
Re: RMAN [message #499843 is a reply to message #499840] Wed, 16 March 2011 07:37 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Hai,

Will this reduce the speed of processing in Live database ?

Regards,
Paules.
Re: RMAN [message #499847 is a reply to message #499843] Wed, 16 March 2011 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, when you do something it is always at some cost and RMAN is a CPU and IO consumer.

Regards
Michel
Re: RMAN [message #499848 is a reply to message #499847] Wed, 16 March 2011 07:49 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Hai,

Is there any other way to achieve this? I need to maintain the same speed also....


Thanks in Advance.

Regards,
Paules
Re: RMAN [message #499851 is a reply to message #499818] Wed, 16 March 2011 08:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
We can bring back everything till the previous day using the dump file.
This sounds as though you taking a database export. Is that correct? If so, you are operating your database in a very dangerous manner, as an export is NOT a backup.
If I have misunderstood your post, please forgive me, and perhaps describe in greater detail what you are doing for backup.

Re: RMAN [message #499868 is a reply to message #499848] Wed, 16 March 2011 08:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Paules wrote on Wed, 16 March 2011 13:49
Hai,

Is there any other way to achieve this? I need to maintain the same speed also....


Thanks in Advance.

Regards,
Paules


You cannot get the same speed with or without any concurrent workload, it is just a matter of logic.
Now if it will be visible on this concurrent works depend on your current overall workload.
If you have 2 persons in your car, there is no problem to take a hitchhiker. But if you already have 5 persons in your car you may have some problem.

Regards
Michel

Re: RMAN [message #506630 is a reply to message #499868] Tue, 10 May 2011 06:21 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Mr.Michel,

Please tell me how to do this ?

Regards,
Paules
Re: RMAN [message #506635 is a reply to message #506630] Tue, 10 May 2011 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to do what?

Regards
Michel
Re: RMAN [message #506643 is a reply to message #506635] Tue, 10 May 2011 06:50 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
How to Put a BACKUP ARCHIVELOG ALL in crontab ?

Regards,
Paules

Re: RMAN [message #506648 is a reply to message #506643] Tue, 10 May 2011 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you know to do?
Create a shell script?
Create a RMAN script?
Put something in crontab?

Regards
Michel

[Updated on: Tue, 10 May 2011 06:57]

Report message to a moderator

Re: RMAN [message #506651 is a reply to message #506648] Tue, 10 May 2011 07:05 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
We have an 10g Release 10.1.0.3.0 database. We need to maintain a real time backup of it. U gave me the solution as "Put a BACKUP ARCHIVELOG ALL in crontab ". I didn't get where to start? And what are the commands?
Regards,
Paules
Re: RMAN [message #506655 is a reply to message #506651] Tue, 10 May 2011 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Write a Shell script calling RMAN executing this command and put the script in crontab.

Regards
Michel

[Updated on: Tue, 10 May 2011 07:30]

Report message to a moderator

Re: RMAN [message #506661 is a reply to message #506651] Tue, 10 May 2011 07:19 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Why are you only backing up the archivelogs?
WHy not take proper RMAN backups and include archivelog backups in that?
Schedule them at midnight. Ensure you take periodic backups of archive logs generated over the day.
What is your rate of generation of archivelogs?WHats the frequency of logswitch/checkpoint?
You can schedule that accordingly.

Re: RMAN [message #506662 is a reply to message #506661] Tue, 10 May 2011 07:22 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
there is an Issue at 1:00 PM . We can bring back everything till the previous day using the dump file.

Wrong,if you lose any system file,the dump will not have any effect.
You will lose your database. Plan for taking physical backups.Archivelogs alone are not sufficient enough to ensure complete recoverability.

[Updated on: Tue, 10 May 2011 07:29] by Moderator

Report message to a moderator

Re: RMAN [message #506742 is a reply to message #506662] Wed, 11 May 2011 01:58 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Before Creating the Script , I have to create target database and import the dump file in that rite?

Regards,
paules.
Re: RMAN [message #506747 is a reply to message #506742] Wed, 11 May 2011 02:10 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Before you try anything, you need to explain what you are doing at the moment. First question: are you making backups at all? This,

Quote:
import the dump file


and this

Quote:
bring back everything till the previous day using the dump file


sound like export/import, which are not backups, and will not give you a copy of the database that can be maintained. Michel is assuming that you are using RMAN to backup your database. Is that correct?
Re: RMAN [message #506749 is a reply to message #506747] Wed, 11 May 2011 02:23 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
sound like export/import, which are not backups,


@ John
whats Your comment on these ?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#sthref879
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro001.htm#sthref13
Quote:
Logical backups contain logical data (for example, tables or stored procedures) exported from a database with an Oracle export utility and stored in a binary file, for later re-importing into a database using the corresponding Oracle import utility.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#sthref2428


Sriram
Re: RMAN [message #506760 is a reply to message #506749] Wed, 11 May 2011 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Michel is assuming that you are using RMAN to backup your database. Is that correct?

It is the title. Wink

Regards
Michel
Re: RMAN [message #506764 is a reply to message #506749] Wed, 11 May 2011 03:17 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
@ John
whats Your comment on these ?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#sthref879
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro001.htm#sthref13


I've already commented:

http://orafaq.com/node/2392
Re: RMAN [message #506775 is a reply to message #506764] Wed, 11 May 2011 04:44 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
I have commented on this just now and now it is on section "Admin approval"

Sriram
Re: RMAN [message #506779 is a reply to message #506775] Wed, 11 May 2011 05:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I have commented on this just now and now it is on section "Admin approval"
Quoting your comments
>> Database logical objects are exported independently of the files that contain those objects.

Wrong.
Not all objects/rows are always exported.
-----
Edit:
-----
What I meant to say is, by default protected rows are not always exported.
In specific cases, a very special role(EXEMPT ACCESS POLICY) needs to be granted just to do export which will overwrite the
security policies. Just not acceptable in real world.


>> Logical backups can be imported into a different database, even on a different platform. RMAN backups are not portable between databases or platforms.

wrong.
RMAN backups are portable between different platforms.

Exp/Expdp are just a logical way of moving data from one database to another. They are never meant to be backups.
RMAN is meant for backup/recovery. Not really meant to move data
between databases.

Restore/Recover means bringing the database to the same state before it was.
With exp/imp you need to recreate the databases to start with.

>>if it not a Production Environment we Use logical backups only.And In Prd Environment we prefer RMAN Backups.
>>But this does n`t mean that Exp/Imp utilities are not backup utilities.

You may even prefer to get data out of database as csv and use sqlldr to load back.
But it still not a "backup". Just another way to move data.

[Updated on: Wed, 11 May 2011 05:48]

Report message to a moderator

Re: RMAN [message #506789 is a reply to message #506779] Wed, 11 May 2011 05:53 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Mahesh Rajendran wrote on Wed, 11 May 2011 15:50
>>I have commented on this just now and now it is on section "Admin approval"
Quoting your comments
>> Database logical objects are exported independently of the files that contain those objects.

Wrong.
Not all objects/rows are always exported.


>> Logical backups can be imported into a different database, even on a different platform. RMAN backups are not portable between databases or platforms.
wrong.
RMAN backups are portable between different platforms.



http://www.orafaq.com/forum/mv/msg/49057/131217/136607/#msg_131217

RMAN Cross-Platform Transportable Databases Is different.


Oracle document Source:
10g
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241

11g
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/glossary.htm#CBAJJHFI

And along with above Quote:
why don`t you suggest Oracle to [not misguide
people and ]modify the Documents.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#sthref879
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro001.htm#sthref13
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#sthref2428



And As I said My comments/Posts are not meant for blame anyone.


RMAN
EXP/IMP
Those are tools/Utilities provided by oracle to make data backup.
But each has its own style of backup.and one should plan his Backup methods/tools for high availability.


Sriram

[Updated on: Wed, 11 May 2011 06:14] by Moderator

Report message to a moderator

Re: RMAN [message #506797 is a reply to message #506789] Wed, 11 May 2011 05:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

Quote:
http://www.orafaq.com/forum/mv/msg/49057/131217/136607/#msg_131217

I knew you would quoting this.
Did you realize this post is 5+years old?
In this post, I failed to realize OP was using 10g and was under impression he was using 9i.

>>RMAN Cross-Platform Transportable Databases Is different.
How different?
It is an RMAN feature.
With the same endians, RMAN works as an angel.
With different endians, needs a little more work. Thats it.

>>And As I said My comments/Posts are not meant for blame anyone.
Either is ours.

[Updated on: Wed, 11 May 2011 06:05]

Report message to a moderator

Re: RMAN [message #506802 is a reply to message #506797] Wed, 11 May 2011 06:05 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
If you look at the URLs that I have posted were from http://tahiti.oracle.com/ of 10g and 11g Documents.

And I said TTS and "RMAN Cross-Platform Transportable Databases Is different." two are different scenarios.
Quote:
Oracle document Source:
10g
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241

11g
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/glossary.htm#CBAJJHFI

And along with above
Quote:
why don`t you suggest Oracle to [not misguide
people and ]modify the Documents.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/glossary.htm#i997241
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#sthref879
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro001.htm#sthref13
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#sthref2428



Sriram
Re: RMAN [message #506807 is a reply to message #506802] Wed, 11 May 2011 06:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>And I said TTS and "RMAN Cross-Platform Transportable Databases Is different." two are different scenarios.
Now I am lost.
what does tts have to do with this?

And with your repeated useless quotes on same docs/urls, I am completely lost.
Export/Import is a method to move data. Not a real backup.
With that I rest my case.
Re: RMAN [message #506808 is a reply to message #506807] Wed, 11 May 2011 06:20 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
No problem.

Sriram
Re: RMAN [message #506840 is a reply to message #506808] Wed, 11 May 2011 07:49 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear all,

I need RMAN Incremental backup for every second. My Current Rman parameters are ::

RMAN> SHOW ALL;
using target database control file instead of recovery catalog
RMAN configuration parameters are :
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMICATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;# default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\SNCFTEST.ORA'; # default


Please guide me which are the parameters need to change. Also I need the Script.

Regards,
Paules.
Re: RMAN [message #506841 is a reply to message #506808] Wed, 11 May 2011 07:56 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
I think what Mahesh wants to say is from recovery point of view exp/imp are not backups.Because if you have any failure of database exp/imp won't help.Then you need physical backup.
What Sriram is saying is in general.Both are backups.
From recovery point of view exp/imp aka logical backups are useless unless you recreate your database and import all the data but that is not recovery.
otherwise yes exp/imp does contain data.So its a backup of data only usefull in user related errors.
Re: RMAN [message #506843 is a reply to message #506841] Wed, 11 May 2011 07:57 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
I need RMAN Incremental backup for every second

Every second?????

[Updated on: Wed, 11 May 2011 08:00] by Moderator

Report message to a moderator

Re: RMAN [message #506844 is a reply to message #506840] Wed, 11 May 2011 07:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I need RMAN Incremental backup for every second
Really?
Every second?
Are you generating archivelogs every second?
Re: RMAN [message #506845 is a reply to message #506844] Wed, 11 May 2011 08:02 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Yes. Every Second. If not possible, atleast hourly basis(Once in an hour).

Regards,
Paules.
Re: RMAN [message #506846 is a reply to message #506843] Wed, 11 May 2011 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yasir Hashmi wrote on Wed, 11 May 2011 14:57
I need RMAN Incremental backup for every second

Every second?????


Why relaunching this?
This has been clarified.
OP now knows what he wants.

Do not make confusion between CODE and QUOTE tags.
When you quote you use QUOTE tags, not code ones.

Regards
Michel
Re: RMAN [message #506847 is a reply to message #506845] Wed, 11 May 2011 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Paules wrote on Wed, 11 May 2011 15:02
Yes. Every Second. If not possible, atleast hourly basis(Once in an hour).

Regards,
Paules.


I thought you understood you don't need that.
I was wrong.
You didn't understand anything.

Regards
Michel

Re: RMAN [message #506850 is a reply to message #506846] Wed, 11 May 2011 08:07 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
OK
Re: RMAN [message #506858 is a reply to message #506850] Wed, 11 May 2011 08:21 Go to previous messageGo to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I'll have one more try.

Paules,
It sounds as though you want to maintain a copy of the datbase in (near) real time. You can't do that with RMAN. Do you have Enterprise Edition licenses? If so you can do it with Data Guard.


Previous Topic: rman backup fails on windows when using batch file
Next Topic: Restoring RMAN Backup on another server
Goto Forum:
  


Current Time: Fri Mar 29 00:32:20 CDT 2024