RE: standby on standard edition without rman
- From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Wed, 19 Jun 2013 11:45:26 -0400
I got it. Thanks, that db_unique_name was it. Once I did that it told me it
wasn't a standby controlfile and so I new to replace mine with the standby and
it mounted.
P.S I don't believe my messages are making it to the list.
If this one does not, can you let them know - and credit Stephan Uzzell.
Thx
Joel Patterson
Database Administrator
904 928-2790
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Wednesday, June 19, 2013 11:37 AM
To: Patterson, Joel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: standby on standard edition without rman
I am trying to recall this, but I think you just do an alter database mount.
Since this is a manual standby, I dont think it understands the standby term.
In effect you will just have a clone of your primary database in manual.
On Wed, Jun 19, 2013 at 10:24 AM, Patterson, Joel
<jpatterson@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx>> wrote:
I am referencing:
http://hemora.blogspot.com/2011/04/manual-standby-database-under-standard.html
Version 11g, so some parameters have been deprecated.
Not doing anything with standby control file, I get this upon mounting.
SYS AS SYSDBA @ radbdr> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01103: database name 'RADB' in control file is not 'RADBDR'
Joel Patterson
Database Administrator
904 928-2790<tel:904%20928-2790>
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790<tel:904-928-2790> | Fax: 904-733-4916<tel:904-733-4916>
http://www.entint.com/
http://www.entint.com/
http://www.facebook.com/pages/Enterprise-Integration/212351215444231
http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah
http://www.youtube.com/user/ValueofIT
This message (and any associated files) is intended only for the use
of the addressee and may contain information that is confidential,
subject to copyright or constitutes a trade secret. If you are not the
intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message, or files associated with this
message, is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and
deleting it from your computer. Messages sent to and from us may be
monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of Patterson, Joel
Sent: Wednesday, June 19, 2013 11:07 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: standby on standard edition without rman
I have hit an air pocket with the steps in creating a standby old school. A
bit embarrassing but I'm also under time preasure. I create the standby
control file on the primary and bring it over... but what do I do with it then.
I have googled, but it must be so obvious that I'm missing it. Data Guard is
not available in Standard Edition.
Joel Patterson
Senior Oracle Database Administrator
jpatterson@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx><mailto:jpatterson@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx>>
Office: 904 928-2790<tel:904%20928-2790>
Enterprise Integration Corporation /
www.entint.com<http://www.entint.com><http://www.entint.com/>
7601 Centurion Parkway | Jacksonville, FL 32256
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790<tel:904-928-2790> | Fax: 904-733-4916<tel:904-733-4916>
www.entint.com<http://www.entint.com><http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>
[http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg]
<http://twitter.com/#!/entint>
[http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg]
<http://www.linkedin.com/company/18276?trk=tyah>
[http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg]
<http://www.youtube.com/user/ValueofIT>
This message (and any associated files) is intended only for the use of the
addressee and may contain information that is confidential, subject to
copyright or constitutes a trade secret. If you are not the intended recipient,
you are hereby notified that any dissemination, copying or distribution of this
message, or files associated with this message, is strictly prohibited. If you
have received this message in error, please notify us immediately by replying
to the message and deleting it from your computer. Messages sent to and from us
may be monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916
www.entint.com<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>
[http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg]
<http://twitter.com/#!/entint>
[http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg]
<http://www.linkedin.com/company/18276?trk=tyah>
[http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg]
<http://www.youtube.com/user/ValueofIT>
This message (and any associated files) is intended only for the use
of the addressee and may contain information that is confidential,
subject to copyright or constitutes a trade secret. If you are not the
intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message, or files associated with this
message, is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and
deleting it from your computer. Messages sent to and from us may be
monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]
--
//www.freelists.org/webpage/oracle-l
Other related posts:
