Home » RDBMS Server » Backup & Recovery » Recovery of database using RMAN-Help needed
Recovery of database using RMAN-Help needed [message #158641] Mon, 13 February 2006 13:18 Go to next message
kmalla
Messages: 1
Registered: February 2006
Location: VIZAG
Junior Member
Hi
I am running the script
run
{
shutdown immediate;
startup mount;
restore database;
recover database;
alter database open;
}
i am getting the following errors
database closed
database dismounted
Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 02/13/2006 14:19:02
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Please help me out regarding.
Advance thanks
Re: Recovery of database using RMAN-Help needed [message #158642 is a reply to message #158641] Mon, 13 February 2006 13:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you set your ORACLE_SID in environment?
If you are using tnsentries, make sure you have the listener available.
The URL talks about simple steps to backup and recover.
http://www.orafaq.com/forum/m/135192/42800/?srch=restore#msg_135192
Previous Topic: backup of remote machine
Next Topic: backup when OS fails
Goto Forum:
  


Current Time: Fri Apr 26 15:22:49 CDT 2024