部署BackupExec Oracle Agent分享


BE 9.x support: Oracle 8.0.5, 8i, or 9i, and Oracle Application Server 9i

Instance components:
init.ora  oracleadminorclpfileinit.ora.SID
control file defined in init.ora: control_files=(“D:oracleora92orclcontrol01.ctl” …)
table space  oracleora92orcl*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
        oracleora92binsqlplus.exe
        sqlplus /nolog
        start pfile=d:oracleadminorclpfileinit.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:oracleoradataorclarchive’
        log_archive_format=%t_%s.dbf
        log_archive_start = true
        Check Again;
                shutdown;
                startup;
                archive log list;

        Using Oracle Enterprise Manager Console (9i) :
        https://seer.support.veritas.com/docs/266835.htm
       
How to install the Oracle Agent on the Oracle database server?
        Program FilesVERITASBackup ExecNTAgentsOracle
        Setup.exe check service: Backup Exec Oracle Agent
        Agent Settings: https://seer.support.veritas.com/docs/233356.htm

Debug Oracle Agent:
        -debug parameter: winntsystem32Ntodebug.log
        https://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, OrantDatabase.)

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
https://seer.support.veritas.com/docs/240306.htm

How to enable BE Oracle Agent to connect to Clustered Oracle Databases
https://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
https://seer.support.veritas.com/docs/230890.htm

—-想了解更多的数据库相关异常处理怎么解决关注<计算机技术网(www.ctvol.com)!!>

www.ctvol.com true https://www.ctvol.com/dtteaching/79207.html Article 部署BackupExec Oracle Agent分享

本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。

ctvol管理联系方式QQ:251552304

本文章地址:https://www.ctvol.com/dtteaching/79207.html

(0)
上一篇 2020年4月15日
下一篇 2020年4月15日

精彩推荐