Posts

Showing posts from July, 2013

Oracle 10g:Create New/Update/Remove redo logs from existing database

Oracle 10g:Redo logs Operation There are some condition when we need to recreate redo logs because of resize,rename or log corruption. 1.Check the current use of redo log group. SELECT GROUP #, THREAD#,ARCHIVED, STATUS FROM V$LOG ; Check the status 'INACTIVE' which can be dropped easily. 2.Drop INACTIVE Groups. ALTER DATABASE DROP LOGFILE GROUP 1; Create script based on below query. select 'ALTER DATABASE DROP LOGFILE GROUP '||GROUP#||';' from V$LOG where status='INACTIVE';   3.Drop Redo log members. ALTER DATABASE DROP LOGFILE MEMBER '/oracle1/oradata/pindb/redo1.log'; Alternatively remove old files by OS level commands. 4.Add New Redo Logs. ALTER DATABASE ADD LOGFILE GROUP 1(   '/oracle1/oradata/pindb/redo1.log',   '/oracle2/oradata/pindb/redo1a.log')     SIZE 100M; ALTER DATABASE ADD LOGFILE GROUP 2(   '/oracle1/oradata/pindb/redo2.log',   '/oracle

Oracle 10g:RMAN backup restore with Incomplete recovery

Image
 RMAN Backup restore Sometime RMAN Backup needs to restore other machine and check weather it is valid and if any issue come and need to restore to another server.For new test server creation by rman manual restore. RMAN Cloning also one of the finest way to make new cloned database. Follow this easy steps to rman backup restore. 1.Take full rman backup. 2.Map drive of rman backup to destination server or manually copy rman all backup to destination server.    There is one problem of found which files need to copy.If source database available then use this query and find the name of paryticular backup. select tag,to_char(completion_time,'DD-MON-YY') backup_date,'CATALOG BACKUPPIECE '''||fname||''';' fname,round(sum(bs_bytes)/1024/1024/1024,2) backup_size_gb from v$backup_files where trunc(completion_time)=trunc(sysdate) Group by tag,to_char(completion_time,'DD-MON-YY'),fname order by to_char(completi