ORA-24454: client host name is not set

 ORA-24454: client host name is not set

SQL> shut abort

ORACLE instance shut down.

ERROR:

ORA-24454: client host name is not set

Solution:

In our case issue related to /etc/hosts file has wrong value for the database server.

Thanks,

RMAN Cold backup restoration ( rman cold backup and then restore using rman)

 
Below can be followed for rman cold backup restoration ( Rare scenario)
=====================================================

From Source:
-----------
1. shut immediate;
2. startup mount;
3. Take rman backup using below script
rman target / 
spool log to '/backup/db_mig/DB_COLD_BKP.log'
run { 
allocate channel c1 device type disk ;
allocate channel c2 device type disk ;
allocate channel c3 device type disk ;
allocate channel c4 device type disk ;
backup database tag='COLD_BKP' format '/backup/db_mig/DB_COLD_s%s_p%p-t%T.bck';
backup tag='COLD_BKP' format '/backup/db_mig/%d_cfile_s%s_p%p_open.bck' current controlfile;
backup tag DB_CTL current controlfile format '/backup/db_mig/%d_%T_%s_%p_CONTROL';
backup spfile format '/backup/db_mig/%d_spfile_s%s_p%p_%T_dbid%I.rman';
sql 'alter database backup controlfile to TRACE';
release channel c1;  
release channel c2;
release channel c3;
release channel c4;
}

4. Copy the backup pieces to Target server.


Now go to Target server
===========================
Make sure you are in Target database.

If Target database is up and running then:
5. shut immediate;
6. startup mount restrict;
7. drop database;
8. startup nomount pfile='pfile.ora'
9. Restore using below for rman cold backup restore.
rman  auxiliary /
run
{
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL c3 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL c4 DEVICE TYPE DISK;
SET NEWNAME FOR DATABASE   TO '/u01/inttest/data/%b';
DUPLICATE target DATABASE TO  'INTTEST' backup location ='/u02/RMAN_BKP' nofilenamecheck noredo;
}
10. Validate it.

Thanks