Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

Then the control file expands retain the information


Chapter 18

SQL keywords and database initialization parameter names. Within script code

examples, I prefer to use lowercase for readability.


NOTE The script can be made even simpler by using the BACKUP FULL

specify one, your scripts will work unchanged with Oracle8i and Oracle9i.

To perform the backup, a SYSDBA connection is required. In this case, we connect as SYSDBA using the target�/ command-line option to connect to the Oracle instance

Backup and Recovery Using Recovery Manager (RMAN)

After the backup has completed successfully, you can see information about the backup held in the control file by querying the v$backup_piece view:

select device_type,handle from v$backup_piece;

It’s very helpful to define a naming standard for the backup pieces. The convention used in the example is ORA_ followed by the type of backup (O for open database, C for closed database, and A for archived redo log), followed by the name of the data-base, followed by other information guaranteed to make the name of the piece unique. Structuring the names of your backup pieces might not seem so important now, but it becomes much more significant when you send your backups to a Legato server and you need to distinguish between the different types of backups held on the corporate server, such as NT and UNIX file backups, and Microsoft SQL Server database back-ups. The chosen naming convention immediately identifies the backup piece as belonging to an Oracle database named OMFD1 that is backed up using RMAN.

NOTE RMAN in Oracle9i includes a new command to back up archived redo

run {

allocate channel c1 type disk;

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELIA328D2A
Uploaded by :
Page 1 Preview
then the control file expands retain the informati
Sell Your Old Documents & Earn Wallet Balance