Lounge - Backup Procedure in Oracle 10g--- Very Urgent

Asked By Lalitha Kumaran on 21-Jun-08 06:39 AM

Hi Guys,

          I am having 2 GB data in my oracle server(online server,server1).one more server is having for backup purpose(server2).I need to take backup from server 1 data and put into server2. can any one of u tell me the procedure to take Back Up?

here is what we do - Jason S replied to Lalitha Kumaran on 21-Jun-08 09:56 AM

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[restore_backups]    ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[restorebackups]

AS

execute csp_Kill_All 'Market'

RESTORE DATABASE Market
FROM DISK = 'd:\LogShip\Market_data.bak'
WITH
REPLACE,
MOVE 'Market_Data' TO 'g:\sqldata\Market_data.mdf',
MOVE 'Market_log' TO 'd:\sqllog\Market_log.ldf'

WAITFOR DELAY '00:00:05'

, 'User'








DOOD. He Said ORACLE. - Peter Bromberg replied to Jason S on 21-Jun-08 08:00 PM

NOT Sql Server. Read the question first.

Oracle 10g backup - sundar k replied to Lalitha Kumaran on 22-Jun-08 11:32 AM

I think the oracle site will be the best reference for this,

Backup Strategy and Procedures

http://download.oracle.com/docs/cd/B14099_01/core.1012/b13995/br_bkp.htm#i1010411

I hope you can find lot of good links when you google for it!

Backup Procedure in Oracle 10g - Swapnil Salunke replied to Lalitha Kumaran on 22-Jun-08 02:33 PM
Hello Lalitha

For backing up Oracle Database there are simple steps to be performed
This link contains the information reagrding how to backup oracle database
http://www.databasedesign-resource.com/oracle-backup.html

To Restore Oracle Database you can get information from here

http://www.mylivevault.com/webhelp/TSK/rs_oracle.asp

Hope this could help you out
Happy Coding takecare