All geek questions in one place

Database export to oracle

I have an oracle database in Windows Server 2003. How can I export it with all the data and put it on another Windows server?

+3
source share
3 answers

Use RMAN for a full backup. Then restore it to the new server.

See Cloning Using the RMAN Article

+3
source

You can use Oracle Data Pump to export and import the database. Quote from the documentation:

Oracle Data Pump is a feature of Oracle Database 11g Release 2 that allows you to move massive data and metadata between Oracle databases very quickly.

:

  • expdp
  • Oracle Windows
  • impdp

: Oracle Data Pump. .

+2

( O/S) Oracle, - . , , , .

  • . " sysdba" SQLPlus "shutdown immediately". Windows . OracleServicesid, "sid" - . , . .
  • . "oradata" - Oracle, sid. ( oradata. , SID .) Admin sid, % ORACLE_HOME%/database. DBCA , Oracle.
  • , , . (. , (, ), . , .) (initSID.ora) (spfileSID.ora) % ORACLE_HOME%/database.

  • oradim. (: oradim - Oracle, Windows , .) :

    oradim -new -sid yourdbsid -startmode automatic

  • SQLPlus, .

, . . Oracle, . (. .) O/S, , .

It is also possible to duplicate the database using RMAN. Google the words "clone an oracle database using rman" to get some good sites on how to do this with this tool. If you are not using RMAN yet, the procedure described above is likely to be a way.

0
source

Source: https://habr.com/ru/post/1739290/

More articles:


All Articles