Home » RDBMS Server » Backup & Recovery » connectin via RMAN
connectin via RMAN [message #240515] Fri, 25 May 2007 02:16 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
Hi! I have an Oracle 10.2.0.1.0 on a Linux machine, now I want to take backups using RMAN on another machine that has an Windows XP OS. the problem is when i try to connect from the second machine using RMAN it gives me "insufficient privileges error" but if i try to connect via sqlplus (from the second machine also, the one with Windows OS) it works. I try to connect using system user. Can anyone give me a hint or a link ..... Embarassed ?

Thanks
Re: connecting via RMAN [message #240632 is a reply to message #240515] Fri, 25 May 2007 06:33 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
RMAN can only backup to local disk or, if a media manager is installed, it can only communicate to a local backup client.

PS: You can always mount your Windows drives on the Linux system and do a local backup to it.
Re: connecting via RMAN [message #240724 is a reply to message #240632] Fri, 25 May 2007 10:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Create catalog on your window server and register that database with it.
Re: connecting via RMAN [message #240729 is a reply to message #240724] Fri, 25 May 2007 10:27 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
DreamzZ, you are joking. Right?

Only metadata gets stored in the catalog DB - not the data that's backed-up!
Re: connecting via RMAN [message #240731 is a reply to message #240729] Fri, 25 May 2007 10:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks Frank.
I thought it store the data in catalog.
Thanks again for correction.
Re: connecting via RMAN [message #240733 is a reply to message #240731] Fri, 25 May 2007 10:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I dont know about windows.But
if we have two linux server than we can take backup from one server to other by mounting that server here with these specification.

mount -t nfs -orw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,proto=tcp10.13.1.126:/oradata/exports /media/nfsbackup/
Re: connecting via RMAN [message #240756 is a reply to message #240733] Fri, 25 May 2007 11:59 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
And, if you install SAMBA, you can as easily mount a Windows drive on the Linux system. For example:

$ smbmount //winbox/c /mnt/win
Re: connecting via RMAN [message #240762 is a reply to message #240756] Fri, 25 May 2007 12:17 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks..
Then its mean we can take our rman backup to Network.

[Updated on: Fri, 25 May 2007 12:18]

Report message to a moderator

Previous Topic: RMAN ACCESS ERROR
Next Topic: faq
Goto Forum:
  


Current Time: Tue Nov 26 18:11:18 CST 2024