Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 

Topic: Backup & Recovery >> rman script not working

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.



  


 Title: rman script not working
 Monu  Posted: Jun 20, 2008 08:19:28 AM

 Total Post: 26
 Joined: Jan, 2008






 Hi everyone, I've problem with Rman backup. I've two databases i.e. target database and recovery catalog database on the same windows system. When I run below mentioned rman script i get error which is also mentioned below. Kindly helpme out.....

RMAN> run {
2> allocate channel t0 type disk;
3> allocate channel t1 type disk;
4> shutdown immediate;
5> startup mount;
6> backup full database
7> filesperset 4
8> format 'd:\ebstest_%U.bak';
9> release channel t0;
10> release channel t1;
11> }

allocated channel: t0
channel t0: sid=14 devtype=DISK

allocated channel: t1
channel t1: sid=15 devtype=DISK

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 06/20/2008 17:37:14
ORA-03113: end-of-file on communication channel

 MOH_DBA
Posted: Jun 21, 2008 03:21:10 AM  

 Total Post: 155
 Joined: Nov, 2007






 
when you connect to rman it seem you are connecting through the tnsname, try to connect to rman like this:

set ORACLE_SID=your_database
rman target /

 Time Zone: EDT

  




Forum Rules & Description


Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user




 








Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  positive fanatic483
  Jayanta Sur479
  Vigyan Kaushik386
  Gopu Gopi327
  Gitesh Trivedi322
  Vinoth Kumar264
  neeraj sharma258
  Ramesh Jois246






oracle Mag



  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software