Rman List Doubt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman List Doubt

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Rman List Doubt

    Hi all ,

    None of my List commands except incarnation are displaying any data.

    For Example

    RMAN>

    RMAN> run
    2> {
    3> allocate channel c1 type disk;
    4> copy datafile 5 to 'D:\testtools.dbf';
    5> release channel c1;
    6> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: c1
    RMAN-08500: channel c1: sid=16 devtype=DISK

    RMAN-03022: compiling command: copy
    RMAN-03023: executing command: copy
    RMAN-08000: channel c1: copied datafile 5
    RMAN-08501: output filename=D:\TESTTOOLS.DBF recid=3 stamp=360959478
    RMAN-03023: executing command: partial resync
    RMAN-08003: starting partial resync of recovery catalog
    RMAN-08005: partial resync complete

    RMAN-03022: compiling command: release
    RMAN-03023: executing command: release
    RMAN-08031: released channel: c1

    RMAN> list copy of datafile 'd:\oracle\oradata\pravitha\tools01.dbf';

    RMAN-03022: compiling command: list

    RMAN>




    Like this no output is Displayed when i use List command except


    RMAN> list incarnation
    2> ;

    RMAN-03022: compiling command: list

    List of Database Incarnations
    DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
    ------- ------- -------- ---------------- --- ---------- ----------
    267 268 PRAVITHA 161374775 NO 1 20-JAN-03
    267 488 PRAVITHA 161374775 YES 242010 24-MAR-99

    RMAN>

    Are there any settings to be done . Could anyone Help
    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658
    Hi,

    Use proper case say for eg in caps rather in smaller

    ...list copy of datafile 'd:\oracle\oradata\pravitha\tools01.dbf';

    ...list copy of datafile 'D:\ORACLE\ORADATA\PRAVITHA\TOOLS01.dbf';

    Select name from v$datafile and check how its displayed try that way.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Aug 2002
    Posts
    176
    Thanks a lot Padmam for your reply , but its not only for datafiles , the list command itself does not provide me any output. See down below i give a backup of tablespace and once its done i give the List command and nothing displays. Could you pls explain.


    RMAN> run
    2> {
    3> allocate channel c1 type disk;
    4> backup tablespace tools;
    5> release channel c1;
    6> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: c1
    RMAN-08500: channel c1: sid=14 devtype=DISK

    RMAN-03022: compiling command: backup
    RMAN-03023: executing command: backup
    RMAN-08008: channel c1: starting full datafile backupset
    RMAN-08502: set_count=12 set_stamp=361017141 creation_time=25-MAR-99
    RMAN-08010: channel c1: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00005 name=D:\ORACLE\ORADATA\PRAVITHA\TOOLS01.DBF

    RMAN-08013: channel c1: piece 1 created
    RMAN-08503: piece handle=D:\ORACLE\ORA81\DATABASE\0CAO9BPL_1_1 comment=NONE
    RMAN-08525: backup set complete, elapsed time: 00:00:09
    RMAN-03023: executing command: partial resync
    RMAN-08003: starting partial resync of recovery catalog
    RMAN-08005: partial resync complete

    RMAN-03022: compiling command: release
    RMAN-03023: executing command: release
    RMAN-08031: released channel: c1

    RMAN> list backup;

    RMAN-03022: compiling command: list

    RMAN>

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    May be A Solution

    Hi,

    This should be something related to date issue ...

    i.e the incarnation date or (database Creation date) and the system date.

    RMAN mistakes the backupset is older then the Database creation -or incarnation date....

    change the Operating System date to be the current date and check whether it works.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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