Home » RDBMS Server » Server Utilities » how get 12c backup (oracle 12c)
how get 12c backup [message #654714] Thu, 11 August 2016 04:43 Go to next message
mfahimaamirgmailcom
Messages: 50
Registered: May 2011
Location: pakistan
Member
Hi to all master
sir
i am now in oracle 12c
i install 12c that work fine at sever and client side with out any error

how i take backup all table with view and trigger
please guide me step by step
thank you in advance
regard
Re: how get 12c backup [message #654715 is a reply to message #654714] Thu, 11 August 2016 04:47 Go to previous messageGo to next message
John Watson
Messages: 7178
Registered: January 2010
Location: Global Village
Senior Member
You need to study use of the RMAN Recovery Manager. It is too broad a topic to learn by posting questions in a forum. Start here,
http://docs.oracle.com/database/121/BRADV/toc.htm
read it. All of it! I did, a long time ago.

Re: how get 12c backup [message #654729 is a reply to message #654714] Thu, 11 August 2016 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65249
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... and read it step by step.

Re: how get 12c backup [message #654738 is a reply to message #654729] Thu, 11 August 2016 07:46 Go to previous messageGo to next message
Littlefoot
Messages: 21265
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Reading what you said ("backup tables, views, triggers"), there's yet another option: you could export the schema (so you'd have to read Utilities Guide, Export Data Pump). Note that it is NOT backup, but in certain situations might help.
Re: how get 12c backup [message #654771 is a reply to message #654738] Fri, 12 August 2016 03:56 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
As Litlefoot said, although export is not a backup, as such, it can certainly do what you require.
Re: how get 12c backup [message #654772 is a reply to message #654714] Fri, 12 August 2016 04:19 Go to previous message
John Watson
Messages: 7178
Registered: January 2010
Location: Global Village
Senior Member
A Data Pump export might indeed be what you need rather than a backup. However,if you are just beginning your Oracle Journey you could use the old exp utility, http://docs.oracle.com/database/121/SUTIL/GUID-901CBBE0-65FB-439E-942D-F2038C18BCD2.htm#SUTIL3634 It is much easier to use than Data Pump and does not require any particular privileges. If you use it, do remember that it is officially deprecated and you really shouldn't be using it long term.
Previous Topic: Copy database to another computer
Next Topic: Import with EXCLUDE syntax was not working
Goto Forum:
  


Current Time: Tue Dec 12 02:43:56 CST 2017

Total time taken to generate the page: 0.02636 seconds