FAQ
Hi,
I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

Here is what runcluvfy says (and runInstaller)
(note: yes, changed the a/b on network so I don't get in trouble)

[oracle_at_flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

Performing pre-checks for cluster services setup

Checking node reachability...
Node reachability check passed from node "flux-rac-node-wcdp-01"

Checking user equivalence...
User equivalence check passed for user "oracle"

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

WARNING:

Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

WARNING:

Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

ERROR:

PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
Checking multicast communication...

Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

[oracle_at_flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
WARNING:

This system is solely for ...
total 4
drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle

Search Discussions

  • Amaral, Rui at Sep 28, 2011 at 4:01 pm
    Jed,
    From your output it looks like the banner is causing the problem.
    The section "ssh flux-rac-node-wcdp-02 ls -l /tmp" and it returns the warning. That's the first place to start.




    Rui Amaral


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 11:52 AM
    To: oracle-l@freelists.org
    Subject: RACnode communication problem?

    Hi,
    I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

    Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

    BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

    Here is what runcluvfy says (and runInstaller)
    (note: yes, changed the a/b on network so I don't get in trouble)

    [oracle@flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

    Performing pre-checks for cluster services setup

    Checking node reachability...
    Node reachability check passed from node "flux-rac-node-wcdp-01"


    Checking user equivalence...
    User equivalence check passed for user "oracle"

    Checking node connectivity...

    Checking hosts config file...

    Verification of the hosts config file successful


    WARNING:
    Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

    WARNING:
    Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

    ERROR:
    PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
    Checking multicast communication...

    Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

    I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

    [oracle@flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
    WARNING:

    This system is solely for ...
    total 4
    drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle


    --
    http://www.freelists.org/webpage/oracle-l



    NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
    AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
    --
    http://www.freelists.org/webpage/oracle-l
  • Walker, Jed S at Sep 28, 2011 at 4:11 pm
    Thank you Rui, that did the trick!

    -----Original Message-----
    From: Amaral, Rui
    Sent: Wednesday, September 28, 2011 10:00 AM
    To: Walker, Jed S; oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Jed,
    From your output it looks like the banner is causing the problem.
    The section "ssh flux-rac-node-wcdp-02 ls -l /tmp" and it returns the warning. That's the first place to start.




    Rui Amaral


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 11:52 AM
    To: oracle-l@freelists.org
    Subject: RACnode communication problem?

    Hi,
    I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

    Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

    BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

    Here is what runcluvfy says (and runInstaller)
    (note: yes, changed the a/b on network so I don't get in trouble)

    [oracle@flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

    Performing pre-checks for cluster services setup

    Checking node reachability...
    Node reachability check passed from node "flux-rac-node-wcdp-01"


    Checking user equivalence...
    User equivalence check passed for user "oracle"

    Checking node connectivity...

    Checking hosts config file...

    Verification of the hosts config file successful


    WARNING:
    Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

    WARNING:
    Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

    ERROR:
    PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
    Checking multicast communication...

    Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

    I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

    [oracle@flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
    WARNING:

    This system is solely for ...
    total 4
    drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle


    --
    http://www.freelists.org/webpage/oracle-l



    NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
    AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
    --
    http://www.freelists.org/webpage/oracle-l
  • Walker, Jed S at Sep 28, 2011 at 6:30 pm
    Well, I thought I saw it work, but no, still the same error. The banner is gone though on all nodes and I've verified by "ssh ... date" from all to all and only get the date return, no banner. I even rebooted two nodes to make sure sshd was definitely working on the new sshd_config

    Other ideas?

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 10:10 AM
    To: Amaral, Rui; oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Thank you Rui, that did the trick!

    -----Original Message-----
    From: Amaral, Rui
    Sent: Wednesday, September 28, 2011 10:00 AM
    To: Walker, Jed S; oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Jed,
    From your output it looks like the banner is causing the problem.
    The section "ssh flux-rac-node-wcdp-02 ls -l /tmp" and it returns the warning. That's the first place to start.




    Rui Amaral


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 11:52 AM
    To: oracle-l@freelists.org
    Subject: RACnode communication problem?

    Hi,
    I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

    Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

    BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

    Here is what runcluvfy says (and runInstaller)
    (note: yes, changed the a/b on network so I don't get in trouble)

    [oracle@flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

    Performing pre-checks for cluster services setup

    Checking node reachability...
    Node reachability check passed from node "flux-rac-node-wcdp-01"


    Checking user equivalence...
    User equivalence check passed for user "oracle"

    Checking node connectivity...

    Checking hosts config file...

    Verification of the hosts config file successful


    WARNING:
    Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

    WARNING:
    Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

    ERROR:
    PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
    Checking multicast communication...

    Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

    I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

    [oracle@flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
    WARNING:

    This system is solely for ...
    total 4
    drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle


    --
    http://www.freelists.org/webpage/oracle-l



    NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
    AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Amaral, Rui at Sep 28, 2011 at 6:53 pm
    That subnet looks odd. It is usually something like 99.99.230.0 rather than 99.99.230.128. Is there a reason for that?

    Maybe a debug on the installer might give you some more insight:

    runInstaller -debug -J-DTRACING.ENABLE =true -J-DTRACING.LEVEL=2 -J-DFULLTRAC


    Rui Amaral


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 2:29 PM
    To: oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Well, I thought I saw it work, but no, still the same error. The banner is gone though on all nodes and I've verified by "ssh ... date" from all to all and only get the date return, no banner. I even rebooted two nodes to make sure sshd was definitely working on the new sshd_config

    Other ideas?

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 10:10 AM
    To: Amaral, Rui; oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Thank you Rui, that did the trick!

    -----Original Message-----
    From: Amaral, Rui
    Sent: Wednesday, September 28, 2011 10:00 AM
    To: Walker, Jed S; oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Jed,

    From your output it looks like the banner is causing the problem.

    The section "ssh flux-rac-node-wcdp-02 ls -l /tmp" and it returns the warning. That's the first place to start.




    Rui Amaral


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: Wednesday, September 28, 2011 11:52 AM
    To: oracle-l@freelists.org
    Subject: RACnode communication problem?

    Hi,
    I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

    Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

    BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

    Here is what runcluvfy says (and runInstaller)
    (note: yes, changed the a/b on network so I don't get in trouble)

    [oracle@flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

    Performing pre-checks for cluster services setup

    Checking node reachability...
    Node reachability check passed from node "flux-rac-node-wcdp-01"


    Checking user equivalence...
    User equivalence check passed for user "oracle"

    Checking node connectivity...

    Checking hosts config file...

    Verification of the hosts config file successful


    WARNING:
    Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

    WARNING:
    Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

    ERROR:
    PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
    Checking multicast communication...

    Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

    I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

    [oracle@flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
    WARNING:

    This system is solely for ...
    total 4
    drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle


    --
    http://www.freelists.org/webpage/oracle-l



    NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
    AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • D'Hooge Freek at Sep 28, 2011 at 7:15 pm
    Jed,

    You can run the clvfy in debug mode, maybe this will show you what the problem is:

    How to Collect CVU Trace / Debug Output Generated by RUNCLUVFY.SH [ID 986822.1]

    Regards,


    Freek D'Hooge
    Uptime
    Oracle Database Administrator
    email: freek.dhooge@uptime.be
    tel +32(0)3 451 23 82
    http://www.uptime.be
    disclaimer: www.uptime.be/disclaimer

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Walker, Jed S
    Sent: woensdag 28 september 2011 20:29
    To: oracle-l@freelists.org
    Subject: RE: RACnode communication problem?

    Well, I thought I saw it work, but no, still the same error. The banner is gone though on all nodes and I've verified by "ssh ... date" from all to all and only get the date return, no banner. I even rebooted two nodes to make sure sshd was definitely working on the new sshd_config

    Other ideas?
    --
    http://www.freelists.org/webpage/oracle-l
  • Walker, Jed S at Sep 29, 2011 at 2:16 pm
    Thanks, I had verified ping worked, but I must have done it as root. Passwordless ssh was fine, per my example, but oracle didn't have perms to ping. You think they could just put that message in there.
    From: Allan Nelson
    Sent: Wednesday, September 28, 2011 7:28 PM
    To: Walker, Jed S
    Cc: oracle-l@freelists.org
    Subject: Re: RACnode communication problem?

    When you set up ssh did you set them up to be passwordless for host1 and host1.domain.com<http://host1.domain.com>. If you don't set these up I have seen cluvfy fail the way you describe.

    Alla
    On Wed, Sep 28, 2011 at 10:51 AM, Walker, Jed S wrote:
    Hi,
    I'm trying to install RAC 11.2.0 - Linux-x86-64, RedHat 5.3, oracle 11.2.0.3.0 (fyi - I also tried with 11.2.0.2.0 and got the same result)

    Has anyone seen this before, and have a solution? runcluvfy.sh and runInstaller complain that the nodes can't talk to each other, but I can ssh (passwordless) between them and oracle has even copied files from node1 to the other nodes in /tmp. I believe there is nothing wrong, but need to figure out why oracle suddenly thinks something is wrong.

    BTW, yesterday, it wasn't complaining at all, but the servers were rebooted last night. It works fine when I do things manually, but oracle doesn't seem to think it works. I'm hoping I'm either doing something "RAC newbie" or it is just a weird oracle thing

    Here is what runcluvfy says (and runInstaller)
    (note: yes, changed the a/b on network so I don't get in trouble)

    [oracle@flux-rac-node-wcdp-01 grid]$ ./runcluvfy.sh stage -pre crsinst -n flux-rac-node-wcdp-01,flux-rac-node-wcdp-02

    Performing pre-checks for cluster services setup

    Checking node reachability...
    Node reachability check passed from node "flux-rac-node-wcdp-01"


    Checking user equivalence...
    User equivalence check passed for user "oracle"

    Checking node connectivity...

    Checking hosts config file...

    Verification of the hosts config file successful


    WARNING:
    Make sure IP address "bond0 : 99.99.230.195 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-02"

    WARNING:
    Make sure IP address "bond0 : 99.99.230.194 [99.99.230.128] " is up and is a valid IP address on node "flux-rac-node-wcdp-01"

    ERROR:
    PRVF-7616 : Node connectivity failed for subnet "99.99.230.128" between "flux-rac-node-wcdp-02 - bond0 : 99.99.230.195" and "flux-rac-node-wcdp-01 - bond0 : 99.99.230.194"
    Checking multicast communication...

    Checking subnet "99.99.230.128" for multicast communication with multicast group "230.0.1.0"...

    I've checked ifconfig and everything looks fine, and here you can see I can ssh between them (and yes, I've done it both ways). Also, the runcluvfy.sh apparently is able to connect over because when I run it, node2 gets oracle files created in /tmp.

    [oracle@flux-rac-node-wcdp-02 ~]$ ssh flux-rac-node-wcdp-02 ls -l /tmp
    WARNING:

    This system is solely for ...
    total 4
    drwxr-xr-x 3 oracle dba 4096 Sep 28 15:36 CVU_11.2.0.3.0_oracle
  • Jiang, Lu at Dec 13, 2011 at 6:16 am
    Hi all,

    I am getting error ' ORA-19566: exceeded limit of 0 corrupt blocks for file ...'.
    I found out that the corrupt block is on an index. Recreated the index only moved the index out of the corrupt block.
    Now the corrupt block is associated with no object. I tried to reformat the corrupt block by inserting dummy data into this block and end up with error ' ORA-01578: ORACLE data block corrupted (file # 25, block # 157844)'.

    The corrupt block is in an index file. Is there any other option other than recover the datafile from backup? The last backup is one week old and the block corruption happened a few days ago.

    Thanks,
    Lu
  • Jiang, Lu at Dec 13, 2011 at 7:50 am
    I have fixed this issue with blockrecover command ^_^


    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Jiang, Lu
    Sent: Tuesday, December 13, 2011 1:15 AM
    To: oracle-l@freelists.org
    Subject: Block corruption on an index datafile

    Hi all,

    I am getting error ' ORA-19566: exceeded limit of 0 corrupt blocks for file ...'.
    I found out that the corrupt block is on an index. Recreated the index only moved the index out of the corrupt block.
    Now the corrupt block is associated with no object. I tried to reformat the corrupt block by inserting dummy data into this block and end up with error ' ORA-01578: ORACLE data block corrupted (file # 25, block # 157844)'.

    The corrupt block is in an index file. Is there any other option other than recover the datafile from backup? The last backup is one week old and the block corruption happened a few days ago.

    Thanks,
    Lu
    --
    http://www.freelists.org/webpage/oracle-l



    --
    http://www.freelists.org/webpage/oracle-l
  • Jared Still at Dec 15, 2011 at 4:15 pm

    On Mon, Dec 12, 2011 at 11:49 PM, Jiang, Lu wrote:
    I have fixed this issue with blockrecover command ^_^
    Nice save.

    Did it take much time to apply this?

    I used it once a few years ago - it worked fine, but IIRC it took
    quite awhile. A lot of the time could have been overhead to locate
    the file on tape, and then located the correct bit of the backup file
    (20g pieces)

    Seems like it took an hour or so.

    Fortunately it was a rarely accessed block.


    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist
    Oracle Blog: http://jkstill.blogspot.com
    Home Page: http://jaredstill.com
  • Jiang, Lu at Dec 15, 2011 at 8:32 pm
    "ܲz-m§ÿJ)ÜzØ^•«-~éem§$º›½çhØ¬“ø­¶Š$iº.·&Š{­zÏÒz{_®‰¦ÈZr@^®¼ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÅ®‰ÿ%ªÞu+b–_ã’Ëb–_à™¨¥ýÊ&ý:ÿ.ïɉ©àþ隲ɞw÷»òîü˜šž,™çÿyÛÿ Ïè­§%{ùÿ~·ž–+-³ú+ƒú+iÉ^þ_߭祊ËlþŠàý'§·ôá¸7œ×uÿ]ÿã­´×T®n7œ·ô^ührG(®»©¶*'¢v§Šw^ÅÖ­iø¥xéÌ¢ÃyÍvÿm5Õ«u×þ=<Ïɉ©àü»ÿ.ïɉ©àþ隲ɞw÷»ùšŠ[hü»ÿ&&§ƒû¦jË&yßÞvïÿº-{ò!j÷Ÿ‹¶¬ŠË.{­…¹hrJÞr‹Þ­Ê&™©Ýÿÿ͉Ǭj÷ÿ'b¶Ö¤zkœ†Ø¦zÚ¦™r¶¬ü‹¬yØ­¢wi÷°É櫱¨(þ+p¢¹uø§{öî´‚
    +m¢‰*º+^kb•ïÀ–‹h~Ø^¶)žr‹¥v¯y·žž‹Þ®švÚ%¡Æ­zØ^~)^¢{Z¥ïڝÛazyhq«^vØ^rŠëyË[ŠÚ¶›iÉ.¥ø¥{ý´‚˜žqëÿI禲X¤z+m¢‰ž.®Šì£ñh®Û§j×¥Ê+pjÆ«j·¥É§zËu¹hrOÉj·JØ¥”'«¶'âi¹^:¶œ•àÁ©Ý=ªíN)ž=êåö§éb²Ó«iÉ^Z þm§ÿÿŽK-ŠYÿnZ ²š-ýÊ&‰ž=¨þm§ÿÿªÞvËb–_Ü

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 28, '11 at 3:51p
activeDec 15, '11 at 8:32p
posts11
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase