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