OraFAQ Forum: Server Utilities » how get 12c backup

Home » RDBMS Server » Server Utilities » how get 12c backup (oracle 12c)

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

how get 12c backup [message #654714]

Thu, 11 August 2016 04:43

mfahimaamirgmailcom
Messages: 64
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

Report message to a moderator

Re: how get 12c backup [message #654715 is a reply to message #654714]

Thu, 11 August 2016 04:47

John Watson
Messages: 8979
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.

Report message to a moderator

Re: how get 12c backup [message #654729 is a reply to message #654714]

Thu, 11 August 2016 06:22

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... and read it step by step.

Report message to a moderator

Re: how get 12c backup [message #654738 is a reply to message #654729]

Thu, 11 August 2016 07:46

Littlefoot
Messages: 21825
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.

Report message to a moderator

Re: how get 12c backup [message #654771 is a reply to message #654738]

Fri, 12 August 2016 03:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

As Litlefoot said, although export is not a backup, as such, it can certainly do what you require.

Report message to a moderator

Re: how get 12c backup [message #654772 is a reply to message #654714]

Fri, 12 August 2016 04:19

John Watson
Messages: 8979
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.

Report message to a moderator

Previous Topic:	Copy database to another computer
Next Topic:	Import with EXCLUDE syntax was not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 17 20:20:18 CDT 2025