Sunday, December 7, 2014

Create Standby from standby DB

There are numarous ways to create physical standby from running standbydb, but here i am giving easiest way to build StandbyDb:

  1. OS and Oracle version should be same as current physical standby.
  2. At OS level create same mount points  as in other.
  3. Create Pfile and SPfile with convenience to newly created standbydb.
  4. Copy  coldbackup from current standbydb to newly created standby.
  5. Create/Recreate Passowrd file, OR copy Password file (initdbname) to newly created standbydb.
  6. startup mount;
  7. Run Recovery.

Thats it! 
:)
Regards
Mohsin Ali
mohsin.uetion@gmail.com

No comments:

Post a Comment