Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backup and Recovery and DR - RMAN vs. NOT

Re: Backup and Recovery and DR - RMAN vs. NOT

From: Bernard Polarski <>
Date: Thu, 4 May 2006 01:43:56 -0700 (PDT)
Message-ID: <>

I Agree with you as long as it is Rman towards tape not toward disk. I love Rman direct to tape as I hate Rman to disk. There is a world between Rman to disk and Rman to tape.  

 So let's consider what happen in the case where the catalog is not connect to a media tape layers and what is handy feature is left of Rman :    

 rman << EOF

    connect target / ;
    connect catalog mycat/*****@cat.db -- Determining the right credentials was the *hardest* part!     restore database ;
    recover database ;
    open database ;

  1. connect target / : This assume that you have retrieved a good controlfile for this backup. Since it is backup on disk, you somehow provided it yourself.
  2. connect catalog : no special comment
  3. restore database : You had to provide the set of correct dataset files. You got the list from catalog. Problem is that you needed to dump from tape this dataset into a staging area, and after that Rman will read them and recreated the datafiles ===> twice the disk space and twice the IO, and all that providing you retrieve the correct set of datasets file whose name is a pure garbage.
  4. recover database : again you dumped from tape the correct dataset of files containing all requested archive logs. good news is that this time you won't need twice the disk space. bads news is you need to check manually with the command 'list achive all' which dataset contains which archives and bring them all from tape.
  5. open database ; just a shorter way to type 'alter database open [resetlogs]'

 So what did you gain in fact.? Rman, when not to tape leaves you with all the fuss to providd the files yourselves and requires twice the space to restore a datafile.  

 B. Polarski

Received on Thu May 04 2006 - 03:43:56 CDT

Original text of this message