Home » RDBMS Server » Backup & Recovery » Oracle 11g Backup (Oracle 11g , OS windows server 2003)
Oracle 11g Backup [message #608952] Thu, 27 February 2014 07:32 Go to next message
hilsonsimenthy
Messages: 4
Registered: February 2014
Location: KOCHI
Junior Member
I am not able to login to windows server but my oracle application is working fine
Could someone help me show how to take backup of oracle database from the client PC (connected to oracle server) running Windows XP/windows 7.

Re: Oracle 11g Backup [message #608954 is a reply to message #608952] Thu, 27 February 2014 07:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Install an Oracle Home on your PC, and run RMAN from there. The release you install must match, exactly, the release installed on the server.
Re: Oracle 11g Backup [message #608955 is a reply to message #608954] Thu, 27 February 2014 07:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Sorry, I forgot to do the Moderator thing:

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read
Re: Oracle 11g Backup [message #609507 is a reply to message #608955] Fri, 07 March 2014 22:37 Go to previous messageGo to next message
hilsonsimenthy
Messages: 4
Registered: February 2014
Location: KOCHI
Junior Member
Hi John

I am little confused,from where do i get oracle home is it freely available on the net
could you send me the link if possible

Oracle 11g 11.2.0.1.0
Thanks for your great help

Regards
Hilson
Re: Oracle 11g Backup [message #609508 is a reply to message #609507] Fri, 07 March 2014 22:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Re: Oracle 11g Backup [message #609512 is a reply to message #609508] Sat, 08 March 2014 01:18 Go to previous messageGo to next message
hilsonsimenthy
Messages: 4
Registered: February 2014
Location: KOCHI
Junior Member
Hi
Will it work on windows xp
Re: Oracle 11g Backup [message #609513 is a reply to message #609512] Sat, 08 March 2014 01:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hilson, if you work in IT (and particularly if you work with Oracle) you must develop problem solving skills: train yourself to find answers rather than asking others. One obvious approach to this question is to do a test. Download the software, and try to install it. Furthermore, you will get much better response from volunteer forums such as this if you show that you have done some work yourself before asking.
To give you a hint: as you have seen on the link that the Black Swan gave you, the software comes in both 32 bit and 64 bit releases. You will of course have to download whichever release is appropriate for your PC.
Re: Oracle 11g Backup [message #609519 is a reply to message #609513] Sat, 08 March 2014 05:24 Go to previous messageGo to next message
hilsonsimenthy
Messages: 4
Registered: February 2014
Location: KOCHI
Junior Member
Hi john,
I have taken note of your comment which i take it very positively.

we installed oracle home and accessed RMAN

Usually from oracle server we run the following command but from RMAN how do we take the user backup.

EXPDP username/password DIRECTORY=DATA_PUMP_DIR DUMPFILE=D300913.DMP LOGFILE=300913.LOG SCHEMAS=tiger

Re: Oracle 11g Backup [message #609520 is a reply to message #609519] Sat, 08 March 2014 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

RMAN is for a DATABASE backup. It is a physical backup and not a logical one as export is.
So with RMAN you backup physical objects; files, tablespaces, database not schema.

Re: Oracle 11g Backup [message #609521 is a reply to message #609520] Sat, 08 March 2014 06:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Even though you are doing export, not backup, the solution still applies: run expdp on your PC,
c:\users\john>expdp system/oracle@192.168.1.65:1521/orclz tables=scott.dept

Export: Release 12.1.0.1.0 - Production on Sat Mar 8 12:36:59 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Re: Oracle 11g Backup [message #609522 is a reply to message #609519] Sat, 08 March 2014 07:58 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
hilsonsimenthy wrote on Sat, 08 March 2014 05:24
Hi john,
Usually from oracle server we run the following command but from RMAN how do we take the user backup.

EXPDP username/password DIRECTORY=DATA_PUMP_DIR DUMPFILE=D300913.DMP LOGFILE=300913.LOG SCHEMAS=tiger



rman and expdp are two completely different utilities used for two completely different purposes. rman takes a physical backup of the database. Those backups can be used to completely recover your database even in the event of a total, catastrophic loss of the entire database.

expdp exports the data itself, at a given point in time. Those exports can only be used to restore the data from that point in time .. and requires that you have a working, healthy database into which to do the import. Many do not even consider export (exp or expdp) to be a real backup, because it does not recover a broken database.
Previous Topic: restore database
Next Topic: problem in TSPITR
Goto Forum:
  


Current Time: Thu Mar 28 18:08:18 CDT 2024