Finding OS Version and Bit OS Version uname -a AIX <ServerName> 3 5 00C8E96B4C00 uname AIX oslevel -r 5300-06 OS Bit lsconf|grep -i kernel Kernel Type: 64-bit prtconf /usr/bin/isainfo –kv…
Read MoreExporting a table using MKNOD (On the fly zipping and exporting a table) Note: This method is mainly useful when the table size is huge and when we want to…
Read MoreNOTE: Can be used to identify block corruption Need to identify and pass the block size argument Can be directly run on the file from the OS Prompt Finding Block…
Read Moreselect count(*) from v$backup_async_io where status=’IN PROGRESS’; Session information on backups SELECT s.sid, username AS “User”, program, module, action, logon_time “Logon”, l.* FROM v$session s, v$enqueue_lock l WHERE l.sid =…
Read MoreAssumptions 1. Non-system tablespace is corrupted or the datafile of the tablespace is deleted/corrupted. 2. Required archivelogs (‘sysdate – x’) are present in the archive log dest file system. Restore…
Read MoreAssumptions 1. Non-system datafile is corrupted. 2. Required archivelogs (‘sysdate – x’) are present in the archive log dest file system. Datafile Corrupted (Confirmation SQL> shutdown immediate; ORA-01122: database file…
Read MoreLOSS OF UNDO TABLESPACE DATAFILE(Complete Recovery and Only will loose the un commited transactions. Loss of undo datafile need the database outage)1. I have created one temporary table for testing.SQL>…
Read MoreLOSS OF SYSTEM DATAFILE (Complete recovery because we have online redo logs and current controlfile) Assumption: – All the archive logs are found in local file system for recovery. –…
Read MoreLoss of non system datafile which not available in last night backup (Complete and Online recovery) Note:(Eg: We have taken the backup 10:00 AM and added…
Read MorePOINT IN TIME PRODUCTION RESTORE/RECOVERY USING RMAN BACKUPS ASSUMPTION: *This restore recover situation is pertaining to Restoring database from 15th Sep 09 backup and recovering point in time upto 16th…
Read More