dbaStreet

Date and Time Arithmetic in the bash shell

Here are some ways to add hours, days, months etc to a given date and get the result from the bash shell To add seconds to a given date rramads@rramads-us2:~$ date -d “2010-08-12 05:30:30 PM 15 seconds” Thu Aug 12 17:30:45 EDT 2010 To add minutes to a given date in the bash shell you [...]

Transportable Tablespace from rman backup

Most of oracle’s MAA documentation for transportable tablespaces, seems to recommend that one should put the tablespaces one is transporting, in read-only mode in the source database, before copying the datafiles to the target. This in most cases means application downtime. In order to minimize the downtime the recommendations seem to be Create a dataguard [...]