Saturday, January 3, 2015

Precaution for adding datafile in standby environment.



Precaution for adding datafile in standby environment.
1. we have sufficient space on mount point.
2.New datafile name is unique.
3.If database is associated with standby database make sure standby file management is auto.
4And we have proper setting of db file name convert.
5.we have sufficient space on standby also.
6. After adding datafile on primary server we need to make sure it has been added on standby database also.
7.we can check this detail via report schema and v$datafile.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...

  • Lock Script
    Hii All  Today i'm posting  lock script. sometime some session block to other session. This situation is very critical because our wh...
  • IMPOTED Excel/Text File Data USING TOAD
    IMPOTED Excel/Text File Data Into Oracle Table Using TOAD Step 1 :  Open TOAD. Step 2 :  Write the following query to create a test tabl...
  • Audit - Enabling or Disabling Audit Trail
    Auditing in Oracle Database The Oracle Server provides several auditing options. The following three types of audits are provi...