Oracle7 Getting Started for Windows NT

Backing Up and Recovering Database Files

Backing Up Database Files
Backing Up Files with OCOPY
Recovering Files with OCOPY

Backing Up Database Files

Use the following tools to perform database file backup:

Tool Description To Use this Tool, Refer to...
Oracle Enterprise Manager Database Application Tools

The Oracle Enterprise Manager Database Application Tools include a Backup Manager. The Backup Manager enables users to perform database backups and create backup scripts guided by a backup wizard. The Backup Manager also enables users to administer redo logs and online tablespace backups.

Oracle Enterprise Manager Administrator's Guide for instructions on using this tool.

NT Backup Manager

A Windows NT tool that enables you to perform database backups to a tape drive.

Your Windows NT documentation.

OCOPY

An Oracle tool that enables you to perform local backups of database files.

The section "Backing Up Files with OCOPY" in this chapter.

Note: Before using these tools, Oracle Corporation recommends that you refer to the Oracle7 Server Administrator's Guide for a detailed discussion of database backup and recovery.

Backing Up Files with OCOPY

Use OCOPY for both open and closed database file backups of the following file types:

File Description
File Allocation Table (FAT) or NT File System (NTFS) files

FAT or NTFS files you want to back up.

Logical raw files

A logical drive (accessed with the direct I/O) identified by the name:

\\.\x:

Where x: is a hard drive partition letter, floppy disk drive, or CD-ROM drive.

Physical raw files

A physical hard drive (accessed with direct I/O) identified by a device name of the form:

\\.\physicaldriveN

Where N is 0, 1, 2, and so on, representing each of the physical drives in the system.

This table describes the two copy modes in which to use OCOPY:

Copy Mode OCOPY is used to...
Hard disk

Copy open files to a new name and location on a hard disk where you can use an archive utility to back them up.

Multiple diskettes

Back up large open files directly to multiple diskettes.

This table describes the syntax to use when backing up all file types to hard disk or multiple diskettes.

Copy Mode File Type Syntax
Hard disk

FAT or NTFS files

C:\>OCOPYnn old_file new_file

Logical raw

C:\>OCOPYnn \\.\C: new_file

Physical raw

C:\>OCOPYnn \\.\physicaldriveN new_file

Multiple diskettes

FAT or NTFS files

C:\>OCOPYnn /B open_file a:

Logical raw

C:\>OCOPYnn /B \\.\C: a:

Physical raw

C:\>OCOPYnn /B \\.\physicaldriveN a:

Where...

Indicates the...

nn

Version of OCOPY.

old_file

Name and location of the open file you want to back up.

new_file

Name and location of the backup copy.

C:

Raw drive which holds a single RAW database file.

physical drive

Physical drive that holds a single RAW database file.

N

Number(s) representing each of the physical drives in the system.

open_file

Path and filename of the open file you want to back up.

a:

Diskette drive containing the diskette on which to save the backup copy. If the file is too large to fit on one diskette, OCOPY prompts you to insert new diskettes as needed. OCOPY catalogs the parts of the file automatically so that it can be reconstructed at a later time.

/B

Large files must be split over multiple diskettes.

Note: Always use a fresh diskette for each OCOPY procedure; do not use OCOPY to back up a file onto a diskette that contains part or all of another file backed up using OCOPY.

Recovering Files with OCOPY

The table below describes the syntax to use when recovering all file types from hard disk or multiple diskettes.

Restore From... File Type to Restore Syntax
Hard Disk ¹

FAT or NTFS files

Use the Windows NT COPY command

Logical raw

C:\> OCOPYnn new_file \\.\c:

Physical raw

C:\> OCOPYnn new_file \\.\physicaldriveN

Multiple diskettes ²

FAT or NTFS files

C:\> OCOPYnn /R a: restore_dir
Note... First insert the disk containing the initial part of the backed up file.

Logical raw

C:\> OCOPYnn /R a: \\.\c:

Physical raw

C:\> OCOPYnn /R a: \\.\physicaldriveN

These are files originally backed up without the /B option.

These are files originally backed up with the /B option

Where... Indicates the...
C:

Raw drive, which holds a single RAW database file. If you use a different drive as your raw drive, substitute it for C:. OCOPY prompts you to insert diskettes as needed.

new_file

File name to which to restore the file.

physicaldrive

Physical drive that holds a single RAW database file.

N

Number(s) representing each of the physical drives in the system.

/R

Restore option

a:

Drive containing the diskette with the backed up file.

restore_dir

Directory on the server in which to place the file. (The restored file has the same name as the original file.)

Copyright © 1996 Oracle Corporation.
All Rights Reserved.