'No such file or directory' when trying to refresh standby DB using RMAN incremental backup

User_OPD8R

Hello

I am trying to refresh the standby database using RMAN backup but when i try to copy the files from the directory where i have put them to the directory where the control files are located i got the error:

No such file or directory

Before that i checked the location of the control files in my stand by db:

SQL> show parameter control_files

NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

control_files            string   +DATA/soagwprs/controlfile/cur

                         rent.260.831586851, +FRA/soagw

                         prs/controlfile/current.260.83

                         1586853

When i try with this command :

cp std_control.ctl +DATA/soagwprs/controlfile/current.260.831586851

cp std_control.ctl +FRA/soagwprs/controlfile/current.260.831586853

I got the error: No such file or directory

How can i locate and enter in those +DATA and +FRA directories?

Thanks in advance!

Dario

EdStevens

Why are you trying to manually copy them with OS commands? Especially when the OS doesn't really understand ASM? Why not use the rman RESTORE CONTROLFILE . . .

User_OPD8R

Thanks for your answer EdStevens

In fact i am trying to recover my standby DB because archive logs are missing.

So i did an incremental backup in the Primary DB by taking the last SCN from the Standby DB.

I copy the backup files from Primary to Standby DB using "scp" command.

So now i want to put that backup file "std_control.ctl" to the directory where the Standby DB control files are:

+DATA/soagwprs/controlfile/current.260.831586851 , +FRA/soagwprs/controlfile/current.260.831586853.

Please can you tell me how can i do this operation by using RMAN?

Thanks in advance!