Home » RDBMS Server » Backup & Recovery » sp2-0640 error while doing coldbackup in crontab.
sp2-0640 error while doing coldbackup in crontab. [message #74405] Fri, 03 December 2004 07:55
Natraj
Messages: 53
Registered: March 2003
Member
Hi ,

I when i am doing cold backup using cron job, i get the error .sp2:0640 not connected in my .lst file. in the log file i created its connecting to the databnase. itshows error as below

02:00.01 1 Files found in: /u01/app/oracle/admin/natraj/cold_bkup_nat
All files removed from /u01/app/oracle/admin/natraj/cold_bkup_nat
02:00.02 Backup commands generated
02:00.02 Shutdown immediate issued for instance raj 02:00.09 Instance raj shutdown
02:00.10 Database backed up to:
         0 Database files
          0 Log files
          0 Copies of control file
          0 .
          0 Password file
        1 Total files backed up
02:00.10 Startup issued for instance raj
02:00.16 Instance raj  started
but says 0 files copied then shuts down the database and s. my tnsping is working. database is up and running.i dont want to stop and start the listener. how do i resolve this?
Previous Topic: RMAN 10g + Netbackup 5.1.
Next Topic: clonning the database
Goto Forum:
  


Current Time: Thu Mar 28 12:04:52 CDT 2024