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#';
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 ...
