Oracle7 Enterprise Backup Utility Administrator's Guide

Library

Product

Contents

Index

APPENDIX B. Command Script Examples

The Sample Database
Examples

This appendix provides sample command scripts for a sample database. These examples are not exhaustive in terms of all the options and specifiers demonstrated, but the usage for each Enterprise Backup Utility command is covered.

The Sample Database

Examples

The Sample Database

The examples in this appendix relate to a database with the following configuration information:

database name

PRODB

ORACLE_SID

PROD

ORACLE_HOME

/opt1/oracle

pfile

/opt1/oracle/prod/dbs/initPROD.ora

The database has the following tablespaces and datafiles in the directory /opt1/oracle/dbs:

Tablespace A

datafiles a1.dbf, a2.dbf, a3.dbf, a4.dbf

Tablespace B

datafiles b1.dbf, b2.dbf, b3.dbf

Examples

Register Command Script Examples

Example

The following command script registers the sample database in the Backup Catalog:

register
db_name = "PRODB"
oracle_sid = "PROD"
oracle_home = "/opt1/oracle"
pfile = "/opt1/oracle/dbs/initPROD.ora"
log = "/opt1/oracle/obackup/log/obkPROD.log"

Example

The following command script updates configuration information about the sample database in the Backup Catalog.

register
db_name = "PRODB"
oracle_sid = "PROD"
oracle_home = "/opt1/oracle"
pfile = "?/dbs/init@.ora"

Backup Command Script Examples

The following command scripts demonstrate various backups of the sample database.

Example

backup offline database without catalog backup

backup offline database 
db_name = "PRODB"
oracle_sid = "PROD"
oracle_home = "/opt1/oracle"
log = "/opt1/oracle/obackup/log/obkPROD.log"
catalog = none

Example

backup online database with archdelete specified

backup online database 
db_name = "PRODB"
oracle_sid = "PROD"
oracle_home = "/opt1/oracle"
archivelog
archdelete
log = "/opt1/oracle/obackup/log/obkPROD.log"

Note: The archivelog specifier is included only for clarity in the example above, as it is the default action and archdelete will not function if the logs are not first backed up.

Example

backup online with three data streams and no archived logs backed up

backup online
archivelog = none
db_name = "PRODB"
oracle_sid = "PROD"
parallel = 3
log = "opt1/oracle/obackup/log/obkPROD.log"

Example

backup online <subset> of Tablespace A and datafiles b1.dbf and b2.dbf, without catalog backup

backup online
db_name = "PRODB"
oracle_sid = "PROD"
dbfile = "?/dbs/b1.dbf","?/dbs/b2.dbf"
tablespace = "A"
log = "/opt1/oracle/obackup/log/obkPROD.log"
catalog = none

Example

backup online <subset> of Tablespace B with multiplexed datafiles

backup online
db_name = "PRODB"
oracle_sid = "PROD"
tablespace = "B"
mux = ("/opt1/oracle/dbs/b1.dbf",  "/opt1/oracle/dbs/b2.dbf",  "/opt1/oracle/dbs/b3.dbf")
log = "opt1/oracle/obackup/log/obkPROD.log"

Example

Catalog-only backup with buffer size of 256 database blocks

backup catalog
log = "/opt1/oracle/obackup/log/catback.log"
buffer_size = 256

Example

Backup of catalog and archived redo logs only

backup online
db_name = "PRODB"
oracle_sid = "PROD"
archivelog
catalog

Restore Command Script Examples

The following command scripts demonstrate various restores of the sample database.

Example

restore database consistent with four tape devices available and archived log files also specified

restore database consistent
db_name = "PRODB"
oracle_sid = "PROD"
archivelog
start_lsn = 41
parallel = 4
log = "/opt1/oracle/obackup/log/obkPROD.log"

Example

restore database consistent to with two tape devices available and recover to current point in time

restore database  consistent
db_name = "PRODB"
oracle_sid = "PROD"
to = "01/01/1995 14:01"
parallel = 2
archivelog
start_lsn = 12
log = "/opt1/oracle/obackup/log/obkPROD.log"
recover

Example

restore database and recover to 12:15 on 9/30/96

restore database  
db_name = "PRODB"
oracle_sid = "PROD"
log = "/opt1/oracle/obackup/log/obkPROD.log"
recover = "09/30/96 12:15:00"

Example

restore database to with DISK_IO_SIZE of 64 database blocks

restore database 
db_name = "PRODB"
oracle_sid = "PROD"
to = "01/01/1995 14:01"
log = "/opt1/oracle/obackup/log/obkPROD.log"
disk_io_size = 64

Example

restore <subset> of Tablespace B with remapping of datafile b1.dbf

restore
db_name = "PRODB"
oracle_sid = "PROD"
tablespace = "B"
remap = "?/dbs/b1.dbf" TO "?/dbs/b4.dbf"
log = "/opt1/oracle/obackup/log/obkPROD.log"

Note: ALTER DATABASE RENAME DATAFILE must be performed following this restore.

Example

restore <subset> to with two tape devices available

restore
db_name = "PRODB"
oracle_sid = "PROD"
dbfile = "?/dbs/b1.dbf","?/dbs/b2.dbf"
tablespace = "A"
to = "05/26/1995 07:00"
parallel = 2
log = "/opt1/oracle/obackup/log/obkPROD.log"

Example

Restore of catalog with buffer size of 128 database blocks

restore catalog = "ebucat"
buffer_size = 128
log = "/opt1/oracle/obackup/log/backcat.log"

Example

Restore of catalog to new catalog database

restore catalog = "ebucat"
as = "newcat"
log = "/opt1/oracle/obackup/log/backcat.log"

Example

Restore of catalog to 9/20/96, in a new database

restore catalog = "ebucat"
to = "09/20/96"
as = "newcat"
log = "/opt1/oracle/obackup/log/backcat.log"

Note: Oracle Corporation recommends restoring the catalog to a new database if you restore it to a previous point in time.

Prev Next

Library

Product

Contents

Index