| | Generate a script to unbreak / break Oracle jobs
--
-- Generate a script to unbreak jobs for a schema
-- Replace USERNAME with schema owner and PASSWORD with schema owner's password
--
-- To break the jobs replace:
-- spool unbreak_jobs.sql -> spool break_jobs.sql
-- broken=>FALSE -> broken=>TRUE
-- where broken = 'Y' -> where broken = 'N'
--
set echo off verify off feedback off ... | | More...
10/03/05 | | | | |
|
| | Kill user session
Use this procedure to find and kill a user's session:
SQLPLUS> select sid, serial# from v$session where username = 'USER';
SQLPLUS> alter system kill session 'SID,SERIAL#';
| |  
More...
10/03/05 | | | | |
|
| | Reset DBID
Reset database id so that it can be backed up if the same DBID already exists in RMAN catalog for a different database.
SVRMGR> alter database backup controlfile to trace resetlogs;
SVRMGR> shutdown immediate;
SVRMGR> startup mount;
SVRMGR> select dbid , name from v$database ;
DBID NAME
---------- ---------
673658548 ... | | More...
09/23/05 | | | | |
|
<< 1 | Page 2 |
