on 03-05-2014 8:18 AM
Hi,
We have an ERP system running on HP-UX with Oracle database.
To stick with SAP recommendation, the filesystems holding the datafiles should have a blocksize of 8192K. We have 5 filesystem of 2 TB for the datafiles of the production system, and 3 have a blocksize of 1024k instead of 8192k.
The safest strategy would be to:
- Stop SAP and DB
- Copy the datafiles of these 3 filesystems to 3 new filesystem with a blocksize of 8192K
- Adapt the mount points
- Restart the DB and SAP
The problem with this strategy is that it is very time consuming, and will need a long downtime to complete it.
We have another strategy in mind:
- Putting the database in backup mode
- Copying all the datafiles (for the 5 filesystems) to new filesystems
- Putting the database back in normal mode
- Stopping SAP and the DB
- Changing the mounting points to the new filesystems
- Starting up the database and recover it (applying all the logs)
- Starting SAP
This should help us reducing the downtime.
Can you advise if it is a valid strategy ? Do you have any other idea on how we could proceed ?
Thanks in advance for your help 🙂
Antoine
Hi Antoine,
well from a technical point of view this is valid, but to be honest it is slow as well and it includes many manual error-prone activities. Nowadays there is no reason for not using RMAN
The fastest and safest method (in my opinion) would be the following:
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
This will work provided you apply all the archived logs and open the database with resetlogs option.
What about restoring the database from the backup ? does the restore take a lot of time than the manual copy. If not then that would be the best.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Antoine,
Refer link for steps http://www.orafaq.com/wiki/Move_datafile_to_different_location
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
From my understanding, if you put a datafile offline, you can't access it anymore until you put it online again. So, the database is not fully available again, and then also SAP.
If you try to move a datafile with BRTOOLS, it will shutdown the database.
But we could indeed use this method to move different datafiles of one filesystem at different moments.
Regards,
Antoine
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.