iSelfSchooling.com - Since 1999  References  |  Job Openings
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Topics: RMAN-Managed Complete Backup

More Resources by Google:

Hands-On 06 (RMAN-Managed Complete Backup)

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 LIST BACKUP command

Commands:

            DOS> rman CATALOG

            RMAN> BACKUP DATABASE

            RMAN> LIST BACKUP;

            RMAN> exit;

 

Manuscript

 

-- Hands-On 06 (RMAN-Managed Complete Backup)
-- Preparation
SET ECHO ON

SET linesize 1000 pagesize 55
COL name FORMAT a30
col description format a30
pause

--Start


CLEAR SCR
-- 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.

pause


CONNECT system/manager@school

pause

CLEAR SCR
-- 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
pause
pause

CLEAR SCR
-- This is one way you can do the complete database backup.
-- Notice that the default backup destination is %ORACLE_HOME%\database.

--\/-- rman> RUN
--\/-- {
--\/-- ALLOCATE CHANNEL mybackup TYPE disk;
--\/-- BACKUP DATABASE;
--\/-- }
--\/-- -OR- rman> BACKUP DATABASE;
pause
pause

CLEAR SCR
-- Or you can perform a complete RMAN backup database and
-- store the backup in the RMANBKUP directory with stampdate,
-- 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.

-- Please wait since this will take some time.
-- We are going to pause the movie and start it when the backup process
-- is completed.

--\/-- RMAN> BACKUP DATABASE FORMAT 'c:\RMANBKUP\full_%T_%s_%p';
pause
pause

CLEAR SCR
-- Verify the complete or full backup by issuing the LIST BACKUP command.
-- rman> LIST BACKUP;
pause
pause

-- Exit from the recovery manager.
-- rman> exit;
pause
pause

CLEAR SCR
-- Now, you should practice this Hands-On exercise.

-- For more information about the subject, you are encouraged
-- to read from a wide selection of available books.

-- Good luck.
--
pause
pause 

 

 
 
Google
 
Web web site