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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup Agent for Oracle Server - Online copy ideas

Status
Not open for further replies.

KaJuHe

MIS
Mar 25, 2004
35
FI
This may be a very stupid question indeed but i just want to be 100% sure about this.

Is it possible to do an Oracle ON-LINE backup without using Oracle Archive Logs, we have the licence for ArcServe Backup Agent for Oracle Server but do not use Archive Logs yet, nor are there any plans in the near future?

I always thought that in that case there is no use of ArcServe Backup Agent for Oracle Server for us, but then i was reading in the manual that "Backing up an ON-LINE database: IF you select ARCHIVE LOG, ArcServe and the backup Agent will backup all the archived logs."

This sentence left me a feeling that maybe there is a way of doing an Oracle ON-LINE backup without using Oracle Archive Logs?
 
it's a db concept but not ARCserve function issue. in another word, u can't perform Oracle online backup even with RMAN.
 
To perform any online backup of Oracle the database must be running in ARCHVIELOG mode. Oracle does not allow online backups in NOARCHIVE mode. The reason for this is that you need the archive logs during the restore so that the tablespaces can be recovered.

The Oracle agent give you the option of backing up the tablespaces and archive logs separately.

To backup oracle in NOARCHIVE mode your only option is to perform an offline backup.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top