Home » RDBMS Server » Backup & Recovery » backup full database throws an error
backup full database throws an error [message #554362] Sun, 13 May 2012 22:59 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production




after i backup my database,i check the alert log ,i found the following errror:

Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:42 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:43 2012
Starting control autobackup
Mon May 14 09:19:44 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:44 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Mon May 14 09:19:44 2012
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Control autobackup written to DISK device
        handle '/u01/app/oracle/flash_recovery_area/SZCARGO/autobackup/2012_05_14/o1_mf_s_783249583_7v0qfj4n_.bkp'
Mon May 14 09:19:49 2012
Thread 1 advanced to log sequence 1729
  Current log# 3 seq# 1729 mem# 0: /u01/app/oracle/oradata/szcargo/redo03.log



the trace number 26967 :

[oracle@shenzhengair archivelog]$ cat /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc 
/u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      shenzhengair.com
Release:        2.6.18-92.el5xen
Version:        #1 SMP Tue Apr 29 13:45:57 EDT 2008
Machine:        i686
Instance name: szcargo
Redo thread mounted by this instance: 1
Oracle process number: 31
Unix process pid: 26967, image: oracle@shenzhengair.com (TNS V1-V3)

*** 2012-05-14 09:19:42.607
*** ACTION NAME:(0000044 STARTED16) 2012-05-14 09:19:42.572
*** MODULE NAME:(backup full datafile) 2012-05-14 09:19:42.572
*** SERVICE NAME:(SYS$USERS) 2012-05-14 09:19:42.572
*** SESSION ID:(146.6008) 2012-05-14 09:19:42.572
*** ACTION NAME:(0000048 STARTED111) 2012-05-14 09:19:44.574
[oracle@shenzhengair archivelog]$ 



what does the error mean?
Re: backup full database throws an error [message #554367 is a reply to message #554362] Sun, 13 May 2012 23:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which error?

Regards
Michel
Re: backup full database throws an error [message #554368 is a reply to message #554367] Sun, 13 May 2012 23:25 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Re: backup full database throws an error [message #554369 is a reply to message #554368] Sun, 13 May 2012 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Errors in file /u01/app/oracle/admin/szcargo/udump/szcargo_ora_26967.trc:
Errors have error code & error message; neither of which exists in anything you have posted
Re: backup full database throws an error [message #554370 is a reply to message #554369] Sun, 13 May 2012 23:31 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
so ,it's not an error? Embarassed
Re: backup full database throws an error [message #554371 is a reply to message #554369] Sun, 13 May 2012 23:32 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
i just found this in my alert log ,no others.
Re: backup full database throws an error [message #554381 is a reply to message #554371] Mon, 14 May 2012 01:07 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No information so we can't say anything not even if there is an error or not.

Regards
Michel
Previous Topic: ORA-01113: file 5 needs media recovery
Next Topic: How To Restore full backup on a media
Goto Forum:
  


Current Time: Thu Mar 28 07:51:37 CDT 2024