MARTINMEYER.BLOGSPOT.COM

Thinus Meyer's DBA adventures

Thinus Meyer's DBA adventures. Tuesday, November 26, 2013. Recover after a failed switchover. A failed swithcover attempt left both databases with a DATABASE ROLE=PHYSICAL STANDBY. Steps I followed to recover from the failure and to change the old PRIMARY back to PRIMARY was as follows:. ORA-01092: ORACLE instance terminated. Disconnection forced. Login to sqlplus again as sysdba and do a startup mount. Total System Global Area 6.8947E 10 bytes. Fixed Size 2189520 bytes. Variable Size 2.0670E 10 bytes.

http://martinmeyer.blogspot.com/

OVERVIEW OF martinmeyer.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR MARTINMEYER.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.3 out of 5 with 8 reviews

5 star

3

4 star

0

3 star

3

2 star

0

1 star

2

Hey there! Start your review of martinmeyer.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT MARTINMEYER.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

23

SITE IP

172.217.12.161

LOAD TIME

0.31 sec

SCORE

6.2

PAGE TITLE

Thinus Meyer's DBA adventures | martinmeyer.blogspot.com Reviews

<META> DESCRIPTION

Thinus Meyer's DBA adventures. Tuesday, November 26, 2013. Recover after a failed switchover. A failed swithcover attempt left both databases with a DATABASE ROLE=PHYSICAL STANDBY. Steps I followed to recover from the failure and to change the old PRIMARY back to PRIMARY was as follows:. ORA-01092: ORACLE instance terminated. Disconnection forced. Login to sqlplus again as sysdba and do a startup mount. Total System Global Area 6.8947E 10 bytes. Fixed Size 2189520 bytes. Variable Size 2.0670E 10 bytes.

<META> KEYWORDS

1 sql shutdown immediate

2 startup mount

3 oracle instance started

4 database mounted

5 open the database

6 confirm database role

7 posted by

8 thinus meyer

9 no comments

10 email this

CONTENT

Page content here

KEYWORDS ON PAGE

sql shutdown immediate,startup mount,oracle instance started,database mounted,open the database,confirm database role,posted by,thinus meyer,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels data guard,1 clearing

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Thinus Meyer's DBA adventures | martinmeyer.blogspot.com Reviews

https://martinmeyer.blogspot.com

Thinus Meyer's DBA adventures. Tuesday, November 26, 2013. Recover after a failed switchover. A failed swithcover attempt left both databases with a DATABASE ROLE=PHYSICAL STANDBY. Steps I followed to recover from the failure and to change the old PRIMARY back to PRIMARY was as follows:. ORA-01092: ORACLE instance terminated. Disconnection forced. Login to sqlplus again as sysdba and do a startup mount. Total System Global Area 6.8947E 10 bytes. Fixed Size 2189520 bytes. Variable Size 2.0670E 10 bytes.

INTERNAL PAGES

martinmeyer.blogspot.com

1

Thinus Meyer's DBA adventures: December 2008

http://martinmeyer.blogspot.com/2008_12_01_archive.html

Thinus Meyer's DBA adventures. Tuesday, December 23, 2008. Problem setting up Archive Log file management on ASM. I created a ASM diskgroup for FRA and set the relevant parameters. The aim to to write Archive logs, Flashback logs and RMAN backups to this FRA. SQL select FREE MB from v$asm diskgroup where NAME='PRNADGF';. SQL show parameter db recovery file. Db recovery file dest string. Db recovery file dest size big integer 0. SQL alter system set db recovery file dest size=2700000M;. ERROR at line 1:.

2

Thinus Meyer's DBA adventures: Resolving Gaps in Data Guard Apply Using Incremental RMAN Backup

http://martinmeyer.blogspot.com/2012/01/resolving-gaps-in-data-guard-apply.html

Thinus Meyer's DBA adventures. Thursday, January 26, 2012. Resolving Gaps in Data Guard Apply Using Incremental RMAN Backup. I found quite a few blog entries on the web and off course the Oracle Documentation also helped. The reason I want to create a post is that I encountered 2 problems that I first had to overcome before the Physical Standby was in sync again. A sort overview of the problem and the steps to overcome them are:. SQL select current scn FROM V$DATABASE;. I restarted the RMAN backup, it di...

3

Thinus Meyer's DBA adventures: March 2011

http://martinmeyer.blogspot.com/2011_03_01_archive.html

Thinus Meyer's DBA adventures. Tuesday, March 8, 2011. ACCOUNT STATUS = EXPIRED(GRACE). Users are identified within the app, so all DB connections are done through 1 schema. We created a profile for this schema where the password will never expire. App support has a manual process to change the password every 60 days, but Oracle must never be allowed to expire the password automatically. SQL select USERNAME, PROFILE, ACCOUNT STATUS from dba users where username = ‘QWERTY’. So even though the profile was ...

4

Thinus Meyer's DBA adventures: January 2012

http://martinmeyer.blogspot.com/2012_01_01_archive.html

Thinus Meyer's DBA adventures. Thursday, January 26, 2012. Resolving Gaps in Data Guard Apply Using Incremental RMAN Backup. I found quite a few blog entries on the web and off course the Oracle Documentation also helped. The reason I want to create a post is that I encountered 2 problems that I first had to overcome before the Physical Standby was in sync again. A sort overview of the problem and the steps to overcome them are:. SQL select current scn FROM V$DATABASE;. I restarted the RMAN backup, it di...

5

Thinus Meyer's DBA adventures: DB link from Oracle to SQL Server

http://martinmeyer.blogspot.com/2012/01/db-link-from-oracle-to-sql-server.html

Thinus Meyer's DBA adventures. Thursday, January 26, 2012. DB link from Oracle to SQL Server. We had a need for a DB link from an Oracle database to a SQL Server database. I initially feared that this might be a huge task, but it turned out to be quite a easy setup. Thanks Oracle for making it almost. There are basically 4 steps involved. Nstall and configure the Gateway. After installation you will find a new directory in ORACLE HOME called dg4msql. HS FDS CONNECT INFO=[server name]:port/ mssql db.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

aiiriigz.wordpress.com

Adding additional drivers to the VMware Converter Cold Clone ISO | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2010/02/26/adding-additional-drivers-to-the-vmware-converter-cold-clone-iso

Just another WordPress.com site. Resolve – “KERNEL PANIC – NOT SYNCING”. ORA-00600: 内部错误代码, 参数: [# of sumkeys invalid] →. Adding additional drivers to the VMware Converter Cold Clone ISO. February 26, 2010. 用VMware-convertercd-4.0.3-u4启动一台dell powerEdge 1955 blade服务器, 提示无法找到系统，应该是无法识别raid卡, 在dell网站上下载了SAS 5/iR的driver, 按如下方法集成到converterCD上，启动终于发现系统并顺利进行迁移. Adding additional drivers to the VMware Converter Cold Clone ISO. This article details adding additional drivers to the VMware Converter Cold Clone ISO.

aiiriigz.wordpress.com

Aiiriigz's Blog | Just another WordPress.com site | Page 2

https://aiiriigz.wordpress.com/page/2

Just another WordPress.com site. Newer posts →. 11gRac archive log to asm diskgroup. November 7, 2012. Oracle 11g rac 设置归档，并保存到asm磁盘组. Root@dbrac5 ]# su – grid. Grid@dbrac5 ]$ sqlplus “/ as sysdba”. SQL select name,total mb,free mb from v$asm diskgroup;. NAME TOTAL MB FREE MB. 8212;————————— ———- ———-. SQL alter diskgroup flash add directory ‘ FLASH/arc1’. SQL alter diskgroup flash add directory ‘ FLASH/arc2’. Root@dbrac5 ]# su – oracle. Oracle@dbrac5 ]$ sqlplus “/ as sysdba”. SQL archive log list;.

aiiriigz.wordpress.com

凤凰张家界之游-寄给未来的自己 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/11/07/凤凰张家界之游-寄给未来的自己

Just another WordPress.com site. Zt]expect spawn、linux expect 用法小记 →. November 7, 2012. 公司组织了员工旅游，有两条路线，一条是桂林阳朔游，另外一条是凤凰张家界我选择了后者组织路线照样是不那么令人满意，很多可以优化的地方，不过，总体来说还是过得挺开心的现在没什么机会可以完全放松，不想工作，不上网，没有负担的过日子，就算是平时的五一，十一长假照样是天天收邮件，并没那么轻松. 出发前一天晚上，一个同事离职，部门聚餐，喝了一些酒，有点醉基本没什么准备了解就出发了除了知道是要去凤凰，并不知道具体的路线，以及究竟有哪些人一起之前担心一路太闷，下载了一堆电子书到手机，其实行程中一个字也没看. 到达长沙，气比想象中的冷，下着雨第一天的午餐很普通，但导游说是这几天最好的一餐了，搞得大家的期望值都很低下午转汽车，同事打牌，我则在用手机玩三国杀，睡觉幸亏有同事提醒买了个环形枕头，脖子枕着靠着座椅，才比较舒服玩了两个多小时，手机没电了，后悔忘记带多一块电池晚上6点多车子坏了，幸亏修理一会又可继续前进. 第三天早上，本来...

aiiriigz.wordpress.com

aiiriigz | Aiiriigz's Blog

https://aiiriigz.wordpress.com/author/aiiriigz

Just another WordPress.com site. Zt]expect spawn、linux expect 用法小记. November 7, 2012. From: http:/ www.uplook.cn/index-Index-show-view16935.html. 脚本代码如下 # # # # # # # # # # # # # # # # # # # # # # # #! Usr/bin/expect set timeout 30 spawn ssh -l username 192.168.1.1 expect “password:” send “ispass r” interact # # # # # # # # # # # # # # # # # # # # # # # 1. #! 所以不要用 which spawn 之类的命令去找spawn命令。好比windows里的dir就是一个内部命令，这个命令由shell自带，你无法找到一个dir.com 或 … Continue reading →. November 7, 2012. 公司组织了员工旅游，有两条路线，一条是桂...

aiiriigz.wordpress.com

[zt]ntpd ntpdate时间同步 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/11/07/ztntpd-ntpdate时间同步

Just another WordPress.com site. November 7, 2012. Http:/ blog.sina.com.cn/s/blog 3f3422fd0100f06c.html. Usr/sbin/ntpdate -B tiger.sina.com.cn. Http:/ study.chyangwa.com/IT/AIX/aixcmds4/ntpdate.htm. 通过轮询指定的确定正确时间的 NTP 服务器， ntpdate 命令设置本地日期和时间。如果它确定时钟偏差超过 0.5 秒，它通过调用 settimeofday 子例程设置时钟时间。如果它确定时钟偏差小于 0.5 秒，它通过调用 adjtime 子例程和偏移量来调整时钟时间。当不是通过运行一个守护程序而是从 cron 命令有规则的运行 ntpdate 命令时，每一小时或两小时执行一次可以保证足够的走时精度，从而避免调整时钟。如果一个类似 xntpd 守护程序的 NTP 服务器守护程序正在同一主机上运行，命令将拒绝 ntpdate 设置日期。 Server ntp1.alibaba.com. Second ...

aiiriigz.wordpress.com

神奇的灵谕 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2009/04/03/神奇的灵谕

Just another WordPress.com site. April 3, 2009. Life is Like a Boat. This entry was posted in life. April 9, 2009 at 3:50 am. June 29, 2013 at 11:33 pm. It’s not my first time to go to see this website, i am visiting this site dailly and take good data from here all the time. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. On 很强大，手动Live Messenger 去广告.

aiiriigz.wordpress.com

November | 2012 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/11

Just another WordPress.com site. Monthly Archives: November 2012. Zt]expect spawn、linux expect 用法小记. November 7, 2012. From: http:/ www.uplook.cn/index-Index-show-view16935.html. 脚本代码如下 # # # # # # # # # # # # # # # # # # # # # # # #! Usr/bin/expect set timeout 30 spawn ssh -l username 192.168.1.1 expect “password:” send “ispass r” interact # # # # # # # # # # # # # # # # # # # # # # # 1. #! 所以不要用 which spawn 之类的命令去找spawn命令。 November 7, 2012. 公司组织了员工旅游，有两条路线，一条是桂林阳朔游，另外一条是凤凰张家界我选择了后者组织路线照样是不那么令人满意，很多可以...

aiiriigz.wordpress.com

linux-记录远程登录IP及操作记录 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/11/07/linux-记录远程登录ip及操作记录

Just another WordPress.com site. 11gR2 rac修改ocr,voting disk到不同的diskgroup. Zt]bash profile和.bashrc的什么区别 →. November 7, 2012. 测试环境 RHEL 5.6 bash. Linux 下可以用 w 来查看当前登录用户信息如果是SSH登录，也可查看 $SSH CLIENT 得到登录用户信息，但如果是FTP等方式，则无法得到需要的信息. 但用 w 有个问题，如果是同个用户登录，则有多条信息，如果区分是个问题最后解决方法如下. W tail -n 3 awk ‘BEGIN {ip=”local”}{if ($5= ”0.00s” $3! 8220;-“) ip=$3 fi} END {print ip}’. 8220;-“) ip=$3 fi} END {print ip}’`.log. This entry was posted in Uncategorized. And tagged linux remote login log. Leave a Reply Cancel reply.

aiiriigz.wordpress.com

[zt].bash_profile和.bashrc的什么区别 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/11/07/zt-bash_profile和-bashrc的什么区别

Just another WordPress.com site. Zt]ntpd ntpdate时间同步 →. November 7, 2012. From: http:/ xu20cn.blog.51cto.com/274020/304343. 为每一个运行bash shell的用户执行此文件.当bash shell被打开时,该文件被读取. 默认情况下,他设置一些环境变量,执行用户的.bashrc文件. 该文件包含专用于你的bash shell的bash信息,当登录时以及每次打开新的shell时,该. 另外,/etc/profile中设定的变量(全局)的可以作用于任何用户,而 /.bashrc等中设定的变量(局部)只能继承/etc/profile中的变量,他们是”父子”关系. Bash profile 是交互式、login 方式进入 bash 运行的. Bashrc 是交互式 non-login 方式进入 bash 运行的. 执行的顺序为 /.bash profile、 /.bash login、 /.profile。 If [ -f /.bashrc ] ; then. You are commen...

aiiriigz.wordpress.com

February | 2012 | Aiiriigz's Blog

https://aiiriigz.wordpress.com/2012/02

Just another WordPress.com site. Monthly Archives: February 2012. February 6, 2012. 6月份，BB来到这个世上，过程很戏剧化,这是一段很奇妙体验的人生之旅开始是毫无计划的，所以，估计拖到第三个月才发现并确定有了然后才开始吃那些维生素保健药什么，开始去产检我也从毫无准备的惊愕，半信半疑，到接受，到认真准备，到事事操劳开始的时候，看着老婆的肚子一天天隆起变大，有时摸着老婆的大肚子，某个部位就会隆起来，会猜这是小孩的那个部分是脚或者是屁股 B超的时候，医生不告诉我们是男是女，不过，小孩是面向里面的，记得好友康爷说过，向里的就是男的，因为女生外向，我也是半信半疑，抱着男女都好的态度，反而老婆开始就很自信的说直觉一定是男的，我还暗笑 BB的到来，改变了很多，最直接明显的就是化解了原来夫妻两人间的矛盾重重，突然大家变得很和谐，向着共同目标前进，开始进入结婚的流程选择产检以及生产的医院，可以选择在家附近的一般的医院，也可以选择远一点的专业妇幼医院，老婆坚持要去妇幼，路途遥远，排队的人又超多，每次都要一大早六点多就出...

UPGRADE TO PREMIUM TO VIEW 13 MORE

TOTAL LINKS TO THIS WEBSITE

23

OTHER SITES

martinmews.com

martin mews

01 MLK JR WAY AND CHERRY. 30' X 120' LOT.

martinmey.bandcamp.com

Martin Mey

Or browse results titled. 1 & (pageBandParentLabel() pageLabel() , col1: columns() = = 1, col2: columns() = = 2, col3: columns() = = 3 } ". 0 }" Other Linked Artists/Labels. Edit artists. add more artists. Please verify your email by clicking the link we sent to . Change email / Send again. Out Of My Loops. Digisleeve 3 volets, carton retourné. Commandez lalbum dans ce bel emballage cartonné, orné dun artwork conçu par Waïdizaïn. La version numérique vous sera offerte immédiatement! Out Of My Loops.

martinmeyenburg.de

Martin Meyenburg

View: No Place Like Home Photo: Cyrille Robin. 2 Juni: No Place Like Home Galerie Laurent Müller. 15 - 17. Juni: le trac Frontviews Gallery.

martinmeyer-safaris.com

African Travel Specialists | Martin Meyer Safaris

27 (82) 576 7002. 8212; Main Menu —. Food & Wine Safaris. Food & Wine Safaris. The ultimate safari experience. Explore the waterways of Africa. Experience the African bush on foot. A romantic African safari. Food and Wine Safaris. Eat the best food you've ever had in your life and sample fantastic wines. Relax and unwind on Lake Malawi's shores, it's certainly one of Africa's gems. Mozambique's picturesque beaches and pristine reefs are some of the loveliest in all of Africa. Our reputation has been buil...

martinmeyer.biz

Website temporarily unavailable

Die von Ihnen gewünschte Seite ist temporär nicht erreichbar. Wenn Sie der Betreiber der Website sind, kontaktieren Sie uns bitte unter Angabe Ihrer Accountdaten:. Https:/ www.hosteurope.ch/unternehmen/kontakt/. Host Europe Suisse AG · D4 Platz 4 · CH-6039 Root.

martinmeyer.blogspot.com

Thinus Meyer's DBA adventures

Thinus Meyer's DBA adventures. Tuesday, November 26, 2013. Recover after a failed switchover. A failed swithcover attempt left both databases with a DATABASE ROLE=PHYSICAL STANDBY. Steps I followed to recover from the failure and to change the old PRIMARY back to PRIMARY was as follows:. ORA-01092: ORACLE instance terminated. Disconnection forced. Login to sqlplus again as sysdba and do a startup mount. Total System Global Area 6.8947E 10 bytes. Fixed Size 2189520 bytes. Variable Size 2.0670E 10 bytes.

martinmeyer.ch

martin meyer | private webspace

martinmeyer.com

Temporarily Disabled

martinmeyer.de

Homepage Martin Meyer

Dies ist die Homepage von:. Photografien aus verschiedenen Ländern. Sammlung alter Homecomputer (Apple, Atari, Commodore .).

martinmeyer.info

MARTIN MEYER :: FOTOGRAFIE ::

martinmeyer.net

Test Default page

If you are seeing this message, the website for is not available at this time. If you are the owner of this website, one of the following things may be occurring:. You have not put any content on your website. Your provider has suspended this page. Please login to to receive instructions on setting up your website. This website was created using our Parallels Plesk product. We offer a full line of Billing, Sitebuilder and cloud computing tools. Please visit www.parallels.com. To find out more information.