Quote:
Originally Posted by
filosophizer
1) What is the fastest way to copy or mirror it to another filesystem without shutting down production vg ( oracle is using the filesystem )
I suppose that the mirrorlv soution will be on of the fastest methods and probably the one with the least hassle. I would, being in your place, prefer to go for this solution.
In case this is not possible for whatever reason, here is a suggestion, you will have to fill in some blanks. It assumes that there is (almost) nothing else than the DB-files on the filesystem.
1. Set the database into "hot backup" mode. I don't know exactly how this is done, but every Oracle DBA knows for sure what I'm talking about. Basically this is making the database aware that a file-backup is taken while it is running. The file-backup as such will be considered inconsistent but along with the archive logs taken during the backup it can be made consistent. Oracle has special provisions for doing exactly this built in.
Note that the redo-logs created this way contain more info than normal redo-logs and the rate of logswitches will increase. Your DBA should be able to estimate how big the factor of the increase will be.
2. Take a file-backup from the running database. You can use whatever system means there are: TSM, tar, cp , ....
3. After the backup has finished rotate out the active redo-logs and set the database to normal again.
4. After restoring the copy to some other diskspace start the database and make it consistent by applying the archive-logs taken since the start of the backup-process. The DB then is consistent and equal to the original at the time of the end of the backup process.