quick RMAN question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: quick RMAN question

Hybrid View

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    quick RMAN question

    Hi all;

    If I already set the parameter for the instance I want to backup as follow:

    RMAN> configure channel device type disk format 'Z:\RMANTEST\%d_DB_%u_%s_%p';


    question: how can I undo that parameter, the reason is I want to split the backup to 3,4 different channel.

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Quote Originally Posted by hannah00
    Hi all;

    If I already set the parameter for the instance I want to backup as follow:

    RMAN> configure channel device type disk format 'Z:\RMANTEST\%d_DB_%u_%s_%p';


    question: how can I undo that parameter, the reason is I want to split the backup to 3,4 different channel.

    thanks
    You have to use more than one channel.

    Code:
    allocate channel c1 type disk format 'Z:\oraback\';
    allocate channel c2 type disk format 'Y:\oraback\';
    allocate channel c3 type disk format 'X:\oraback\';
    
    backup database;
    
    release channel c1;
    release channel c2;
    release channel c3;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2005
    Posts
    221
    thanks Jeff as usual.

    when I did what you recommended, I got the below error:

    RMAN> allocate channel c1 type disk format 'z:\rmantest';

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "identifier": expecting one of: "for"
    RMAN-01008: the bad identifier was: c1
    RMAN-01007: at line 1 column 18 file: standard input

    RMAN>

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    The exact syntax would be

    allocate channel c1 type disk format 'Z:\oraback\%d_DB_%u_%s_%p';
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2005
    Posts
    221
    Jeff,

    could you please tell me what happened here ????

    Code:
    RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'C:\BACKUP\BACKUP_%U';
    
    old RMAN configuration parameters:
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'C:\RMANTEST\BACKUP_%U';
    new RMAN configuration parameters:
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'C:\BACKUP\BACKUP_%U';
    new RMAN configuration parameters are successfully stored
    starting full resync of recovery catalog
    full resync complete
    released channel: ORA_DISK_1
    
    RMAN> run {
    2> backup database plus archivelog;
    3> delete noprompt obsolete;
    4> }
    
    
    Starting backup at 21-JUL-05
    current log archived
    configuration for DISK channel 2 is ignored
    configuration for DISK channel 3 is ignored
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=14 devtype=DISK
    channel ORA_DISK_1: starting archive log backupset
    channel ORA_DISK_1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=331 recid=1 stamp=564232485
    input archive log thread=1 sequence=332 recid=2 stamp=564232486
    input archive log thread=1 sequence=333 recid=3 stamp=564232487
    input archive log thread=1 sequence=334 recid=4 stamp=564232489
    input archive log thread=1 sequence=335 recid=5 stamp=564232567
    input archive log thread=1 sequence=336 recid=6 stamp=564232643
    input archive log thread=1 sequence=337 recid=7 stamp=564232723
    input archive log thread=1 sequence=338 recid=8 stamp=564233762
    input archive log thread=1 sequence=339 recid=9 stamp=564233762
    input archive log thread=1 sequence=340 recid=10 stamp=564233768
    input archive log thread=1 sequence=341 recid=11 stamp=564233768
    input archive log thread=1 sequence=342 recid=12 stamp=564233774
    input archive log thread=1 sequence=343 recid=13 stamp=564235162
    input archive log thread=1 sequence=344 recid=14 stamp=564238641
    input archive log thread=1 sequence=345 recid=15 stamp=564239093
    input archive log thread=1 sequence=346 recid=16 stamp=564239187
    input archive log thread=1 sequence=347 recid=17 stamp=564239268
    input archive log thread=1 sequence=348 recid=18 stamp=564239361
    input archive log thread=1 sequence=349 recid=19 stamp=564239412
    input archive log thread=1 sequence=350 recid=20 stamp=564239604
    channel ORA_DISK_1: starting piece 1 at 21-JUL-05
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of backup command at 07/21/2005 13:13:28
    ORA-19504: failed to create file "C:\BACKUP\BACKUP_0dgq377l_1_1"
    ORA-27040: skgfrcre: create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    
    RMAN>
    there is a folder backup under c drive

  6. #6
    Join Date
    Jan 2005
    Posts
    221
    jEFF,

    I got it. the backup location has to be local as the database server.



    the next question is "HOW CAN WE BACKUP THE DATABASE TO SOME OTHER SERVER ON THE NETWORK (WE DON'T HAVE ANY STORAGE SYSTEM AT THE MOMMENT).

  7. #7
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    1)You can undo the parameter in the following 2 ways
    a)Use the following command to configure the RMAN parameters
    RMAN>configure channel device type disk;
    Dont give the format and the destination.
    b)In the RMAN script, forcibly use the following command to overwrite the RMAN configuration done.
    run
    {
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    allocate channel c3 type disk;
    backup database format 'Z:\RMANTEST\%d_DB_%u_%s_%p';
    .
    .
    .
    }
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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