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

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

Re: Confused about RMAN Functioning

From: Job Miller <jobmiller_at_yahoo.com>
Date: Thu, 19 Jul 2007 19:11:10 -0700 (PDT)
Message-ID: <20070720021110.84204.qmail@web53907.mail.re2.yahoo.com>


It's been that way for quite some time:

http://www.trivadis.com/Images/Bckctrl_rman_e_tcm17-7240.pdf

This explains the implications (or really the lack of implications) for this reporting difference based on the means by which the backup is taken. It is recorded in the catalog/control file either way, and both are usable in any restore/recovery process.

Job

William Wagman <wjwagman_at_ucdavis.edu> wrote: 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 '';   quit
EOF $RMAN target / nocatalog <
RUN {
  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;   BACKUP INCREMENTAL LEVEL=${_BK_LEVEL} FORMAT '' FILESPERSET=64 AS COMPRESSED BACKUPSET DATABASE;   SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';   BACKUP FORMAT '' ARCHIVELOG ALL DELETE INPUT;   BACKUP FORMAT '' 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 ''; command and list backup of controlfile displays the file created by the...

BACKUP FORMAT '' 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        



Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
--

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

Original text of this message

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