Tag Info

New answers tagged

0

you need to make sure the ownership and privileges are correct for the directory, you can use the following commands to set it right: chown -R mysql:mysql /var/lib/mysql/ --your mysql user may have different name, if its different you need to change it [mysql:mysql] as needed chmod -R 755 /var/lib/mysql/ note: -R: recursive fir the directory and all its ...


1

There are couple of things to note here. The database will only be accessible by query seamlessly and would allow connection if all three phases of recovery has completed. The three phases are analysis, redo and Undo(sometimes if DB is in consistent state after redo an UNDO phase would not be required). In enterprise edition the database would come online ...


1

I Thought that I can change the DatabaseLS_Main from Standby mode to bring it online, take the snapshot and bring it back to STANDBY mode...is it right to do ? What you are telling is not possible using logshipping. There are limitations of database snapshot In a log shipping configuration, database snapshots can be created only on the primary ...



Top 50 recent answers are included