tags:

views:

31

answers:

2
Q: 

How to create and restore backups of the Oracle 10g database by using commanline scripts automatically?

I want to automate the periodic backup and restore of the Oracle 10g Database.Please, someone help me immediately. and please note that I want the task to be performed from the command line scripts.

+1  A: 

You can use the Oracle Recovery Manager (aka RMAN) from the command line.

Here is a good link that provides good instruction/tutorial on how to use RMAN and how to setup scripting files in order to do backups easily from the command line.

RC  2010-03-06 19:18:51
A: 

Also a very good kick-starter into RMAN backup/restore: http://www.orafusion.com/art_rman1.htm

Juraj  2010-03-08 12:44:59

related questions

Fast SQL Server 2005 script generation
In Exchange (2003) how do I list the forms used in the public folder tree ?
Can Windows' built-in ZIP compression be scripted?
Set up PowerShell Script for Automatic Execution
Automated script to zip IIS logs?
Windows Mobile - What scripting platforms are available?
Best way to extract data from a FileMaker Pro database in a script?
which language you use for "throw away" programs?
Delete all but the most recent X files in bash
In SQL Server, how do I generate a CREATE TABLE statement for a given table?
Batch file to "Script" a Database
Is it OK to drop sql statistics?
How do I generate scripts that will rebuild my MS SQL Server 2005 database WITH data?
Which scripting language to support in an existing codebase?
quoting System.DirectoryServices.ResultPropertyCollection
Automate adding entries to a wiki
Can I copy files to a Network Place from a script or the command line?
How do you use PowerShell?
How to resolve symbolic links in a shell script
showing a message box from a bash script in linux
Date arithmetic in Unix shell scripts
Common Types of Subversion Hooks
MS-SQL: Drop all tables whose names begin with a certain string
What PHP framework would you choose for a new application and why?
Adding Scripting functionality to .NET applications