Generating AWR Reports You can generate AWR reports by running SQL scripts, as described below :- # Generating an AWR Report @$ORACLE_HOME/rdbms/admin/awrrpt.sql # To generate an AWR report on …
Read More »Find and Delete Older Files in Linux
Delete Older Files in Linux Files older than 1 day find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \; Move files older than 25 hours find /rman/arch/*.dbf -mmin …
Read More »ORA-01157: cannot identify/lock data file 206 – see DBWR trace file
ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you are using XML in your database and you are trying …
Read More »ORA-07445: exception encountered: core dump
ERROR ORA-07445: exception encountered: core dump [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] [] SOLUTION SQL> ALTER SYSTEM SET “_cursor_stats_enabled”=false SCOPE=SPFILE; Caution : This recommendation can be applied …
Read More »How to Find and repair Corrupt block in database
How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT * FROM v$database_block_corruption — will show if any corruped block Step 2: Below query can give you …
Read More »RMAN backup and logical backup With Different User
RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp PROFILE DEFAULT; GRANT CONNECT TO bkp_user; GRANT exp_full_database TO bkp_user; GRANT imp_full_database TO bkp_user; GRANT recovery_catalog_owner TO bkp_user; GRANT select_catalog_role TO bkp_user; GRANT CREATE SESSION TO bkp_user; Step 2: Connect RMAN with the Above Created User …
Read More »ORA-01442: column to be modified to NOT NULL is already NOT NULL
ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT …
Read More »Oracle RMAN Commands List
Oracle RMAN Commands List Here is the list of key most RMAN commands that are used for Backup and related activities: LIST Commands LIST Commands are generic RMAN commands …
Read More »RAC Voting Disk
Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its …
Read More »CRS Administration
CRS Administration CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using …
Read More »