Re: Start slave fails
Thanks Rick. It appears that the only safe way to setup replication is to shutdown the master database completely and take a "cold backup" for the slave.
However, how would this method work in mission critical 24x7 databases? By the way, my backup script does 'FLUSH TABLES WITH READ LOCK;' before taking the backup. So, does this guarantee a consistent snapshot of the database? If yes, then my earlier problem of replication is still a mystery. If not, I will have to shutdown my production database to setup replication.
Subject
Views
Written By
Posted
3539
March 23, 2010 06:51PM
1508
March 24, 2010 09:10AM
1684
March 24, 2010 05:40PM
1370
March 26, 2010 11:26PM
1478
March 27, 2010 05:19AM
1367
March 27, 2010 10:04AM
Re: Start slave fails
1609
March 27, 2010 05:00PM
1443
March 27, 2010 09:35PM
1347
March 28, 2010 05:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.