Oracle Faq

By default when we wish to restore the spfile,controlfile from autobackup RMAN looks for the default for autobackup at the location $ORACLE_HOME/dbs in UNIX and $ORACLE_HOME/database for Windows.
As a result when using rman when we use the command restore spfile from autobackup we get error RMAN-06172
hence to avoid the error during autobackup we specify the […]

Tnsnames.ora is a file which is used by oracle client to connect to oracle server.As we know when if we want to connect to oracle database from remote machine we enter into sqlplus using connect identifire as shown
C:\>sqlplus
SQL*Plus: Release 10.2.0.1 - Production on Wed Mar 21 15:28:03 2007
(c) Copyright 2000 Oracle Corporation. All rights […]