OraFAQ Forum: Backup & Recovery » how to take backup

Home » RDBMS Server » Backup & Recovery » how to take backup

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

how to take backup [message #209404]

Thu, 14 December 2006 11:40

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Hi to all,

i am new to oracle DBA. i want to know these details

my server is in wondows

how to take cold backup? hot backup, and rman?

how to take import and exports?

please give solution as soon as possible.

regards,
pavan

Report message to a moderator

Re: how to take backup [message #209407 is a reply to message #209404]

Thu, 14 December 2006 12:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

All are documented here in documentation
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
>>how to take cold backup? hot backup, and rman?
Look into backup and recovery manuals.
>>how to take import and exports?
Look into Utilities manual.
Look into our FAQ section to start with.
http://orafaq.com/faq

Report message to a moderator

Re: how to take backup [message #209409 is a reply to message #209404]

Thu, 14 December 2006 12:18

dba_blr
Messages: 43
Registered: December 2006

Member

Please gather some patience to read the docs. No body can explain you all these in full detail in this forum. It will take pages(may be as many as the Oracle backup recovery guide) to explain.

Report message to a moderator

Re: how to take backup [message #209614 is a reply to message #209404]

Fri, 15 December 2006 21:57

pavan27
Messages: 50
Registered: December 2006
Location: bangalore

Member

Hi Mahesh Rajendran,
how are you.
thaks for link of ebooks,
my self i am a oracle developer. now i am acting as a oracle dba. and i am learning. i am comfortable on linux.
in linux

cold backup we just copy form os level using cp command
in windows where i have to issue copy command. this is my actual question.

thanks and regards,
pavan

Report message to a moderator

Re: how to take backup [message #209640 is a reply to message #209614]

Sat, 16 December 2006 04:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> in windows where i have to issue copy command
Not sure i understand that.
You do the same thing in windows as you did in linux.

Report message to a moderator

Re: how to take backup [message #209673 is a reply to message #209404]

Sat, 16 December 2006 10:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

how to take cold backup? hot backup, and rman?
Cold backup.
When Database operate in NO ARCHIVELOG MODE.
Hot backup
When Database operate in ARCHIVELOG MODE

Two method for backup.
1.USER MANAGED BACKUP
2.RMAN ( RECOVERY MANAGER) (SERVER MANAGED BACKUP)

http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm

how to take import and exports?
IMPORT OR EXPORT IS UTILITIES FOR Transfer ur Data one database to another database.

It is logical backup method.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#g1070082

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#i1009203

in windows where i have to issue copy command
you want like >>>
C:\>copy d:\scott.dmp c:\scopcopy.dmp
1 file(s) copied.

on command prompt.
cmd>help copy <<enter>>

regards
Taj

Report message to a moderator

Previous Topic:	How to disable the recyclebin in Oracle version 10.1?
Next Topic:	Backup database from client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 19:37:28 CDT 2024