oracle的备份和恢复.doc

第一章 Oracle的备份与恢复 Oracle Agent的安装与载卸 Oracle Agent的安装 Note：安装Orace Agent前，请确认NetBackup Client for UNIX已经正确安装在Oracle服务器上，Windows 机器的数据库agent已随client一起安装，且无需进行oracle link的步骤。 将安装CD放入光驱，并运行安装脚本 # mount /cdrom # cd /cdrom # ./install VERITAS Installation Script Copyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved. Installation Options 1 NetBackup Add-On Product Software 2 NetBackup Database Agent Software q To quit from this script Choose an option [default: q]: 2 ********** There are two ways to install database agent software. 1. Remote Installation: Loads the software on a master server with the intent of pushing database software out to affected clients. 2. Local Installation: Loads and installs the software only to this local machine. ********** Do you want to do a local installation? (y/n) [n] y ********** NetBackup Database Agent Installation Choose the Database Agents you wish to install one at a time or select Install All Database Agents. 1) NetBackup for DB2 2) NetBackup for Database Archiver 3) NetBackup for Informix 4) NetBackup for Lotus Notes 5) NetBackup for Oracle 6) NetBackup for SAP 7) NetBackup for Sybase 8) Install All Database Agents q) Done Selecting Agents x) Exit from this Script Choose an option: 5 Choose an option: q You have chosen to install these Database Agents: NetBackup for Oracle Is this list correct? (y/n) [y] 链接库文件（windows不用作，自动会做好。） Note：在做此项操作前必须使用oracle用户。 $cd /usr/openv/netbackup/bin $./oracle_link Windows下，服务下面有个netbackup client service服务，有一个log on属性，要改成administrator。涉及到权限的问题。 oracle数据库自动归档模式的设置 检查数据库是否处于ARCHIVELOG方式 SQLconnect “/ as sysdba” SQLarchive log list 若为archivelog模式，输出如下: Database log mode Archive Mode Automatic archival Enabled Archive destination /backup/archivelog Oldest online log sequencee 2131 Next log sequence to archive 2133 Current log