iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - Fundamentals II

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 |

 

Lesson 19

“The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little.” Franklin D. Roosevelt

 

Read first then play the video:

   DBA-VIDEO -RMAN Managed Complete Backup

   

RMAN-Managed Complete Backup

Introduction

As a DBA, you are also responsible for performing complete backups using the RMAN tool. Your job’s responsibilities dictate that you should at least be informed of the following basic fundamental subjects:

 

Performing a complete database backup

Using the LIST BACKUP command

Commands:

DOS> rman CATALOG

RMAN> BACKUP DATABASE

RMAN> LIST BACKUP;

RMAN> exit;

 

Hands-on

In this exercise you will learn how to perform a complete FULL database backup using the RMAN tool.

Now, connect to the SCHOOL database as the SYSTEM/MANAGER user.
SQL> CONNECT system/manager@school

Go back to the RMAN tool and connect to the SCHOOL database as the target database and the RMAN database as a repository.
DOS> rman CATALOG rman/password@dbs4rman TARGET system/manager@school


Perform a complete backup

The following is one way you can do the complete database backup. Notice that the default backup destination is %ORACLE_HOME%.
rman>

RUN
{
     ALLOCATE CHANNEL mybackup TYPE disk;
     BACKUP DATABASE;
}


-OR-

 

rman> BACKUP DATABASE;


Perform a complete backup in an specific location
Or you can perform a complete RMAN backup database and store the backup in the RMANBKUP directory with stamp date, the backup set number, and the piece number. Notice that we use %T for the date, %s for the backup set number, and %p for the piece number.

RMAN> BACKUP DATABASE FORMAT 'c:_%T_%s_%p';


Verify Backup
Verify the complete or full backup by issuing the LIST BACKUP command.
rman> LIST BACKUP;

 

Exit from the recovery manager.
rman> exit;

 

“I don't care what is written about me so long as it isn't true.” Dorothy Parker

 

Questions:

Q: How do you perform a complete database backup using the RMAN tool?

Q: Describe the LIST BACKUP command.

Q: What do the following RMAN commands do?

DOS> rman CATALOG rman/password@dbs4rman

TARGET system/manager@school

rman>

RUN
{
     ALLOCATE CHANNEL mybackup TYPE disk;
     BACKUP DATABASE;
}

rman> BACKUP DATABASE;

RMAN> BACKUP DATABASE FORMAT 'c:_%T_%s_%p';

rman> LIST BACKUP;