Skip to main content

Posts

ORA-19568: a device is already allocated to this session

  <<Back to Oracle Backup & Recovery Main Page Cause: Previous channel not released Solution: Just restart from rman session and try again  RMAN> exit rman target / and try again ................... RMAN> run { allocate channel ch1 device type disk; BACKUP INCREMENTAL FROM SCN 3459834 DATABASE FORMAT '/ora_work/rman/ORCL1P/ForStandby_%U' tag 'FORSTANDBY'; } allocated channel: ch1 channel ch1: SID=50 device type=DISK Starting backup at 04-MAR-21 using channel ORA_SBT_TAPE_1 released channel: ORA_SBT_TAPE_1 released channel: ORA_SBT_TAPE_2 released channel: ch1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 03/04/2021 09:12:53 ORA-19568: a device is already allocated to this session
Post a Comment
Read more

How to Restore and Recover a Database on a New Host with a Different Directory Structure

<<Back to Oracle Backup & Recovery Main Page How to Restore and Recover a Database on a New Host with a Different Directory Structure from Tape backup Step1> Install oracle software (same version as old host) on new host To perform binary installation you can refer below post Oracle 12c Software Only Installation in Silent Mode Step2> Apply required patches Step3> set environmental variables export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome1 export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=ORCL1P Step4> Create initfile create init file under $ORACLE_HOME/dbs with db_name parameter in it. cat $ORACLE_HOME/dbs/initORCL1P.ora db_name=ORCL1P Step5> invoke rman as follows invoke RMAN connect to target and catalog database. set dbid you want to restore rman target /  catalog rman/xxxxxx@catalogdb RMAN> set dbid=915313462; Step6> restore spfile as pfile run { allocate  channel ch1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(TDPO_OPTFILE=??_db....
Post a Comment
Read more

ORA-16072: a minimum of one standby database destination is required

<<Back to Oracle Backup & Recovery Main Page LGWR: Minimum of 1 LGWR standby database required- RMAN Restore After database restore when tried to open , encountered below error. SQL> alter database open; alter database open * ERROR at line 1: ORA-03113: end-of-file on communication channel Process ID: 17034 Session ID: 387 Serial number: 7 Checking at Alterlog LGWR: Minimum of 1 LGWR standby database required Errors in file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_lgwr_17009.trc: ORA-16072: a minimum of one standby database destination is required Sun Jan 17 11:14:29 2021 ARC1 started with pid=20, OS id=17046 LGWR (ospid: 17009): terminating the instance due to error 16072 Sun Jan 17 11:14:30 2021 System state dump requested by (instance=1, osid=17009 (LGWR)), summary=[abnormal instance termination]. System State dumped to trace file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_diag_16999_20210117111430.trc Dumping diagnostic data in directory=[cdmp_2021011...
Post a Comment
Read more

Could not copy OCR locations

<<Back to Oracle RAC Main Page CLSRSC-101: Could not copy OCR locations Problem Summary Encountered below error while running the root.sh. I was trying to add a node to RAC cluster. econfigured the server and tried to add to CLUSTER01 cluster using addNode.sh script. root.sh is now failing with the errros: Using configuration parameter file: /grid_home/oracle/12.1.0.2/grid/crs/install/crsconfig_params 2020/11/21 10:15:30 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2020/11/21 10:15:30 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2020/11/21 10:15:36 CLSRSC-101: Could not copy OCR locations 2020/11/21 10:15:36 CLSRSC-293: Error: validation of OCR location 'NO_VAL' failed Died at /grid_home/oracle/12.1.0.2/grid/crs/install/crsinstall.pm line 1696. The command '/grid_home/oracle/12.1.0.2/grid/perl/bin/perl -I/grid_home/oracle/12.1.0.2/grid/perl/lib -I/grid_home/oracle/12.1.0.2/grid/crs/install /grid_home/oracle/12....
Post a Comment
Read more

How to install oracle client in silent mode

<<Back to DB Administration Main Page Installing oracle client in silent mode Step1> download oracle client software Step2> Transfer the software on server you want to install Step3> unzip the software Step4> Adjust response file ?/response/client_install.rsp UNIX_GROUP_NAME=dba INVENTORY_LOCATION=/ora_app/oraInventory ORACLE_HOME=/ora_app/product/12.1.0.2/client_1 ORACLE_BASE=/ora_app oracle.install.client.installTyp e=Administrator Step5> Run installation in silent mode ./runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile /ora_app/client/response/client_install.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 415 MB.   Actual 4442 MB    Passed Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-11-26_09-57-24AM. Please wait ... [WARNING] [INS-13001] Environment does no...
1 comment
Read more