Using scp command on Linux to copy Files and Directories

DBAs need to move files from one host to the other in Linux environment. In this article, I would explain how to use scp (secure copy) command to copy files or directories from one host to the other.

Currently I am on 192.168.20.20 (MYDBSERVER is the hostname in this case) and I have a file /u01/oracle.tar on second host 192.168.20.30 that I want to transfer to /u01 on my current host,

ORA-19909: datafile 1 belongs to an orphan incarnation

Your MRP (Managed Recovery Process) may stop on your standby database with ORA-19909 error as can be seen in bellow excerpt from alert log file

Warning: Recovery target destination is in a sibling branch of the controlfile checkpoint. Recovery will only recover changes to datafiles.

ORA-17627 and ORA-12154 Returned by RMAN Duplicate Command

During RMAN DUPLICATE command, you might face this error message returned by RMAN.

C:\Users\administrator>rman target sys/pass11g@pri auxiliary sys/pass11g@aux Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 9 12:35:18 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

ORA-12154 and TNS-03505

You may receive error “ORA-12154: TNS: could not resolve the connect identifier specified” while trying to connect with the database, and also “TNS-03505: Failed to resolve name” while using TNSPING to test the connection. Reasons for both of these error is that you have not created TNS service correctly

Creating ASM Diskgroups

In this article I would explain how to create new ASM diskgroups. Process is same for Unix based platforms or Windows systems, and also for other Oracle versions.
Before we move forward, you may have a look at my articles related to stamping ASM disks on windows and creating ASM disks using ASMLib on Linux to know how we create disks which are used for ASM diskgroups.

ORA-00354: corrupt redo log block header

If you see ORA-00354 in your alert log file, probably along with "ORA-00353: log corruption near block" as can be seen bellow

Tue Nov 24 14:36:25 2015 Thread 1 cannot allocate new log, sequence 16492 Private strand flush not complete   Current log# 9 seq# 16491 mem# 0: D:\ORACLE\ORADATA\MYDB\REDO9_01.RDO Thread 1 advanced to log sequence 16492

RMAN-00600: internal error, arguments [9222] [] [] [] []

I faced following error message while creating a standby database from live database using RMAN DUPLICATE command.

C:\Users\administrator>rman target sys/pass11g@pri auxiliary sys/pass11g@aux Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 9 12:35:18 2015

RMAN-05001 auxiliary filename string conflicts with a file used by the target database

If this error message is being returned during RMANDUPLICATE DATABASE command, it is because RMAN would try to created destination files at the same location where source database files exist; and since it cannot overwrite existing files, so it and returns error message. To avoid this error, NOFILENAME check option should be used with DUPLICATE command. Otherwise use one of the following to specify different file names

Heartbeat failed to connect to standby

If Primary database alert log is showing error message similar to the following,

PING[ARC1]: Heartbeat failed to connect to standby 'standby-db'. Error is 16058.

it means that primary database is not able to ship redo log data to

Terminating the instance due to error 481

If you are trying to start a RAC instance and it is terminating immediately after STARTUP command, and alert log is showing following messages

MMNL started with pid=26, OS id=7068 NOTE: initiating MARK startup Starting background process MARK