OraFAQ Forum: Backup & Recovery » Backing up 12C tables / data

Home » RDBMS Server » Backup & Recovery » Backing up 12C tables / data

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

Backing up 12C tables / data [message #621615]

Thu, 14 August 2014 20:33

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!

Report message to a moderator

Re: Backing up 12C tables / data [message #621617 is a reply to message #621615]

Thu, 14 August 2014 20:45

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)

Report message to a moderator

Re: Backing up 12C tables / data [message #621650 is a reply to message #621615]

Fri, 15 August 2014 07:57

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.

Report message to a moderator

Re: Backing up 12C tables / data [message #622151 is a reply to message #621650]

Thu, 21 August 2014 09:38

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 21:58:30 CDT 2025