rman on windows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: rman on windows

  1. #1
    Join Date
    Oct 2006
    Posts
    17

    rman on windows

    I am consulting at a company with Oracle 11G on windows.
    I have not been on this platform with Oracle in many moons so I am getting back up to speed.
    Networker (backup software) issues the command: RMAN c:\rman.bat

    I was expecting a .bat file like this calling an rman.cmd file

    set oracle_sid=orcl
    rman target sys/manager1@orcl nocatalog cmdfile='c:\db_arc_backup.cmd' log='c:\bk_log.log'


    but this is what they have runnning successfuly

    connect target myuser/mypass@MYDB
    run {
    allocate channel t1 type 'SBT_TAPE'
    parms 'ENV=(NSR_SERVER=FQN_HERE,NSR_CLIENT=OURCLIENT,NSR_DATA_VOLUME_POOL=MYDAILY)';
    backup current controlfile;
    backup full filesperset 4 database format 'FULL_%d_%u';
    backup filesperset 4 format 'AL_%d_%T_s%s_p%p'archivelog all;
    release channel t1;
    }


    I want to have logging on the oracle side and not rely on the backup software. Is it possible to add a log within rman or do I have to have Networker pass the log parameter
    Last edited by smd; 12-16-2009 at 11:17 AM.

  2. #2
    Join Date
    Oct 2006
    Posts
    17
    actually backups look successful from NETWORKER but when I look at v$backup it shows the files havent been in backup mode since the 3rd

    FILE# STATUS CHANGE# TIME
    ---------- ------------------ ---------- ---------
    1 NOT ACTIVE 592387795 03-DEC-09
    2 NOT ACTIVE 592387809 03-DEC-09
    3 NOT ACTIVE 592387816 03-DEC-09
    4 NOT ACTIVE 592387824 03-DEC-09
    5 NOT ACTIVE 592387834 03-DEC-09


    On the third I added a line to delete archives after they had been backed up 2 times. I just took the line out and re ran but v$backup hasnt changed. The rman file is above.


    EDIT:

    Nevermind, I realized that rman does not log to v$backup

    --SMD
    Last edited by smd; 12-16-2009 at 03:50 PM.

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