Oracle DBA Blog
Sunday, January 29, 2012
Disabling / deleting SQL Profile
›
Disabling SQL profile SQL> connect /as sysdba Connected. SQL> EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('sql_profile_name',...
1 comment:
Friday, May 20, 2011
Rebuilding Indexes
›
select 'ALTER INDEX '|| index_name ||' REBUILD TABLESPACE INDX;’ from USER_INDEXES -- TO GET ALL THE INDEXES alter system ena...
Sunday, May 15, 2011
RMAN Script: POINT IN TIME RECOVERY
›
[point_intime_recovery.scp] # This scenario assumes that all initializaiton filesa nd the current controlfile arein place and you want ...
RMAN SCRIPT : DISASTER RECOVERY
›
[ disaster_recovery.scp] # The commands below assume that all initialization parameters files are in place and the complete directory s...
RMAN SCRIPT : CONTROLFILE RECOVERY
›
[controlfile_recovery.scp] # Oracle strongly recommends that you specify multiple controlfiles, on separate physical disks and contro...
RMAN Script: DATAFILE RECOVERY
›
[datafile_recovery.scp] # This section assumes that datafile 5 has been damaged and needs to be restored and recovered, and that the ...
‹
›
Home
View web version