Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Confused about RMAN Functioning

Confused about RMAN Functioning

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Thu, 19 Jul 2007 17:28:19 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A037D1ABF@VEXBE2.ex.ad3.ucdavis.edu>


Greetings,

I find myself puzzled about how RMAN is functioning. I'm running 10gR2 on RHEL3. My backup script does the following (lots of stuff which I will leave out but is not relevant). The relevant piece is this...

sqlplus -s / << EOF
  ALTER DATABASE BACKUP CONTROLFILE TO '<file_spec>';   quit
EOF $RMAN target / nocatalog <<EOF
RUN {
  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;   BACKUP INCREMENTAL LEVEL=${_BK_LEVEL} FORMAT '<file_spec>' FILESPERSET=64 AS COMPRESSED BACKUPSET DATABASE;   SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';   BACKUP FORMAT '<file_spec>' ARCHIVELOG ALL DELETE INPUT;   BACKUP FORMAT '<file_spec>' CURRENT CONTROLFILE;   RELEASE CHANNEL disk1;
}
EOF Everything is fine, I have tested restores and all works as expected. My confusion is regarding the difference between the rman commands...

RMAN> list copy of controlfile;
RMAN> list backup of controlfile;

The copy lists the file created by the...

ALTER DATABASE BACKUP CONTROLFILE TO '<file_spec>';

command and list backup of controlfile displays the file created by the...

BACKUP FORMAT '<file_spec>' CURRENT CONTROLFILE;

command. I don't understand the difference between the copy and the backup and how RMAN is tracking and using these two pieces. If anyone can explain I would appreciate it.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 19 2007 - 19:28:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US