Posted by Mir Sayeed Hassan on October 4th, 2017
Configure RMAN backup using crontab
[oracle@localhost ~]$ crontab -l
##############################################################
#Script Used To Create Hourly Exports Of prm database Schemas_Synaps
###############################################################
00 20 * * 0-7 /backup/Daily_Schema_dump/dumpfile.sh testdb >/dev/null
#################################
#RMAN...
Read more..
Posted in RMAN | Comments Off on Configure RMAN backup using crontab
Posted by Mir Sayeed Hassan on October 4th, 2017
Installation of RAC by using VM – Step by Step Procedure
Install by using the 2 virtual machine
-
Create the 2 VM with Oracle Linux 6.7 Installation
-
Create the HDD & Shared by 2 VM — (Network team handle this step)
Oracle Installation Prerequisites on NODE 1 & Setup as fallows
Posted in RAC | Comments Off on Installation of RAC by using VM – Step by Step Procedure
Posted by Mir Sayeed Hassan on October 4th, 2017
Find the Quick General query as per your requirement
Find the status of the database
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> select database_status from v$instance;
DATABASE_STATUS
-----------------
ACTIVE
Posted in MISCELLANEOUS | Comments Off on Find the Quick General query as per your requirement
Posted by Mir Sayeed Hassan on October 3rd, 2017
Manually generating the AWR Report in oracle database
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql;
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
4187434325 TESTDB 1 testdb
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would...
Read more..
Posted in DBA Administration | Comments Off on Manually generate AWR Report in oracle database
Posted by Mir Sayeed Hassan on October 3rd, 2017
Change the existing DB Name to New DB NAME (SID)
Before performing the below operation, safer side to take a full backup of the database using rman or dumpfile (expdp)
Check the existing database name
SQL> SELECT DBID,NAME,open_mode from v$database;
DBID NAME OPEN_MODE
--------- ---------...
Read more..
Posted in DBA Administration | Comments Off on Change the existing DB Name to New DB NAME (SID)
Posted by Mir Sayeed Hassan on October 3rd, 2017
Restrict a schema to drop a table from its own
SQL> sho user
USER is "SYS"
SQL> create user mir identified by mir;
User created.
SQL> grant connect,resource to mir;
Grant succeeded.
SQL> connect mir/mir;
Connected.
SQL> create table...
Read more..
Posted in DBA Administration | Comments Off on Restrict a schema to drop a table from its own
