There are numarous ways to create physical standby from running standbydb, but here i am giving easiest way to build StandbyDb:
- OS and Oracle version should be same as current physical standby.
- At OS level create same mount points as in other.
- Create Pfile and SPfile with convenience to newly created standbydb.
- Copy coldbackup from current standbydb to newly created standby.
- Create/Recreate Passowrd file, OR copy Password file (initdbname) to newly created standbydb.
- startup mount;
- Run Recovery.
Thats it!
:)
Regards
Mohsin Ali
mohsin.uetion@gmail.com
No comments:
Post a Comment