Tag Info

New answers tagged

-1

I'm afraid there is no way how to do that, archivelogs are a must. Best approach is to use approach recomended by the vendor. Datafiles might be inconsistent anytime, Oracle writes changes into blocks even before the transaction is commited. The only place where you can find an information needed to have data consistent is in (archived) redo-logs. Oracle ...


0

it is failing because snapshot agent is generating a bcp file that does NOT contain that extra column, when it runs against Publisher B. Distribution agent is trying to apply a bcp file that has one less column into the subscriber table. I think what you want to do it initialize without a snapshot. I don't know if that is supported for Oracle publisher ...


0

on Amazon system you can use following steps to setup replication for MySQL Choose a low/off production window Note Master co-ordinate using show master status You may consider using flush tables with read-lock, just to make sure you are sure that your co-ordinates doesn't change while you are creating snap shot take snap shot and restore Change server-id ...


0

I would advise you to drop mysqldump and move to Percona Xtrabackup. It will give you a filesystem level backup that can be made online. Restoring those backups will be orders of magnitude faster.


3

My understanding of a rebuild index online operation is that the index will have a snapshot taken and the rebuild is started on the snapshot index. Incorrect. An unfortunate overload of the term 'snapshot'... A snapshot read of the index is used, which means row-versioning see How Online Index Operations Work: A snapshot of the table is defined. ...


1

My understanding is the snapshot should reside on the index file drive. Is this correct? It resides on same file where Index file resides unless you use Sort_in_tempdb option during rebuild. From BOL When SORT_IN_TEMPDB is set to OFF, the default, the sort runs are stored in the destination filegroup. If the SORT_IN_TEMPDB option is set to ...



Top 50 recent answers are included