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

Thread: RMAN question

  1. #1
    Join Date
    Sep 2004
    Posts
    18

    RMAN question

    HI friends
    I need advice, i am doing this for first time and not too familiar with rman.

    2.database should be up
    3.Run RMAN from test
    4.set until time '05-JUN-2004 17:08:00';
    5. Add /u22/oracle/proddata/xxabetd01.dbf
    /u18/oracle/proddata/users02.dbf

    $ nohup rman target /rcvcat/rman@oemrep log=test.log &



    I need your help in this regard. we have to use /u01/backup/sunday on the TEST server

    cd /u01/backup
    $ ls
    friday monday nohup.out saturday sunday thursday tuesday wednesday
    $ ls -l
    total 12
    drwxrwxrwx 2 oracle 100 1024 Aug 31 09:13 friday
    drwxrwxrwx 2 oracle 100 1024 Aug 27 16:45 monday
    -rw-r----- 1 oracle dba 0 Sep 14 20:43 nohup.out
    drwxrwxrwx 2 oracle 100 96 Aug 27 17:05 saturday
    drwxrwxrwx 2 oracle 100 1024 Aug 23 05:36 sunday
    drwxrwxrwx 2 oracle 100 1024 Aug 27 17:16 thursday
    drwxrwxrwx 2 oracle 100 1024 Aug 27 16:54 tuesday
    drwxrwxrwx 2 oracle 100 1024 Aug 27 17:05 wednesday

    I run this , but i want to know how to do that mountpoint thing and also in the attached script

    what would be the set until time '05-JUN-2004 17:08:00';(this is an example) if i am choosing sunday backup
    and also if I do
    $ nohup rman target /rcvcat/rman@oemrep log=test.log &

    1)how does the above command identify the testrefresh.rman script and also the directory u01/backup/sunday to do the restore ??

    below is the script called testrefresh.rman
    ************
    run {
    set until time '05-JUN-2004 17:08:00';
    allocate auxiliary channel c1 type disk;
    allocate auxiliary channel c2 type disk;
    allocate auxiliary channel c3 type disk;
    set newname for datafile 1 to '/u07/oracle/testdata/system01.dbf';
    set newname .........
    duplicate target database to TEST
    LOGFILE
    GROUP 1 (
    '/u02/oracle/testdata/log01a.dbf',
    '/u04/oracle/testdata/log01b.dbf'
    ) SIZE 1000M,
    GROUP 2 (
    '/u02/oracle/testdata/log02a.dbf',
    '/u04/oracle/testdata/log02b.dbf'
    ) SIZE 1000M,
    GROUP 3 (
    '/u02/oracle/testdata/log03a.dbf',
    '/u04/oracle/testdata/log03b.dbf'
    ) SIZE 1000M,
    GROUP 4 (
    '/u02/oracle/testdata/log04a.dbf',
    '/u04/oracle/testdata/log04b.dbf'
    ) SIZE 1000M;
    }

    I hope somebody provide me some useful input at the earliest.


    Thanks

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Sorry, I don't understand your question.
    PS: 5th june'04 was a saturday, NOT a sunday

    > 1)how does the above command identify the testrefresh.rman script and also the directory u01/backup/sunday to do the restore ??

    Thats where (the directory) I presume you backed up (and restored your backup) on that Sunday. That's how.

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