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

Thread: RMAN default location on NT?

  1. #1
    Join Date
    Apr 2000
    Location
    Charlotte, NC, USA
    Posts
    48
    Hi,

    I am getting familiar with RMAN, 8.1.7 and executed a backup from NT to NT pc. The backup went to a default location on the target database drive. However, the target database c drive had very little free space and filled.

    How do I determine what the default RMAN location is for disk backups? How do I change that location to the pc the RMAN database is located on?

    Vanilla script is below:
    1 {
    2 allocate channel ch1 type disk;
    3 allocate channel ch2 type disk;
    4 backup database;
    5 sql 'ALTER SYSTEM ARCHIVE LOG ALL';
    6 backup archivelog all;}

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    There is no default RMAN location for disk backups.You can give the entire pathname of the location of the backups on the same database in the format :

    e.g
    Vanilla script is below:
    {
    allocate channel ch1 type disk;
    allocate channel ch2 type disk;
    filesperset=10 format 'c:\data\backup\backup%d%s'
    backup database;
    sql 'ALTER SYSTEM ARCHIVE LOG ALL';
    }


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP8i
    rohitsn@altavista.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