FAQ
Hi All,

I am trying to simulate this .
Restore and Recovery of the Database on a New Host
however after I did this
set DBID 3782488593

on db1 on hostb

when I try to do this

rman target / nocatalog

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:02:06
2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/devel/dev02/dev10g/standbyctl.ctl'
ORA-27041: unable to open file

Linux Error: 2: No such file or directory
Additional information: 3

oracle_at_asb-dev-dgs-002:dev10g:/devel/app/oracle/product/10.2/dbs>
ls -ltr /devel/dev02/dev10g/standbyctl.ctl
ls: /devel/dev02/dev10g/standbyctl.ctl: No such file or directory

I am getting the above error . i am not able to determine where does the
rman pick up the '/devel/dev02/dev10g/standbyctl.ctl'

apprciate any suggestions.

TIA

-Prasad

Search Discussions

  • Prasad at Sep 12, 2007 at 7:27 pm
    I was able to progress after shutting down the instance

    oracle_at_asb-dev-dgs-002:dev10g:/devel/app/oracle/product/10.2/dbs>
    rman target / nocatalog

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:12:04
    2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database (not started)

    RMAN> set DBID 3782488593

    executing command: SET DBID

    RMAN> STARTUP NOMOUNT

    startup failed: ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file
    '/devel/app/oracle/product/10.2/dbs/initdev10g.ora'

    starting Oracle instance without parameter file for retrival of spfile
    Oracle instance started

    Total System Global Area 159383552 bytes

    Fixed Size 1218244 bytes
    Variable Size 58722620 bytes
    Database Buffers 92274688 bytes
    Redo Buffers 7168000 bytes
    On 9/12/07, Prasad wrote:

    Hi All,

    I am trying to simulate this .
    Restore and Recovery of the Database on a New Host
    however after I did this
    set DBID 3782488593

    on db1 on hostb

    when I try to do this

    rman target / nocatalog

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:02:06
    2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-06003: ORACLE error from target database:
    ORA-00210: cannot open the specified control file
    ORA-00202: control file: '/devel/dev02/dev10g/standbyctl.ctl'
    ORA-27041: unable to open file
    Linux Error: 2: No such file or directory
    Additional information: 3

    oracle_at_asb-dev-dgs-002:dev10g:/devel/app/oracle/product/10.2/dbs>
    ls -ltr /devel/dev02/dev10g/standbyctl.ctl
    ls: /devel/dev02/dev10g/standbyctl.ctl: No such file or directory

    I am getting the above error . i am not able to determine where does the
    rman pick up the '/devel/dev02/dev10g/standbyctl.ctl'

    apprciate any suggestions.

    TIA
    -Prasad



    --
    http://www.freelists.org/webpage/oracle-l
  • Prasad at Sep 12, 2007 at 9:15 pm
    After copying the controlfile backupset it worked fine . thanks to all.
    On 9/12/07, Prasad wrote:

    Hi Dan,

    I am now struck while doing the restore of spfile

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:12:04
    2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    connected to target database (not started)

    RMAN> set DBID 3782488593

    executing command: SET DBID

    RMAN> STARTUP NOMOUNT
    startup failed: ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file
    '/devel/app/oracle/product/10.2/dbs/initdev10g.ora'

    starting Oracle instance without parameter file for retrival of spfile
    Oracle instance started

    Total System Global Area 159383552 bytes

    Fixed Size 1218244 bytes
    Variable Size 58722620 bytes
    Database Buffers 92274688 bytes
    Redo Buffers 7168000 bytes

    RMAN> show all;

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
    default
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
    default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    RMAN> run{
    2> allocate channel c1 device type disk format '/obackup/oracle/rman/%U';
    3> restore spfile to pfile '?/dbs/initdev10g.ora' from autobackup;
    4> }

    released channel: ORA_DISK_1
    allocated channel: c1
    channel c1: sid=36 devtype=DISK

    Starting restore at 12-SEP-07

    channel c1: looking for autobackup on day: 20070912
    channel c1: looking for autobackup on day: 20070911
    channel c1: looking for autobackup on day: 20070910
    channel c1: looking for autobackup on day: 20070909
    channel c1: looking for autobackup on day: 20070908
    channel c1: looking for autobackup on day: 20070907
    channel c1: looking for autobackup on day: 20070906
    channel c1: no autobackup in 7 days found
    released channel: c1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 09/12/2007 14:16:03
    RMAN-06172: no autobackup found or specified handle is not a valid copy or
    piece


    On 9/12/07, Dan Norris wrote:

    Do a "show all;" from the RMAN> prompt and you'll see the standby
    controlfile location defined there.

    ----- Original Message ----
    From: Prasad < p4cldba_at_gmail.com>
    To: oracle-l
    Sent: Wednesday, September 12, 2007 2:19:34 PM
    Subject: RMAN-00554: initialization of internal recovery manager package
    failed

    Hi All,

    I am trying to simulate this .
    Restore and Recovery of the Database on a New Host
    however after I did this
    set DBID 3782488593

    on db1 on hostb

    when I try to do this

    rman target / nocatalog

    Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:02:06
    2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-06003: ORACLE error from target database:
    ORA-00210: cannot open the specified control file
    ORA-00202: control file: '/devel/dev02/dev10g/standbyctl.ctl'
    ORA-27041: unable to open file
    Linux Error: 2: No such file or directory
    Additional information: 3

    oracle_at_asb-dev-dgs-002:dev10g:/devel/app/oracle/product/10.2/dbs>
    ls -ltr /devel/dev02/dev10g/standbyctl.ctl
    ls: /devel/dev02/dev10g/standbyctl.ctl: No such file or directory

    I am getting the above error . i am not able to determine where does the
    rman pick up the '/devel/dev02/dev10g/standbyctl.ctl'

    apprciate any suggestions.

    TIA

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 12, '07 at 7:19p
activeSep 12, '07 at 9:15p
posts3
users1
websiteoracle.com

1 user in discussion

Prasad: 3 posts

People

Translate

site design / logo © 2022 Grokbase