Home » RDBMS Server » Backup & Recovery » how to take backup
how to take backup [message #209404] Thu, 14 December 2006 11:40 Go to next message
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
Re: how to take backup [message #209407 is a reply to message #209404] Thu, 14 December 2006 12:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: how to take backup [message #209409 is a reply to message #209404] Thu, 14 December 2006 12:18 Go to previous messageGo to next message
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.
Re: how to take backup [message #209614 is a reply to message #209404] Fri, 15 December 2006 21:57 Go to previous messageGo to next message
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
Re: how to take backup [message #209640 is a reply to message #209614] Sat, 16 December 2006 04:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: how to take backup [message #209673 is a reply to message #209404] Sat, 16 December 2006 10:22 Go to previous message
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
Previous Topic: How to disable the recyclebin in Oracle version 10.1?
Next Topic: Backup database from client
Goto Forum:
  


Current Time: Sun Dec 04 18:40:00 CST 2016

Total time taken to generate the page: 0.06595 seconds