learning RMAN
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: learning RMAN

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    learning RMAN

    I have been doing some reading and try to learn RMAN. Any, I did create catalog and register the database I want to backup to RMAN. So I used RMAN to connect to the target database and everything is ok. When I issue the command: BACKUP DATABASE.

    I got:

    Starting backup at 12-FEB-04
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=11 devtype=DISK
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    including current controlfile in backupset
    input datafile fno=00004 name=D:\ORADATA\TEST\LIS_DATA_02.DBF
    input datafile fno=00003 name=D:\ORADATA\TEST\LIS_DATA_01.DBF
    input datafile fno=00006 name=D:\ORADATA\TEST\LIS_INDX_01.DBF
    input datafile fno=00005 name=D:\ORADATA\TEST\LIS_INDX_02.DBF
    input datafile fno=00007 name=D:\ORADATA\TEST\LOG_DATA_01.DBF
    input datafile fno=00001 name=E:\ORADATA\TEST\SYSTEM01.DBF
    input datafile fno=00011 name=D:\ORADATA\TEST\QSAA_DATA_01.DBF
    input datafile fno=00016 name=E:\ORADATA\TEST\RBS1TEST.ORA
    input datafile fno=00008 name=D:\ORADATA\TEST\LOG_INDX_01.DBF
    input datafile fno=00002 name=F:\ORADATA\TEST\UNDO01.DBF
    input datafile fno=00009 name=D:\ORADATA\TEST\LOK_DATA_01.DBF
    input datafile fno=00010 name=D:\ORADATA\TEST\LOK_INDX_01.DBF
    input datafile fno=00014 name=D:\ORADATA\TEST\USR_DATA_01.DBF
    input datafile fno=00012 name=D:\ORADATA\TEST\QSAA_INDX_01.DBF
    input datafile fno=00013 name=D:\ORADATA\TEST\TOOLS_01.DBF
    input datafile fno=00015 name=D:\ORADATA\TEST\USR_INDX_01.DBF
    channel ORA_DISK_1: starting piece 1 at 12-FEB-04
    channel ORA_DISK_1: finished piece 1 at 12-FEB-04
    piece handle=C:\ORACLE\ORA920\DATABASE\09FDTGO4_1_1 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
    Finished backup at 12-FEB-04


    when I go to C:\ORACLE\ORA920\DATABASE\, nothing related to 09fdtgo4_1_1.

    the question is: where is my backup the TEST database. what is 09FDTGO4_1_1????

    thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    312
    can somone give me advise, please????

  3. #3
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334

    Re: learning RMAN

    09FDTGO4_1_1 IS your backup.

    Is the file in C:\ORACLE\ORA920\DATABASE or not?

  4. #4
    Join Date
    Oct 2003
    Posts
    312
    no, there is nothing in there that's why I am confused.

  5. #5
    Join Date
    Oct 2002
    Posts
    182
    what about $ORACLE_HOME/dbs ??

    also,
    log in to target and catalog, then type:
    SHOW ALL;


    please post what the output is.
    - Cookies

  6. #6
    Join Date
    Oct 2003
    Posts
    312
    there is nothing in dbs


    and below is what I have when I typed:RMAN> show all
    2> ;

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA920\DATABASE\SNCFTEST.O
    RA'; # default
    RMAN configuration has no stored or default parameters

    RMAN>

    thanks

  7. #7
    Join Date
    Oct 2002
    Posts
    182
    how about setting some of those?

    try this code which will send everything to 'C:\ORACLE\ORA920\DATABASE\'

    run this in RMAN after you connect to target and catalog:
    Code:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\ORACLE\ORA920\DATABASE\control_%F';
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'C:\ORACLE\ORA920\DATABASE\backup_%U';
    CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   'C:\ORACLE\ORA920\DATABASE\backup_%U';
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA920\DATABASE\snap_controlf';
    then issue: backup database;

    let's see if that generates anything.
    - Cookies

  8. #8
    Join Date
    Oct 2003
    Posts
    312
    thanks cookie,

    again I follow your adivses and run the backup database again, and it created the backup file again. but when I go to $ORACLE_HOME\database\, I can't find any file under that name and matter of fact I did a search on my entire computer, I still couldn't find anything.

    Sorry, you have any other advises????
    thnaks

  9. #9
    Join Date
    Oct 2002
    Posts
    182
    wait, is the database located on your machine
    or somewhere else?

    send me the output from when you log into rman and
    what exactly you run and what the output is.

    example of what I am looking for:

    rman
    connect target /
    connect catalog x/y@xyz

    RMAN> backup database


    etc. etc.
    - Cookies

  10. #10
    Join Date
    Oct 2003
    Posts
    312
    the target database located on different server and rman is running on my computer:

    from my computer which is running rman, I have:

    c:\rman catalog rman/rman@rman(my local database running rman) target sys/manager@test(the target database running on different machine)

    C:\>rman catalog rman/rman@rman target sys/vms700@test

    Recovery Manager: Release 9.2.0.4.0 - Production

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

    connected to target database: TEST (DBID=688097787)
    connected to recovery catalog database

    RMAN>

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