incomplete physical backup [message #539140] |
Wed, 11 January 2012 10:43  |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
hi
i have an issue with RMAN incremental level 0 backup.it start by connecting RMAN and then RMAN catalog and then input datafile ...
but when it reach to allocate channel 1 so there it just stop and no more log generated , no message of failure or anything else.it just says "allocating channel c1.. and then no more log.fol command is there in the our script
connect target /
connect catalog rman/passwd@backup
run
(allocate channel c1 type disk format '/export/home/oracle/dump/${ORACLE_SID}... .rman';backup tag=full_backup incremental level 0 database;
release channel c1;
)
exit
EOF
[Updated on: Wed, 11 January 2012 10:47] Report message to a moderator
|
|
|
|
|
Re: incomplete physical backup [message #539152 is a reply to message #539145] |
Wed, 11 January 2012 11:33   |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
@john watson, complete scripts is as fol
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome
ORACLE_SID=mydb
export ORACLE_HOME
export ORACLE_SID
BACKUP_MEDIA=DISK
BACKUP_TYPE=FULL_DB_BKUP
export BACKUP_MEDIA
export BACKUP_TYPE
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog username/passwd@service1
run
(
allocate channel c1 type disk format '/export/home/oracle/... .rman';
backup tag=full_backup incremental level o database;
release channel c1;
)
exit
EOF
As i dont have internet facility at DC so i cant write the output what i can say is that it start normally by connecting to RMAN and then target and then catalog. then start input datafile path... then it try to allocate channel c1 and thereafter no entry in log file .
kindly guide
regards
|
|
|
|
|
Re: incomplete physical backup [message #539155 is a reply to message #539154] |
Wed, 11 January 2012 11:53   |
John Watson
Messages: 8968 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I say "goodbye" because you have not given any information on which one can rely. Time waster! Perhaps someone else is prepared to assist by guessing what you did wrong.
|
|
|
|
|
|
Re: incomplete physical backup [message #539336 is a reply to message #539266] |
Fri, 13 January 2012 08:05   |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
hi @ Michel Cadot
The RMAN session look like as as follows
"
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jan 5 09:09:14 2012
RMAN>
Connected to target database : db12 (DBID=xxxx)
RMAN>
Connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6>
allocated channel C1:SID=xxxx instance=db121 device type=DISK
starting backup at 05 -Jan-12
Channel C1:starting Incremental level 0 datafile set
Channel C1: specfying datafile(s) in backup set
Input datafile number=0007 name=+DG1/db2/datafile/data-01-01.dbf
Input datafile number=0009 name=+DG1/db2/datafile/data-01-02.dbf
Input datafile number=0011 name=+DG1/db2/datafile/data-01-03.dbf
Input datafile number=0013 name=+DG1/db2/datafile/data-01-04.dbf
Input datafile number=0015 name=+DG1/db2/datafile/data-02-01.dbf
Input datafile number=0017 name=+DG1/db2/datafile/data-02-02.dbf
Input datafile number=0019 name=+DG2/db2/datafile/data-01-01.dbf
Input datafile number=0021 name=+DG2/db2/datafile/data-01-02.dbf
Input datafile number=0023 name=+DG2/db2/datafile/data-01-03.dbf
Input datafile number=0025 name=+DG2/db2/datafile/data-01-04.dbf
Input datafile number=0027 name=+DG2/db2/datafile/data-01-05.dbf
Input datafile number=0029 name=+DG2/db2/datafile/data-02-01.dbf
Input datafile number=0031 name=+DG2/db2/datafile/data-02-02.dbf
Input datafile number=0033 name=+DG2/db2/datafile/data-02-03.dbf
Input datafile number=0035 name=+DG2/db2/datafile/data-02-04.dbf
Input datafile number=0037 name=+DG2/db2/datafile/data-02-05.dbf
Input datafile number=0039 name=+DG2/db2/datafile/data-03-01.dbf
Input datafile number=0042 name=+DG3/db2/datafile/data-01-01.dbf
Input datafile number=0043 name=+DG3/db2/datafile/data-01-02.dbf
Input datafile number=0045 name=+DG3/db2/datafile/data-01-03.dbf
Input datafile number=0047 name=+DG3/db2/datafile/data-01-04.dbf
Input datafile number=0049 name=+DG3/db2/datafile/data-02-01.dbf
Input datafile number=0052 name=+DG3/db2/datafile/data-02-02.dbf
Input datafile number=0053 name=+DG3/db2/datafile/data-02-03.dbf
Input datafile number=0055 name=+DG3/db2/datafile/data-02-04.dbf
Input datafile number=0057 name=+DG3/db2/datafile/data-03-01.dbf
Input datafile number=0059 name=+DG3/db2/datafile/data-03-02.dbf
Input datafile number=0062 name=+DG3/db2/datafile/data-03-03.dbf
Input datafile number=0064 name=+DG3/db2/datafile/data-03-04.dbf
Input datafile number=0067 name=+DG3/db2/datafile/data-03-05.dbf
Input datafile number=0068 name=+DG3/db2/datafile/data-01-05.dbf
Input datafile number=0072 name=+DG3/db2/datafile/data-01-01.dbf
Input datafile number=0075 name=+DG4/db2/datafile/data-01-02.dbf
Input datafile number=0077 name=+DG4/db2/datafile/data-01-03.dbf
Input datafile number=0079 name=+DG4/db2/datafile/data-01-04.dbf
Input datafile number=0081 name=+DG4/db2/datafile/data-01-05.dbf
Input datafile number=0083 name=+DG4/db2/datafile/data-02-01.dbf
Input datafile number=0085 name=+DG4/db2/datafile/data-02-02.dbf
Input datafile number=0088 name=+DG4/db2/datafile/data-02-03.dbf
Input datafile number=0007 name=+DG4/db2/datafile/data-02-04.dbf
Input datafile number=0009 name=+DG4/db2/datafile/data-02-05.dbf
Input datafile number=0011 name=+DG4/db2/datafile/data-03-01.dbf
Input datafile number=0013 name=+DG4/db2/datafile/data-03-02.dbf
Input datafile number=0015 name=+DG5/db2/datafile/data-01-01.dbf
Input datafile number=0017 name=+DG5/db2/datafile/data-01-02.dbf
Input datafile number=0019 name=+DG5/db2/datafile/data-01-03.dbf
Input datafile number=0021 name=+DG5/db2/datafile/data-01-04.dbf
Input datafile number=0023 name=+DG5/db2/datafile/data-01-05.dbf
Input datafile number=0025 name=+DG5/db2/datafile/data-02-01.dbf
Input datafile number=0027 name=+DG5/db2/datafile/data-02-02.dbf
Input datafile number=0029 name=+DG5/db2/datafile/data-02-03.dbf
Input datafile number=0031 name=+DG5/db2/datafile/data-02-04.dbf
Input datafile number=0033 name=+DG5/db2/datafile/data-02-05.dbf
Input datafile number=0007 name=+SG1/db2/datafile/undotbs1.259.74384423
Input datafile number=0007 name=+SG1/db2/datafile/undotbs2.260.74384455
Cahnnel C1 :starting Piece 1 at 05 -Jan-12 "
after this no more log aval
kindly guide
|
|
|
|
|
|
Re: incomplete physical backup [message #540431 is a reply to message #540238] |
Mon, 23 January 2012 09:45   |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
hi , here i am with the script and session of RMAN
My backup script is as follwos
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome
ORACLE_SID=grid51
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID
export path
BACKUP_MEDIA=DISK
BACKUP_TYPE=FULL_DB_BKUP
TIMESTAMP=`date +%T-%m-%d-%Y`
LOG=/export/home/oracle/dumps/pdumps/${ORACLE_SID}_${BACKUP_TYPE}_${BACKUP_MEDIA}_${TIMESTAMP}.log
export BACKUP_MEDIA
export BACKUP_TYPE
export LOG
export TIMESTAMP
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog rcowner/rcowner@backup1
run
{
allocate channel c1 type disk format '/export/home/oracle/dumps/pdumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
backup tag=full_backup incremental level 0 database;
release channel c1;
}
exit
EOF
and the ouput of my RMAN session is followed
"Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jan 5 09:09:14 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: grid5 (DBID=3530575183)
RMAN>
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6>
allocated channel: c1
channel c1: SID=1564 instance=grid51 device type=DISK
Starting backup at 05-JAN-12
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DG1/grid51/datafile/data_01_01.dbf
input datafile file number=00009 name=+DG1/grid51/datafile/data_01_03.dbf
input datafile file number=00011 name=+DG1/grid51/datafile/data_01_05.dbf
input datafile file number=00013 name=+DG1/grid51/datafile/data_01_07.dbf
input datafile file number=00015 name=+DG2/grid51/datafile/data_02_02.dbf
input datafile file number=00017 name=+DG2/grid51/datafile/data_02_04.dbf
input datafile file number=00019 name=+DG2/grid51/datafile/data_02_06.dbf
input datafile file number=00021 name=+DG3/grid51/datafile/data_03_01.dbf
input datafile file number=00023 name=+DG3/grid51/datafile/data_03_03.dbf
input datafile file number=00025 name=+DG3/grid51/datafile/data_03_05.dbf
input datafile file number=00027 name=+DG3/grid51/datafile/data_03_07.dbf
input datafile file number=00029 name=+DG4/grid51/datafile/data_04_02.dbf
input datafile file number=00031 name=+DG4/grid51/datafile/data_04_04.dbf
input datafile file number=00033 name=+DG4/grid51/datafile/data_04_06.dbf
input datafile file number=00035 name=+DG5/grid51/datafile/data_05_01.dbf
input datafile file number=00037 name=+DG5/grid51/datafile/data_05_03.dbf
input datafile file number=00039 name=+DG5/grid51/datafile/data_05_05.dbf
input datafile file number=00041 name=+DG5/grid51/datafile/data_05_07.dbf
input datafile file number=00048 name=+DG1/grid51/datafile/dif_m11_01_001.dbf
input datafile file number=00050 name=+DG1/grid51/datafile/dif_s11_01_001.dbf
input datafile file number=00064 name=+DG2/grid51/datafile/dof_m11_02_001.dbf
input datafile file number=00066 name=+DG2/grid51/datafile/dof_s11_02_001.dbf
input datafile file number=00080 name=+DG1/grid51/datafile/dif_m11_01_002.dbf
input datafile file number=00083 name=+DG3/grid51/datafile/dif_j11_03_003.dbf
input datafile file number=00085 name=+DG3/grid51/datafile/dif_s11_03_003.dbf
input datafile file number=00088 name=+DG3/grid51/datafile/dif_d11_03_003.dbf
input datafile file number=00007 name=+DG5/grid51/datafile/indx_05_01.dbf
input datafile file number=00078 name=+DG2/grid51/datafile/dof_d11_02_002.dbf
input datafile file number=00086 name=+DG3/grid51/datafile/dif_s11_03_004.dbf
input datafile file number=00003 name=+SG1/grid51/datafile/undotbs1.259.711384423
input datafile file number=00004 name=+SG1/grid51/datafile/undotbs2.260.711384505
input datafile file number=00076 name=+DG2/grid51/datafile/dof_j11_02_002.dbf
input datafile file number=00079 name=+DG2/grid51/datafile/dif_d10_02_002.dbf
input datafile file number=00045 name=+DG1/grid51/datafile/dif_j10_01_001.dbf
input datafile file number=00126 name=+DG3/grid51/datafile/dif_d11_03_004.dbf
input datafile file number=00089 name=+DG2/grid51/datafile/req_download_lob_02_001.dbf
input datafile file number=00108 name=+DG2/grid51/datafile/dsl_in_02_001.dbf
input datafile file number=00060 name=+DG1/grid51/datafile/dof_m10_01_001.dbf
input datafile file number=00061 name=+DG2/grid51/datafile/dof_j10_02_001.dbf
input datafile file number=00043 name=+DG4/grid51/datafile/misc_app_indx01.dbf
input datafile file number=00053 name=+DG1/grid51/datafile/dif_j12_01_001.dbf
input datafile file number=00055 name=+DG1/grid51/datafile/dif_d12_01_001.dbf
input datafile file number=00057 name=+DG1/grid51/datafile/dif_j13_01_001.dbf
input datafile file number=00059 name=+DG1/grid51/datafile/dif_d13_01_001.dbf
input datafile file number=00069 name=+DG2/grid51/datafile/dof_j12_02_001.dbf
input datafile file number=00071 name=+DG2/grid51/datafile/dof_d12_02_001.dbf
input datafile file number=00073 name=+DG2/grid51/datafile/dof_j13_02_001.dbf
input datafile file number=00075 name=+DG2/grid51/datafile/dof_d13_02_001.dbf
input datafile file number=00093 name=+DG3/grid51/datafile/doc_in_j10_03_001.dbf
input datafile file number=00095 name=+DG3/grid51/datafile/doc_in_d10_03_001.dbf
input datafile file number=00097 name=+DG3/grid51/datafile/doc_in_j11_03_001.dbf
input datafile file number=00099 name=+DG3/grid51/datafile/doc_in_d11_03_001.dbf
input datafile file number=00101 name=+DG3/grid51/datafile/doc_in_j12_03_001.dbf
input datafile file number=00103 name=+DG3/grid51/datafile/doc_in_d12_03_001.dbf
input datafile file number=00105 name=+DG3/grid51/datafile/doc_in_j13_03_001.dbf
input datafile file number=00107 name=+DG3/grid51/datafile/doc_in_d13_03_001.dbf
input datafile file number=00111 name=+DG3/grid51/datafile/dm_02_03_001.dbf
input datafile file number=00113 name=+DG3/grid51/datafile/dm_04_03_001.dbf
input datafile file number=00115 name=+DG3/grid51/datafile/dm_06_03_001.dbf
input datafile file number=00117 name=+DG3/grid51/datafile/dm_08_03_001.dbf
input datafile file number=00119 name=+DG3/grid51/datafile/dm_10_03_001.dbf
input datafile file number=00121 name=+DG3/grid51/datafile/dm_12_03_001.dbf
input datafile file number=00123 name=+DG3/grid51/datafile/dm_14_03_001.dbf
input datafile file number=00125 name=+DG3/grid51/datafile/dm_16_03_001.dbf
channel c1: starting piece 1 at 05-JAN-12"
root@grid51
now you can see that command prompt which means no log after that and backup do not complete
kindly guide Now
Regards
|
|
|
|
Re: incomplete physical backup [message #540435 is a reply to message #540432] |
Mon, 23 January 2012 10:04   |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
no sir the script is run as oracle user not "root" sir.i just took the logs when i was loged in as root user.
kindly guide is there anything wrong with the script??
Regards
|
|
|
|
|
Re: incomplete physical backup [message #540583 is a reply to message #540438] |
Tue, 24 January 2012 11:59   |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
well i correct export PATH in the script and run it .it take 20 hours to complete then will post the log.
Quote:And you didn't either export ORACLE_HOME and ORACLE_SID.
but if you see the script it is exported as Quote:export ORACLE_HOME
export ORACLE_SID
is it not exported??
regards
Janakors
|
|
|
|
|
Re: incomplete physical backup [message #542936 is a reply to message #540668] |
Fri, 10 February 2012 23:23  |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
hi,
well as per you advices the 'PATH' was exported but now after 2 weeks successful execution of script, now the same issue appears again. let me tell you that the same script is running at our 14 different station and working fine as receive no complain so far.THE full physical backup size is 450 GB and and now it took 375 GB which is not complete backup.
i am posting the script and RMAN session as fol
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome
ORACLE_SID=grid51
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export ORACLE_SID
export PATH
BACKUP_MEDIA=DISK
BACKUP_TYPE=FULL_DB_BKUP
TIMESTAMP=`date +%T-%m-%d-%Y`
LOG=/export/home/oracle/dumps/pdumps/${ORACLE_SID}_${BACKUP_TYPE}_${BACKUP_MEDIA}_${TIMESTAMP}.log
export BACKUP_MEDIA
export BACKUP_TYPE
export LOG
export TIMESTAMP
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog rcowner/rcowner@backup1
run
{
allocate channel c1 type disk format
'/export/home/oracle/dumps/pdumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
backup tag=full_backup incremental level 0 database;
release channel c1;
}
exit
EOF
"Recovery Manager: Release 11.2.0.1.0 - Production on Sun FEB 5 09:09:14 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: grid5 (DBID=3530575183)
RMAN>
connected to recovery catalog database
RMAN> 2> 3> 4> 5> 6>
allocated channel: c1
channel c1: SID=1564 instance=grid51 device type=DISK
Starting backup at 05-FEB-12
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DG1/grid51/datafile/data_01_01.dbf
input datafile file number=00009 name=+DG1/grid51/datafile/data_01_03.dbf
input datafile file number=00011 name=+DG1/grid51/datafile/data_01_05.dbf
input datafile file number=00013 name=+DG1/grid51/datafile/data_01_07.dbf
input datafile file number=00015 name=+DG2/grid51/datafile/data_02_02.dbf
input datafile file number=00017 name=+DG2/grid51/datafile/data_02_04.dbf
input datafile file number=00019 name=+DG2/grid51/datafile/data_02_06.dbf
input datafile file number=00021 name=+DG3/grid51/datafile/data_03_01.dbf
input datafile file number=00023 name=+DG3/grid51/datafile/data_03_03.dbf
input datafile file number=00025 name=+DG3/grid51/datafile/data_03_05.dbf
input datafile file number=00027 name=+DG3/grid51/datafile/data_03_07.dbf
input datafile file number=00029 name=+DG4/grid51/datafile/data_04_02.dbf
input datafile file number=00031 name=+DG4/grid51/datafile/data_04_04.dbf
input datafile file number=00033 name=+DG4/grid51/datafile/data_04_06.dbf
input datafile file number=00035 name=+DG5/grid51/datafile/data_05_01.dbf
input datafile file number=00037 name=+DG5/grid51/datafile/data_05_03.dbf
input datafile file number=00039 name=+DG5/grid51/datafile/data_05_05.dbf
input datafile file number=00041 name=+DG5/grid51/datafile/data_05_07.dbf
input datafile file number=00048 name=+DG1/grid51/datafile/dif_m11_01_001.dbf
input datafile file number=00050 name=+DG1/grid51/datafile/dif_s11_01_001.dbf
input datafile file number=00064 name=+DG2/grid51/datafile/dof_m11_02_001.dbf
input datafile file number=00066 name=+DG2/grid51/datafile/dof_s11_02_001.dbf
input datafile file number=00080 name=+DG1/grid51/datafile/dif_m11_01_002.dbf
input datafile file number=00083 name=+DG3/grid51/datafile/dif_j11_03_003.dbf
input datafile file number=00085 name=+DG3/grid51/datafile/dif_s11_03_003.dbf
input datafile file number=00088 name=+DG3/grid51/datafile/dif_d11_03_003.dbf
input datafile file number=00007 name=+DG5/grid51/datafile/indx_05_01.dbf
input datafile file number=00078 name=+DG2/grid51/datafile/dof_d11_02_002.dbf
input datafile file number=00086 name=+DG3/grid51/datafile/dif_s11_03_004.dbf
input datafile file number=00003 name=+SG1/grid51/datafile/undotbs1.259.711384423
input datafile file number=00004 name=+SG1/grid51/datafile/undotbs2.260.711384505
input datafile file number=00076 name=+DG2/grid51/datafile/dof_j11_02_002.dbf
input datafile file number=00079 name=+DG2/grid51/datafile/dif_d10_02_002.dbf
input datafile file number=00045 name=+DG1/grid51/datafile/dif_j10_01_001.dbf
input datafile file number=00126 name=+DG3/grid51/datafile/dif_d11_03_004.dbf
input datafile file number=00089 name=+DG2/grid51/datafile/req_download_lob_02_001.dbf
input datafile file number=00108 name=+DG2/grid51/datafile/dsl_in_02_001.dbf
input datafile file number=00060 name=+DG1/grid51/datafile/dof_m10_01_001.dbf
input datafile file number=00061 name=+DG2/grid51/datafile/dof_j10_02_001.dbf
input datafile file number=00043 name=+DG4/grid51/datafile/misc_app_indx01.dbf
input datafile file number=00053 name=+DG1/grid51/datafile/dif_j12_01_001.dbf
input datafile file number=00055 name=+DG1/grid51/datafile/dif_d12_01_001.dbf
input datafile file number=00057 name=+DG1/grid51/datafile/dif_j13_01_001.dbf
input datafile file number=00059 name=+DG1/grid51/datafile/dif_d13_01_001.dbf
input datafile file number=00069 name=+DG2/grid51/datafile/dof_j12_02_001.dbf
input datafile file number=00071 name=+DG2/grid51/datafile/dof_d12_02_001.dbf
input datafile file number=00073 name=+DG2/grid51/datafile/dof_j13_02_001.dbf
input datafile file number=00075 name=+DG2/grid51/datafile/dof_d13_02_001.dbf
input datafile file number=00093 name=+DG3/grid51/datafile/doc_in_j10_03_001.dbf
input datafile file number=00095 name=+DG3/grid51/datafile/doc_in_d10_03_001.dbf
input datafile file number=00097 name=+DG3/grid51/datafile/doc_in_j11_03_001.dbf
input datafile file number=00099 name=+DG3/grid51/datafile/doc_in_d11_03_001.dbf
input datafile file number=00101 name=+DG3/grid51/datafile/doc_in_j12_03_001.dbf
input datafile file number=00103 name=+DG3/grid51/datafile/doc_in_d12_03_001.dbf
input datafile file number=00105 name=+DG3/grid51/datafile/doc_in_j13_03_001.dbf
input datafile file number=00107 name=+DG3/grid51/datafile/doc_in_d13_03_001.dbf
input datafile file number=00111 name=+DG3/grid51/datafile/dm_02_03_001.dbf
input datafile file number=00113 name=+DG3/grid51/datafile/dm_04_03_001.dbf
input datafile file number=00115 name=+DG3/grid51/datafile/dm_06_03_001.dbf
input datafile file number=00117 name=+DG3/grid51/datafile/dm_08_03_001.dbf
input datafile file number=00119 name=+DG3/grid51/datafile/dm_10_03_001.dbf
input datafile file number=00121 name=+DG3/grid51/datafile/dm_12_03_001.dbf
input datafile file number=00123 name=+DG3/grid51/datafile/dm_14_03_001.dbf
input datafile file number=00125 name=+DG3/grid51/datafile/dm_16_03_001.dbf
channel c1: starting piece 1 at 05-FEB-12"
root@grid51
kindly advice please
regards
Janakors
[Updated on: Sat, 11 February 2012 01:08] by Moderator Report message to a moderator
|
|
|