Oracle 11g Backup [message #608952] |
Thu, 27 February 2014 07:32 |
|
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 |
John Watson
Messages: 8938 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 #609513 is a reply to message #609512] |
Sat, 08 March 2014 01:28 |
John Watson
Messages: 8938 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 #609521 is a reply to message #609520] |
Sat, 08 March 2014 06:39 |
John Watson
Messages: 8938 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 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
hilsonsimenthy wrote on Sat, 08 March 2014 05:24Hi 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.
|
|
|