error conecting rman
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error conecting rman

  1. #1
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64

    error conecting rman

    I'm trying to connect to rman:
    rman target sys/pass@sid /nocatalog
    i get can't open target
    what is the exact conection string

  2. #2
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    RMAN.....

    Hello.

    First make sure that that your repository is running.
    At the c prompt try this:
    c:>rman nocatalog username/password@sid target sys/sysdba@sid

    Hope this helps.
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  3. #3
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64
    I Can connect tru management server. Here is the output from backup:
    Recovery Manager: Release 9.2.0.1.0 - Production

    Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

    RMAN>
    connected to target database: BUILD3 (DBID=3790206214)
    using target database controlfile instead of recovery catalog

    RMAN>
    RMAN> run {
    2> allocate channel Channel1 type disk format '/u01/backup/b_%u_%p_%c';
    3> backup
    4> ( database include current controlfile );
    5>
    6> }
    allocated channel: Channel1
    channel Channel1: sid=11 devtype=DISK

    Starting backup at NOV 27 2003 10:39:20
    channel Channel1: starting full datafile backupset
    channel Channel1: specifying datafile(s) in backupset
    including current controlfile in backupset
    input datafile fno=00001 name=/u01/app/oracle/oradata/build3/system01.dbf
    input datafile fno=00002 name=/u01/app/oracle/oradata/build3/undotbs01.dbf
    input datafile fno=00005 name=/u01/app/oracle/oradata/build3/example01.dbf
    input datafile fno=00010 name=/u01/app/oracle/oradata/build3/xdb01.dbf
    input datafile fno=00006 name=/u01/app/oracle/oradata/build3/indx01.dbf
    input datafile fno=00009 name=/u01/app/oracle/oradata/build3/users01.dbf
    input datafile fno=00003 name=/u01/app/oracle/oradata/build3/cwmlite01.dbf
    input datafile fno=00004 name=/u01/app/oracle/oradata/build3/drsys01.dbf
    input datafile fno=00007 name=/u01/app/oracle/oradata/build3/odm01.dbf
    input datafile fno=00008 name=/u01/app/oracle/oradata/build3/tools01.dbf
    channel Channel1: starting piece 1 at NOV 27 2003 10:39:21
    channel Channel1: finished piece 1 at NOV 27 2003 10:41:38
    piece handle=/u01/backup/b_01f7fvuo_1_1 comment=NONE
    channel Channel1: backup set complete, elapsed time: 00:02:18
    Finished backup at NOV 27 2003 10:41:38

    Starting Control File and SPFILE Autobackup at NOV 27 2003 10:41:38
    piece handle=/u01/backup/c-3790206214-20031127-00 comment=NONE
    Finished Control File and SPFILE Autobackup at NOV 27 2003 10:41:40
    released channel: Channel1

    RMAN>
    RMAN> **end-of-file**

    RMAN>

    Recovery Manager complete.


    But when i try to connect rman manual in the console i get: can't open target
    Any ideas?

    P.S. operating system red hat advanced server 2.1

  4. #4
    Join Date
    Sep 2002
    Posts
    12
    From the command line type:

    rman TARGET SYS/password@target NOCATALOG

    Corrado
    Corrado Mascioli

  5. #5
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64
    nah
    the same output

  6. #6
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64
    I solved the "problem"
    After some investigation I found that there is /usr/X11R6/bin/rman executable. the path to /usr/X11R6/bin is before the path to oracle_home. So when i typed the whole path to oracle rman executable it started properly

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