Oracle DBA Blog
Monday, July 20, 2009
Switching Undo Tablespace
›
CREATE UNDO TABLESPACE "UNDOTBS" DATAFILE '/u05/abc/oradata/undotbs.dbf' SIZE 4000M; SQL> select nam...
Monday, July 13, 2009
Working on Datapump Export
›
Create a directory at O/S Level $ mkdir dump_dir (for dump directory) $ mkdir log_dir (for log directory) $ chmod 775 dump_dir...
Sunday, July 12, 2009
Enable Crontab
›
Giving Crontab permission to new os user Login as root Goto /etc/cron.d directory Add the user entry (ex. ota ) in cron.allow file Note: ...
Upgrade Oracle from 10.2.0.1 To 10.2.0.4 on Linux x86 AS4 / Solaris
›
Upgrade Oracle from 10.2.0.1 To 10.2.0.4 on Linux x86 AS4 Screen shots below attached for production upgrade on solaris 64-BIT Downl...
Enable X Manager
›
Install X manager enterprise edition on any client machine; login on server as root and run gdmsetup utility and enable XDMCP Now you can lo...
Delete archive log without catalog
›
Connect rman $ rman target sys/password@connect_string RMAN > crosscheck backup; RMAN > delete archivelog until time `SYSDATE – ...
Thursday, June 25, 2009
LOG APPLY SERVICES (LAS)
›
LOG APPLY SERVICE: i. Applying redo immediately ii. Time delay for redo apply Applying redo ...
REDO TRANSPORT SERVICES (RTS)
›
Redo Transport Service: § Automates the transfer of redo to one or more destinations § Resolve gaps in Redo Transport i...
4 comments:
‹
›
Home
View web version
