OraFAQ Forum: Backup & Recovery » RMAN Backup on single machine

Home » RDBMS Server » Backup & Recovery » RMAN Backup on single machine (Oracle EL4)

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

RMAN Backup on single machine [message #399625]

Thu, 23 April 2009 03:09

smunir362
Messages: 310
Registered: September 2007

Senior Member

AOA
I have a single machine having OS oracle EL4 and Oracle 9i software.
I have three database servers running same OS and DBMS software.

I want to backup(Disk based)using RMAN for all my target databases on single machine.

Is it possible. If yes then how can I do that?

Regards
Munir

Report message to a moderator

Re: RMAN Backup on single machine [message #399627 is a reply to message #399625]

Thu, 23 April 2009 03:20

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

Senior Member
Account Moderator

Yes it is possible.
Just execute the rman commands for each database successively. What is your problem in that?

Regards
Michel

[Updated on: Thu, 23 April 2009 03:21]

Report message to a moderator

Re: RMAN Backup on single machine [message #400011 is a reply to message #399627]

Sat, 25 April 2009 00:31

smunir362
Messages: 310
Registered: September 2007

Senior Member

AOA

Dear When I execute rman backup command it save the backup files on the database server where the database running.
I want to save backup files on my centeral machine from where I am running rman commands.
The scenario is that I have Six servers running Oracle database servers and a machine haveing a lot of disks and Tape drive. I want to backup using rman on this single machine (disk base).

Report message to a moderator

Re: RMAN Backup on single machine [message #400014 is a reply to message #400011]

Sat, 25 April 2009 00:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

smunir362 wrote on Fri, 24 April 2009 22:31

AOA

Dear When I execute rman backup command it save the backup files on the database server where the database running.
I want to save backup files on my centeral machine from where I am running rman commands.
The scenario is that I have Six servers running Oracle database servers and a machine haveing a lot of disks and Tape drive. I want to backup using rman on this single machine (disk base).

So proceed to do so.
What is preventing you to do as you desire?
Nobody here is preventing you from doing anything you desire.

Report message to a moderator

Re: RMAN Backup on single machine [message #400223 is a reply to message #400014]

Mon, 27 April 2009 03:52

smunir362
Messages: 310
Registered: September 2007

Senior Member

I want to backup on a single machine for all my database servers
But When I connect RMAN with target database and run BACKUP command it make backup piece on the database server.

Report message to a moderator

Re: RMAN Backup on single machine [message #400234 is a reply to message #400223]

Mon, 27 April 2009 04:10

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

Senior Member
Account Moderator

smunir362 wrote on Mon, 27 April 2009 10:52

I want to backup on a single machine for all my database servers
But When I connect RMAN with target database and run BACKUP command it make backup piece on the database server.

Because you locally logon but you can remotely logon and backup from anywhere.

Regards
Michel

Report message to a moderator

Re: RMAN Backup on single machine [message #400312 is a reply to message #400234]

Mon, 27 April 2009 08:35

smunir362
Messages: 310
Registered: September 2007

Senior Member

Please tell me how can I do that.

1- DB server (hostname = DB1) Linux
2- DB server (hostname = DB2) Linux
3- DB server (hostname = DB3) Linux

4- Backup server (hostname = BackupDB) Linux

I want to save backup of all 1,2,3 database servers on my backup server using RMAN. But RMAN store backup set on target database server.

Report message to a moderator

Re: RMAN Backup on single machine [message #400315 is a reply to message #400312]

Mon, 27 April 2009 09:04

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

Senior Member
Account Moderator

Quote:

But RMAN store backup set on target database server

Michel Cadot wrote on Mon, 27 April 2009 11:10

Because you locally logon but you can remotely logon and backup from anywhere.

Regards
Michel

Report message to a moderator

Re: RMAN Backup on single machine [message #400366 is a reply to message #400315]

Mon, 27 April 2009 21:46

smunir362
Messages: 310
Registered: September 2007

Senior Member

Pls explain step by step how it can be remotely.

Report message to a moderator

Re: RMAN Backup on single machine [message #400375 is a reply to message #400366]

Mon, 27 April 2009 23:33

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

Senior Member
Account Moderator

Post what you currently do.

Regards
Michel

Report message to a moderator

Re: RMAN Backup on single machine [message #400379 is a reply to message #400366]

Mon, 27 April 2009 23:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

smunir362 wrote on Mon, 27 April 2009 19:46

Pls explain step by step how it can be remotely.

Please consider that local & remote are 100% relative & none of us are standing behind you.

We do not share your perspective or point of view.

What is remote for you can be local for others.
Please do not use relative terms; only absolute names.

Report message to a moderator

Re: RMAN Backup on single machine [message #400543 is a reply to message #400379]

Tue, 28 April 2009 12:23

smunir362
Messages: 310
Registered: September 2007

Senior Member

Assume my server machines are in some Room.
I have a PC which have large storage and Tape drive.
I have installed oracle 9i software in my PC. I have RMAN client and tnsnames configured to connect my server machines.
Using my PC,s RMAN client I want to backup the server machines on my local PC.

But RMAN>backup database; behavior is that it store the backup files/piece on server machine NOT ON MY LOCAL PC.

I want to know how can I do that when I connect to target db and run backup command It store backup files on my PC NOT on SERVER MACHINE.

Report message to a moderator

Re: RMAN Backup on single machine [message #400545 is a reply to message #400543]

Tue, 28 April 2009 12:37

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

Senior Member
Account Moderator

>>run backup command It store backup files on my PC NOT on SERVER MACHINE.
You must make the the local filesystem ( say, /backup ) to be available and visible to the database server (nfs mount) and let it be used as destination for rman backupsets.

Report message to a moderator

Re: RMAN Backup on single machine [message #400598 is a reply to message #400545]

Wed, 29 April 2009 01:01

smunir362
Messages: 310
Registered: September 2007

Senior Member

IS NFS the only option.
What about if I m backing up to my PC Tape Drive(TAPE)

Report message to a moderator

Re: RMAN Backup on single machine [message #401834 is a reply to message #400598]

Wed, 06 May 2009 10:48

smunir362
Messages: 310
Registered: September 2007

Senior Member

Please clear my question.
How I will use NFS or Other option If I am taking backup on my TapeDrive configured on my PC.

Report message to a moderator

Previous Topic:	rman waits long time while exiting
Next Topic:	RMAN Channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:19:42 CST 2024