-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|