Posts

Showing posts from January, 2016

RMAN-06820: WARNING: failed to archive current log at primary database

RMAN archive log backup at the standby site is throws the following errors ******************************************************************************** RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ******************************************************************************** RMAN> backup database plus archivelog tag 'FULL_AL_BKP'; Starting backup at 29-FEB-16 RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-00942: table or view does not exist allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=48 device type=DISK skipping archived logs of thread 1 from sequence 192 to 201; already backed up Finished backup at 29-FEB-16 Starting backup at 29-FEB-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile b...
Post a Comment
Read more

RMAN-06820: WARNING: failed to archive current log at primary database

RMAN archive log backup at the standby site is throws the following errors ******************************************************************************** RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ******************************************************************************** RMAN> backup database plus archivelog tag 'FULL_AL_BKP'; Starting backup at 29-FEB-16 RMAN-06820: WARNING: failed to archive current log at primary database ORACLE error from target database: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-00942: table or view does not exist allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=48 device type=DISK skipping archived logs of thread 1 from sequence 192 to 201; already backed up Finished backup at 29-FEB-16 Starting backup at 29-FEB-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile b...
Post a Comment
Read more

restore archive logs from backup

Restoring a archive log (LOG SEQ) from backups. [oracle@Linux02 backups]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Tue Feb 16 10:47:13 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. connected to target database: ORCL (DBID=1424488411, not open) RMAN> restore archivelog logseq 140; Starting restore at 16-FEB-16 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=32 device type=DISK channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=140 channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/rman_bak_ORCL_DB_0rqtvod6_27_1 channel ORA_DISK_1: piece handle=/u01/app/oracle/backup/rman_bak_ORCL_DB_0rqtvod6_27_1 tag=LEVEL0BACKUP_FORSTANDBY channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished re...
Post a Comment
Read more

RAC - Missing Cvuqdisk package

If you are trying to install the RAC, then you might come up across a missing cvuqdisk* rpm error.This package comes with the Grid install software.Once you have downloaded the Grid infrastructure software. You will find the Cvuqdisk* package in the rpm directory. grid@RAC01:[/u01/app/ORCL_SFTW/grid_software] $ ls install  readme.html  response  rpm  runcluvfy.sh  runInstaller  sshsetup  stage  welcome.html Now change dir to rpm : grid@RAC01:[/u01/app/ORCL_SFTW/grid_software] $ cd rpm grid@RAC01:[/u01/app/ORCL_SFTW/grid_software/rpm] $ exit logout atoorpu@RAC01:[/u01/app] $ cd /u01/app/ORCL_SFTW/grid_software/rpm You need to be logged in as root to install the package. atoorpu@RAC01:[/u01/app/ORCL_SFTW/grid_software/rpm] $ sudo rpm -Uvh cvuqdisk-1.0.9-1.rpm Preparing...                ########################################### [100%]    1:cvuqdisk               #...
Post a Comment
Read more

Count rows in all tables in a schema

Below PL/SQL block will allow you to count rows in all tables in a given schema:  Plsql : declare     v_count integer; begin     for r in (select table_name, owner from all_tables               where owner in ('&owner'))     loop         execute immediate 'select count(*) from ' ||r.owner||'.'|| r.table_name             into v_count;         --INSERT INTO STATS_TABLE(TABLE_NAME,SCHEMA_NAME,RECORD_COUNT,CREATED) VALUES (r.table_name,r.owner,v_count,SYSDATE);         DBMS_OUTPUT.PUT_LINE('TABLE OWNER : '||lpad(to_char(r.owner),10)||', Table_name : '||lpad(to_char(r.table_name),10)||         ', No or rows: '||rpad(to_char(v_count),6));     end loop; end;  / ...
Post a Comment
Read more

Count rows in all tables in a schema- oracle

Below PL/SQL block will allow you to count rows in all tables in a given schema:  Plsql : declare     v_count integer; begin     for r in (select table_name, owner from all_tables               where owner in ('&owner'))     loop         execute immediate 'select count(*) from ' ||r.owner||'.'|| r.table_name             into v_count;         --INSERT INTO STATS_TABLE(TABLE_NAME,SCHEMA_NAME,RECORD_COUNT,CREATED) VALUES (r.table_name,r.owner,v_count,SYSDATE);         DBMS_OUTPUT.PUT_LINE('TABLE OWNER : '||lpad(to_char(r.owner),10)||', Table_name : '||lpad(to_char(r.table_name),10)||         ', No or rows: '||rpad(to_char(v_count),6));     end loop; end;  / ...
Post a Comment
Read more