Home » RDBMS Server » Backup & Recovery » Backing up 12C tables / data
Backing up 12C tables / data [message #621615] Thu, 14 August 2014 20:33 Go to next message
oragami
Messages: 16
Registered: July 2014
Junior Member
Hi -- I am running windows server 2012 and would like to backup my users tables and record data. Is there a folder that I need to backup in case I need to recover it at some point?
I probably can create a schedule to run the backup (like with robo copy, etc) but just need to know exact files/folders to backup in case of a disaster, etc.

Thanks much for any help on this!
Re: Backing up 12C tables / data [message #621617 is a reply to message #621615] Thu, 14 August 2014 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
oragami wrote on Thu, 14 August 2014 18:33
Hi -- I am running windows server 2012 and would like to backup my users tables and record data. Is there a folder that I need to backup in case I need to recover it at some point?
I probably can create a schedule to run the backup (like with robo copy, etc) but just need to know exact files/folders to backup in case of a disaster, etc.

Thanks much for any help on this!


to maintain data integrity, you can't use OS file copies
You need to use either expdp or RMAN
(or you can write your own tool to dump the data as pure character data to OS file)
Re: Backing up 12C tables / data [message #621650 is a reply to message #621615] Fri, 15 August 2014 07:57 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
The physical structure of an Oracle database is far more complex than your question assumes. You can't back up a table by simply copying a file or a folder. Hence, BlackSwan's comment about using the proper Oracle-supplied utilities.
Re: Backing up 12C tables / data [message #622151 is a reply to message #621650] Thu, 21 August 2014 09:38 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
There is a document called "Oracle Database 2 Day DBA" . I think it is a great beginner document.

http://docs.oracle.com/database/121/nav/portal_booklist.htm

Check it out....look at http://docs.oracle.com/database/121/ADMQS/backrest.htm#i1004902 particularlly.

After looking through it let us know if you have specific questions or need more clarification.

Regards
Tim

Previous Topic: Number of Archive Logs to retain
Next Topic: rman backup
Goto Forum:
  


Current Time: Thu Mar 28 16:26:45 CDT 2024