Home » RDBMS Server » Backup & Recovery » Problem in Tking backup (Oracle 8i ,Oracle 9i under windows 200 server)
Problem in Tking backup [message #336770] Mon, 28 July 2008 23:29 Go to next message
jagsysadmin
Messages: 1
Registered: July 2008
Location: Mysore
Junior Member
Hi,

I am newbie to oracle we have two machines running oracle 8i under windows 2000 server and oracle 9i under windows 2000 server.i want to take backup of the database.So Please someone explain me with an example how to take backup using Export and Import utility amd Rman Utility.Please help me.As a precautionary measure i am just taking the backup of whole oradata folder where database is located.Thanking u.

Re: Problem in Tking backup [message #336776 is a reply to message #336770] Mon, 28 July 2008 23:42 Go to previous messageGo to next message
reyazan
Messages: 53
Registered: February 2005
Member
using exp take user level export
select list of user from dba_users
at dos prompt
exp user/pass file=filename log =logfile owner=username consistent=Y ;

rman
at dos
rman catalog rmanuser/pass target username/pass
rman>configure controlfile autobackup on;
rman>configure device type disc;
rman>backup database
Re: Problem in Tking backup [message #336795 is a reply to message #336770] Tue, 29 July 2008 01:10 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://tahiti.oracle.com
Go to your version then "backup and recovery" and "utilities" guide.

Regards
Michel
Previous Topic: How to disable OS interrupts during RMAN operations
Next Topic: Is redo log contain commited or uncommited or both
Goto Forum:
  


Current Time: Fri Nov 22 13:07:48 CST 2024