BE 9.x support: Oracle 8.0.5, 8i, or 9i, and Oracle Application Server 9i
Instance components：
init.ora \oracle\admin\orcl\pfile\init.ora.SID
control file defined in init.ora: control_files=(“D:\oracle\ora92\orcl\control01.ctl” ...)
table space \oracle\ora92\orcl\*01.dbf
redo log redo01.log,redo02.log,redo03.log
archive log defined in init.ora.SID file
Requirements for Configuring the Oracle Agent:
account=dba
create user USERNAME identified by PASSWORD;
grant dba to USERNAME;
Database Log Mode is set to ARCHIVELOG
Automatic Archival is enabled
oracle\ora92\bin\sqlplus.exe
sqlplus /nolog
start pfile=d:\oracle\admin\orcl\pfile\init.ora.SID
sql>con username/password@instancename as sysdba (con / as sysdba)
Check Archive Mode:
archive log list;
Database Log Mode ARCHIVE LOG
Automatic Archival ENABLED
Change Archive Mode:
shutdown;
startup nomount;
alter database mount exclusive;
alter database archivelog;
alter database open;
Enable Automatic Archival:
Edit the Oracle instance initialization parameter file
#################################
# Archive
#################################
log_archive_dest_1 =’LOCATION=D:\oracle\oradata\orcl\archive’
log_archive_format=%t_%s.dbf
log_archive_start = true
Check Again;
shutdown;
startup;
archive log list;
Using Oracle Enterprise Manager Console (9i) :
http://seer.support.veritas.com/docs/266835.htm
How to install the Oracle Agent on the Oracle database server?
\Program Files\VERITAS\Backup Exec\NT\Agents\Oracle\
Setup.exe check service: Backup Exec Oracle Agent
Agent Settings: http://seer.support.veritas.com/docs/233356.htm
Debug Oracle Agent:
-debug parameter: \winnt\system32\Ntodebug.log
http://seer.support.veritas.com/docs/230456.htm
Why the agent cannot log on to the Oracle database service?
The Oracle database has been shut down.
The Oracle database has not finished starting up.
An invalid oracle account was specified in the agent’s configuration utility.
The Oracle database server has not been installed on the system.
Three Backup Methods:
Backing Up a Closed Database
shutdown the database and backup entire volume Oracle database is located.
Backing Up an Entire Online Database
all tablespaces, control files, and archived logfile
Backing Up Individual Online Tablespaces
special tablespace folders and archived logfile
Three Restore Methods:
Must always select the option Restore Over Existing Files.
Restoring a Closed Oracle Database
shutdown;
Submit the restore job to restore the entire Oracle database.
Restoring an Online Oracle Database
Run two separate restore jobs.
First, restore the database’s Archived Logfiles directory.
Second, restore each of the database’s tablespaces.
the Oracle Agent automatically perform media recovery for the tablespace.
(The system tablespace cannot be restored while the database is online.)
Restoring Individual Tablespaces
(Do not restore individual tablespaces if entire database becomes corrupted.)
sqlplus /nolog
sql>con / as sysdba
shutdown;
startup nomount;
alter database mount exclusive;
Select the tablespaces you want to restore, Restore as normal.
recover;
shutdown and startup the database
Restoring the Database Control File
It is automatically placed in the Oracle datafile directory on your database
server. (By default, \Orant\Database.)
Disaster Recovery
Re-install Windows on the Oracle database server. (into a temporary directory)
Restore the entire contents of the media to the Oracle database server.
After restore completes, reboot your Oracle database server.
Restore your last full closed Oracle database backup and start your database.
Disaster Recovery without full closed backup
Restore the storage media containing all of the Oracle tablespace data files.
sql> recover database using backup controlfile;
sql> alter database open resetlogs;
How to perform a disaster recovery of an Oracle server using the BERA for Oracle
http://seer.support.veritas.com/docs/240306.htm
How to enable BE Oracle Agent to connect to Clustered Oracle Databases
http://seer.support.veritas.com/docs/238222.htm
How to restore and recover an Oracle database to a 'Point in Time' using an on-line backup
http://seer.support.veritas.com/docs/230890.htm