I have fully dedicated to Oracle Database technologies like RAC, Data Guard, RMAN, ASM, Grid Control, Performance Tuning, and Security. I like to learn new technologies and teach others. I have presented at several University and Oracle user Group seminar and have an active Oracle blog to share knowledge and experiences. Blog by Talip Hakan Ozturk's.
Any RMAN command at the mount state which involves Non ASM location can take more time. RMAN-03090: Starting restore at 2015-11-09 15:01:53 RMAN-08030: allocated channel: ORA_AUX_DISK_1 RMAN-08500: channel ORA_AUX_DISK_1: SID=1 device type=DISK RMAN-08021: channel ORA_AUX_DISK_1: restoring control file RMAN-08180: channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 RMAN-08505: output file name=/oradata/C12102/controlfile/control01.ctl RMAN-03091: Finished restore at 2015-11-09 […]
When I attempting to delete obsolete backups from RMAN using the following command, the following error was occuring. RMAN> delete obsolete; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of delete command at 02/04/2018 20:28:22 RMAN-06091: no channel allocated for maintenance (of an appropriate type) So Tape channel had not […]
1- We need to download the agent software from OMS Server for the platform which we will install. Login with sysman. [oracle@isu13c bin]$ ./emcli login -username=sysman Enter password : Login successful [oracle@isu13c bin]$ ./emcli sync Synchronized successfully 2- Get the supported platform list [oracle@isu13c bin]$ ./emcli get_supported_platforms ———————————————– Version = 18.104.22.168.0 Platform = Linux x86-64 […]
The below error occured while doing a full database restore to the test system. I also checked that I restored most recent control file and the backup sets are cataloged.I tried the process two times but still the same error. Starting restore at 10-OCT-17 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel […]
LOGGING is a keyword that used on creating the index, table or tablespace. If we use LOGGING when creating the object then DML operations on the objects are logged in redo log file. If we use NOLOGGING when creating the object, in some cases DML operations on the objects are not logged in redo log file. There are a lot […]
One important feature “block change tracking” that comes with 10g, keeps log of the blocks changed since the last backup. During the next backup it uses the log file “block change tracking” to detect the changed blocks instead of scanning all data files. Changed blocks are determined and written to the log file by the process CTWR. After […]
Hi, The first event of TROUG in 2018 will be performed by the High Availability SIG. In the event, we will talk about Oracle’s solutions like Data Guard, Backup, etc. about high availability. Agenda: 10:30 – 11:00: Key Speak (Talip Hakan ÖZTÜRK – Oracle ACE) 11:00 – 11:45: High Availability (Güneş Erol – Oracle ACE) […]