Rman backup control file question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman backup control file question

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Rman backup control file question

    What are the differences between these 2 RMAN syntaxes?

    1.backup current controlfile;
    2.copy current controlfile to '.......';

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Re: Rman backup control file question

    Originally posted by oracleman
    What are the differences between these 2 RMAN syntaxes?

    1.backup current controlfile;

    >>>> Here you are saving the current control file which is currently open by an instance and you don't have to specify the file name and destination.


    2.copy current controlfile to '.......';

    >>>> Here you are saving the control file from control file to a destination file which is realy not the current control file.


    Giani

  3. #3
    Join Date
    Jul 2003
    Posts
    1
    The commands are different. The 1st makes a backup of the controlfile in an RMAN backupset. It will use the default %U format.

    backup current controlfile;

    The next is making a binary backup copy of the controlfile to disk.

    backup current controlfile to '/path/filename.cf';

    This copy can be used without restore to mount and restore an Oracle database from an RMAN backupset. If in nocatalog mode it essential to make this copy last after the backup of the database and the archived logs. Oracle9i handles this with the autobackup controlfile feature.

  4. #4
    Join Date
    Sep 2004
    Location
    Texas
    Posts
    1

    Exclamation

    just a suggestion - use:
    RMAN> configure controlfile autobackup on;
    that is if you are on 9i ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width