OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN (ORACLE 10G)

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

RMAN [message #499766]

Wed, 16 March 2011 02:33

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

Report message to a moderator

Re: RMAN [message #499768 is a reply to message #499766]

Wed, 16 March 2011 02:41

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

Senior Member
Account Moderator

Exactly define what you mean by "real Time Backup".

Regards
Michel

Report message to a moderator

Re: RMAN [message #499818 is a reply to message #499768]

Wed, 16 March 2011 05:52

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.

Report message to a moderator

Re: RMAN [message #499828 is a reply to message #499818]

Wed, 16 March 2011 06:27

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Backup your acrhivedlogs frequently or propagate your transactions/data to another database ( Streams).

Report message to a moderator

Re: RMAN [message #499839 is a reply to message #499828]

Wed, 16 March 2011 07:04

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

How to do it?

Regards,

Paules

Report message to a moderator

Re: RMAN [message #499840 is a reply to message #499839]

Wed, 16 March 2011 07:08

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

Senior Member
Account Moderator

Put a BACKUP ARCHIVELOG ALL in crontab.

Regards
Michel

Report message to a moderator

Re: RMAN [message #499843 is a reply to message #499840]

Wed, 16 March 2011 07:37

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.

Report message to a moderator

Re: RMAN [message #499847 is a reply to message #499843]

Wed, 16 March 2011 07:42

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

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

Report message to a moderator

Re: RMAN [message #499848 is a reply to message #499847]

Wed, 16 March 2011 07:49

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

Report message to a moderator

Re: RMAN [message #499851 is a reply to message #499818]

Wed, 16 March 2011 08:01

John Watson
Messages: 8968
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.

Report message to a moderator

Re: RMAN [message #499868 is a reply to message #499848]

Wed, 16 March 2011 08:55

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

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

Report message to a moderator

Re: RMAN [message #506630 is a reply to message #499868]

Tue, 10 May 2011 06:21

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

Dear Mr.Michel,

Please tell me how to do this ?

Regards,
Paules

Report message to a moderator

Re: RMAN [message #506635 is a reply to message #506630]

Tue, 10 May 2011 06:38

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

Senior Member
Account Moderator

How to do what?

Regards
Michel

Report message to a moderator

Re: RMAN [message #506643 is a reply to message #506635]

Tue, 10 May 2011 06:50

Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates

Senior Member

How to Put a BACKUP ARCHIVELOG ALL in crontab ?

Regards,
Paules

Report message to a moderator

Re: RMAN [message #506648 is a reply to message #506643]

Tue, 10 May 2011 06:56

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

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

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

Report message to a moderator

Re: RMAN [message #506655 is a reply to message #506651]

Tue, 10 May 2011 07:12

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

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

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.

Report message to a moderator

Re: RMAN [message #506662 is a reply to message #506661]

Tue, 10 May 2011 07:22

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

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.

Report message to a moderator

Re: RMAN [message #506747 is a reply to message #506742]

Wed, 11 May 2011 02:10

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

Report message to a moderator

Re: RMAN [message #506749 is a reply to message #506747]

Wed, 11 May 2011 02:23

ramoradba
Messages: 2457
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

Report message to a moderator

Re: RMAN [message #506760 is a reply to message #506749]

Wed, 11 May 2011 02:59

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

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

Report message to a moderator

Re: RMAN [message #506764 is a reply to message #506749]

Wed, 11 May 2011 03:17

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

Report message to a moderator

Re: RMAN [message #506775 is a reply to message #506764]

Wed, 11 May 2011 04:44

ramoradba
Messages: 2457
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

Report message to a moderator

Re: RMAN [message #506779 is a reply to message #506775]

Wed, 11 May 2011 05:20

Mahesh Rajendran
Messages: 10708
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

ramoradba
Messages: 2457
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

Mahesh Rajendran
Messages: 10708
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

ramoradba
Messages: 2457
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

Report message to a moderator

Re: RMAN [message #506807 is a reply to message #506802]

Wed, 11 May 2011 06:18

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: RMAN [message #506808 is a reply to message #506807]

Wed, 11 May 2011 06:20

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

No problem.

Sriram

Report message to a moderator

Re: RMAN [message #506840 is a reply to message #506808]

Wed, 11 May 2011 07:49

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.

Report message to a moderator

Re: RMAN [message #506841 is a reply to message #506808]

Wed, 11 May 2011 07:56

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.

Report message to a moderator

Re: RMAN [message #506843 is a reply to message #506841]

Wed, 11 May 2011 07:57

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

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: RMAN [message #506845 is a reply to message #506844]

Wed, 11 May 2011 08:02

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.

Report message to a moderator

Re: RMAN [message #506846 is a reply to message #506843]

Wed, 11 May 2011 08:02

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

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

Report message to a moderator

Re: RMAN [message #506847 is a reply to message #506845]

Wed, 11 May 2011 08:03

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

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

Report message to a moderator

Re: RMAN [message #506850 is a reply to message #506846]

Wed, 11 May 2011 08:07

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Quote:

OK

Report message to a moderator

Re: RMAN [message #506858 is a reply to message #506850]

Wed, 11 May 2011 08:21

John Watson
Messages: 8968
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.

Report message to a moderator

Pages (2): [1 2 › »]

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 11:00:08 CDT 2025