Oracle Database Discussions

Hi All,

I have to restore rman backup's to test server every day so i am planning to automate the restoration.

1)every day the rman backup is going to copy from prod to test in the below location
[oracle@orcl01 backup]$ pwd
/u02/oradata/trax/backup

My backup files look like this

[oracle@orcl01 backup]$ ls -lrta
-rw-r----- 1 oracle oinstall 156640256 Apr 21 05:20 rman4_u7ma9qcm_1_1.bk
-rw-r----- 1 oracle oinstall 332751872 Apr 21 05:20 rman3_u6ma9qcm_1_1.bk
-rw-r----- 1 oracle oinstall 299827200 Apr 21 05:20 rman2_u5ma9qcm_1_1.bk
-rw-r----- 1 oracle oinstall 354471424 Apr 21 05:20 rman1_u4ma9qcm_1_1.bk
-rw-r----- 1 oracle oinstall 2920996864 Apr 21 05:20 rman1_u8ma9qef_1_1.bk
-rw-r----- 1 oracle oinstall 7782178816 Apr 21 05:21 rman4_ubma9qef_1_1.bk
-rw-r----- 1 oracle oinstall 8354365440 Apr 21 05:22 rman2_u9ma9qef_1_1.bk
-rw-r----- 1 oracle oinstall 8364433408 Apr 21 05:23 rman3_uama9qef_1_1.bk
-rw-r----- 1 oracle oinstall 8562688 Apr 21 05:23 rman1_ucma9s5v_1_1.bk
-rw-r----- 1 oracle oinstall 8257536 Apr 21 05:23 rmanctrl_B_c-1215068670-20110421-00
-rw-r----- 1 oracle oinstall 8224768 Apr 21 06:05 rmanctrl_B_c-1215068670-20110421-01


Here 2 control files is there when i tried to restore it i am getting the error. I didnt give the complete control file name instead i have given *. If I give complete name then I am able to restore it but when i give * rman not able to identify the file.


[oracle@orcl01 scripts]$ more control.rcv
startup nomount;
restore controlfile from '/u02/oradata/trax/backup/rmanctrl_B_*';
alter database mount;
exit;


How can i select only one control file to the script???? if i give controlfile name correctly then i am able to automate the entire restoration.

Can any one pls tell me how to procede further

KK