Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle backup with Veritas wihout Agent

Status
Not open for further replies.

crispopa

Programmer
Sep 14, 2003
5
DE
Hi everybody,

is it possible to backup an Oracle (8i) database without having Oracle Agent installed. Currently, we are using export files to have the backup, which means that the system files are not backed up.

Thanks
 
Crispopa,

You do not need Oracle Agent installed to perform a quality backup. The simplest form of a full Oracle backup is to:

1) Perform a clean, well-behaved shutdown of the database (e.g., SHUTDOWN IMMEDIATE).
2) Copy (using your favourite o/s copy utility) all database files (i.e, Control Files, Database Datafile, and On-line Redo Log Files) to a safe location.
3) Restart the database.

Let us know if you have follow-on questions.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[ Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
 

You do not need Oracle agent to do backups, but you do need Veritas client installed (and configured) to do Veritas (or RMAN) backups to tape. [censored]



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Hi,

maybe you get a better answer in the VERITAS: NetBackup Tek-Tips Forum.
To integrate SantaMufasa's suggestions into a Veritas environment you can do following:

1) Put a script in your $netbackup/bin directory called bpstart_notify which performs the shutdown
2) Netbackup copies according to the specifications in your policy. Include all needed filesystems there.
3) Put a script in your $netbackup/bin directory called bpend_notify which performs the restart

The *_notify scripts are called automatically when backup starts or ends, no matter if started via master or client.
The default $netbackup directory is /usr/openv/netbackup (at least on AIX).

Stefan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top