Database With SanGa

STANDBY LOGS Get relevant details from primary side SQL> select GROUP#,BLOCKSIZE,THREAD# from v$standby_log;     GROUP#  BLOCKSIZE    THREAD# ---------- ---------- ----------          9        512          1         10        512          1         11        512          1         12        512          1         13        512          1         14        512          2         15        512          2         16        512          2   ...

Install the following packages if they are not already present. yum install binutils-2*x86_64* yum install glibc-2*x86_64* nss-softokn-freebl-3*x86_64* yum install glibc-2*i686* nss-softokn-freebl-3*i686* yum install compat-libstdc++-33*x86_64* yum install glibc-common-2*x86_64* yum install glibc-devel-2*x86_64* yum install glibc-devel-2*i686* yum install glibc-headers-2*x86_64* yum install elfutils-libelf-0*x86_64* yum install elfutils-libelf-devel-0*x86_64* yum install gcc-4*x86_64* yum install gcc-c++-4*x86_64* yum install ksh-*x86_64* yum install libaio-0*x86_64* yum install libaio-devel-0*x86_64* yum install libaio-0*i686* yum install libaio-devel-0*i686* yum install libgcc-4*x86_64* yum install libgcc-4*i686* yum install libstdc++-4*x86_64* yum install libstdc++-4*i686* yum install libstdc++-devel-4*x86_64* yum install make-3.81*x86_64* yum install numactl-devel-2*x86_64* yum install sysstat-9*x86_64* yum install compat-libstdc++-33*i686* yum install compat-libcap*

WARNING: File being created with same name as in Primary Existing file may be overwritten Errors in file /home/oradata/DB/DB_pr00_12979.trc: ORA-01119: error in creating database file '/home/oracle/oradata/data_TS_FNO-62' ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Linux-x86_64 Error: 13: Permission denied File #64 added to control file as 'UNNAMED00064'. Originally created as:'/home/oracle/oradata/data_TS_FNO-62' Recovery was unable to create the file as:'/home/oracle/oradata/data_TS_FNO-62' MRP0: Background Media Recovery terminated with error 1274 Errors in file /home/oradata/DB/DB_pr00_12979.trc: ORA-01274: cannot add datafile '/home/oracle/oradata/data_TS_FNO-62' - file could not be created Managed Standby Recovery not using Real Time Apply SOLUTION: alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00064' as '/home/oracle/oradata/data_TS_FNO...

The following packages are listed as required, including the 32-bit version of some of the packages.  # OL6 and OL7 (RHEL6 and RHEL7) yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libXi -y yum install libXi.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install make -y yum install nfs-utils -y yum install net-tools -y yum install ...

On the primary database, create the control file for the standby database, as shown in the following example: SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/stby.ctl'; Note: You cannot use a single control file for both the primary and standby databases. The filename for the newly created standby control file must be different from the filename of the current control file of the primary database.  The control file must also be created after the last time stamp for the backup datafiles.

In PostgreSQL, there is a system table called  pg_user . You can run a query and get the information about these Users. SELECT * FROM pg_user; The  pg_user  table contains the following columns: Column Explanation usename User name (ie: postgres, techonthenet, etc) usesysid User ID (number assigned by PostgreSQL) usecreatedb Boolean value indicating whether user can create databases (t or f) usesuper Boolean value indicating whether user is a superuser (t or f) usecatupd Boolean value indicating whether user can update system catalogs (t or f) userepl Boolean value indicating whether user can initiate replication (t or f) passwd Password for user displayed as ******** valuntil Time when password will expire useconfig Session defaults for run-time configuration variables

ALTER USER changes the attributes of a PostgreSQL user account.  Examples 1.Change a user's password:   ALTER USER davide WITH PASSWORD 'hu8jmn3'; 2.Change the expiration date of the user's password:   ALTER USER manuel VALID UNTIL 'Jan 31 2030'; 3.Change a password expiration date, specifying that the password        should expire at midday on 4th May 2005 using the time zone which is    one hour ahead of UTC:    ALTER USER chris VALID UNTIL 'May 4 12:00:00 2005 +1'; 4.Make a password valid forever:   ALTER USER fred VALID UNTIL 'infinity'; 5.Give a user the ability to create other users and new databases:   ALTER USER miriam CREATEUSER CREATEDB;