Forum Stats

  • 3,815,814 Users
  • 2,259,091 Discussions
  • 7,893,253 Comments

Discussions

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

User_OPD8R
User_OPD8R Member Posts: 15 Green Ribbon

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

Answers

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown

    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
    User_OPD8R Member Posts: 15 Green Ribbon

    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!