3 Replies Latest reply: Nov 14, 2008 1:52 AM by 26741 RSS

    RMAN: Backup As Copy and COPY commands

    489516
      I need a little clarification on the above commands. I am reading about Image Copies under the Using Recovery Manager chapter and there is an example which says: "If you manually allocate channels, you must include the COPY commands within the RUN statement as follows:
      RMAN> RUN {
      2> ALLOCATE CHANNEL c1 type disk;
      3> COPY
      4> DATAFILE '/ORADATA/users_01_db01.dbf' to
      5> '/BACKUP/users01.dbf',
      6> ARCHIVELOG 'arc_1060.arc' to
      7> 'arc_1060.bak';
      8> }

      Is COPY making an image copy that is not in an RMAN recognized format? Because was under the impression that BACKUP AS COPY command was the way to make an image copy usable by RMAN. Any clarification is always appreciated.

      Matt
        • 1. Re: RMAN: Backup As Copy and COPY commands
          26741
          The BACKUP AS COPY command does create an Image Copy -- a byte for byte copy of the datafile.

          However, the syntax you are posting within a RUN block, is not for the BACKUP AS COPY command.

          It is for the COPY command. The COPY command has been available in 9i (8i ?) and is for image copies of a file that may be a datafile / controlfile / archivedlog file OR which, itsself, is a copoy of datafile / controlfile.

          It would seem that you are reading 9i documentation not 10g documentation. The BACKUP AS COPY in 10g does not have to be in a RUN block.


          Hemant K Chitale
          http://hemantoracledba.blogspot.com
          • 2. Re: RMAN: Backup As Copy and COPY commands
            489516
            Hello Hemant,

            Thank your for the reply. Well I thought the snippet looked wired but it is the Oracle Press book(s) for 1Z0-043. One says D17092G20 and the other 30 for the version numbers. Publish dates are 2006 for 30 and 2004 for 20. But thank you for the reply nonetheless, it cleared up some confusion though.

            Regards,
            Matt
            • 3. Re: RMAN: Backup As Copy and COPY commands
              26741
              The COPY command is in the 9i RMAN Reference
              http://download.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta18a.htm#90311
              and mentioned as the command for Image Copies in the 9i RMAN User Gude
              http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc1.htm#459209

              Also there is no mention of AS COPY in the 9i RMAN Reference
              http://download.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta9.htm#78484

              but in the 10g RMAN Reference, there is no COPY command but there is a BACKUP AS COPY
              http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#sthref141
              and mentioned as the command for Image Copies in the 10g RMAN User Guide
              http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1.htm#i1006661