Friday, January 18, 2008

Oracle 10g: Backup & Restore (dump file)


BACKUP



RESTORE


---COMMAND---

Goto Start > Run > Type cmd :

BACKUP:
Command
c:\>exp user/pwd@database file= full=yes
Example
c:\>exp SA/sa@EPERHILI file=C:\ePerhilitanDBBAK\ePerhili13022007.dmp full=yes

RESTORE:
Command
c:\>imp user/pwd@database file= full=yes
Example
c:\>imp SA/sa@EPERHILI file=C:\ePerhili13022007.dmp full=yes

BACKUP(CERTAIN TABLES INCLUDED DATA):
Command

c:\>exp user/pwd@database file= tables=
Example
c:\>exp SA/sa@EPERHILI file=C:\WFLOW.dmp tables=(tblProcess,tblTask,tblModule)

RESTORE(CERTAIN TABLES INCLUDED DATA):
Command
c:\>imp user/pwd@database file= full=yes
Example
c:\>imp SA/sa@EPERHILI file=C:\WFLOW.dmp full=yes

6 comments:

Jaya said...

Hi,
Thanks,
This syntax helped me to restore the .dmp file in oracle 10g
c:\>imp SA/sa@EPERHILI file=C:\ePerhili13022007.dmp full=yes

With regards,
Petrilla

peah @ peps said...

Hi Petrilla,

U'r most welcome. Actually the correct way is by using RMAN. I shall upload the article soon. This is just a shortcut way..

Thanx again for dropping by...

Jaye said...

Thank you so much, that was very helpful.

peah @ peps said...

Hi intransition!

you are most welcome..:)

Anonymous said...

many thanks, this post sorta saved my life ;P
keep up the good work!

peah @ peps said...

ur most welcome tengku ameyahya...