OraFAQ Forum: Backup & Recovery » I think something wrong with my rman

Home » RDBMS Server » Backup & Recovery » I think something wrong with my rman_script! (Oracle 10.2.0.1, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I think something wrong with my rman_script! [message #356001]

Tue, 28 October 2008 23:49

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Hi all!

I have an Oracle Database which located at /u02/app/oracle. You see

$ echo $ORACLE_HOME
/u02/app/oracle/oracle/product/10.2.0/NEO
$

and the database has been backed up by RMAN with my script..

$ cat /vnporadataSYSTEM/backupIncrementalVNP/Level0VNP.rc
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup as compressed backupset incremental level 0 database plus archivelog
tag=VNP_Level0
format '/vnprctl/backupFullVNP/Level0_%d_%s_%p_%u.bkp'
filesperset 1;
delete obsolete;
delete expired backup;
release channel d1;
release channel d2;
}
$

the mounted disk at /vnprctl is different to mounted disk at /u02.

$ df -k /u02 /vnp*
Filesystem            kbytes    used   avail capacity  Mounted on
/dev/md/dsk/d40      123930975 12278552 110413114    11%    /u02
/dev/dsk/c4t600A0B8000482FB20000045247E9D08Ad0s0
                     140447186 9492346 129550369     7%    /vnporadataSYSTEM
/dev/dsk/c4t600A0B8000482FB20000044F47E9CF52d0s0
                     421326696 190222494 226890936    46%    /vnporadataUSERS
/dev/dsk/c4t600A0B8000482FB20000044C47E9CED8d0s0
                     140438994 10277696 128756909     8%    /vnprctl
$

But, I did not understand why some piece_backup_file appeared at /u02 when RMAN reports backups

$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 29 11:57:08 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: VNP (DBID=54722743)

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1785    Incr 0  3.57G      DISK        00:35:42     29-OCT-08
        BP Key: 1785   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p7jublj9_1_1
  List of Datafiles in backup set 1785
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 23572220511 29-OCT-08 /vnporadataUSERS/oradataUSERS/users02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1786    Incr 0  1.59M      DISK        00:03:10     29-OCT-08
        BP Key: 1786   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p8jubnmc_1_1
  List of Datafiles in backup set 1786
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7    0  Incr 23572762394 29-OCT-08 /vnporadataUSERS/oradataUSERS/logvnp.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1787    Incr 0  294.36M    DISK        00:02:19     29-OCT-08
        BP Key: 1787   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p9jubnsf_1_1
  List of Datafiles in backup set 1787
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 23572820707 29-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1788    Incr 0  5.83G      DISK        00:53:24     29-OCT-08
        BP Key: 1788   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p6jublj9_1_1
  List of Datafiles in backup set 1788
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/system01.dbf
  2    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/undotbs01.dbf
  3    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/sysaux01.dbf
  4    0  Incr 23572220508 29-OCT-08 /vnporadataUSERS/oradataUSERS/users01.dbf

RMAN>

As you see, some backup pieces such as p6jublj9_1_1 appeared at /u02 while all of backup files are stored at /vnprctl/backupFullVNP

$ ls -l /vnprctl/backupFullVNP
total 2937584
-rw-r-----   1 oracle   dba      580951552 Oct 29 09:12 Level0_VNP_1820_1_osjubl
9q.bkp
-rw-r-----   1 oracle   dba      364151296 Oct 29 09:11 Level0_VNP_1821_1_otjubl
9q.bkp
-rw-r-----   1 oracle   dba      399500288 Oct 29 09:14 Level0_VNP_1822_1_oujubl
em.bkp
-rw-r-----   1 oracle   dba      66624000 Oct 29 09:13 Level0_VNP_1823_1_ovjublh
2.bkp
-rw-r-----   1 oracle   dba      17641472 Oct 29 09:13 Level0_VNP_1824_1_p0jublh
t.bkp
-rw-r-----   1 oracle   dba      16249344 Oct 29 09:13 Level0_VNP_1825_1_p1jubli
5.bkp
-rw-r-----   1 oracle   dba      17798656 Oct 29 09:13 Level0_VNP_1826_1_p2jubli
d.bkp
-rw-r-----   1 oracle   dba      15980544 Oct 29 09:14 Level0_VNP_1827_1_p3jubli
l.bkp
-rw-r-----   1 oracle   dba      3028480 Oct 29 09:14 Level0_VNP_1828_1_p4jublit
.bkp
-rw-r-----   1 oracle   dba      1767424 Oct 29 09:14 Level0_VNP_1829_1_p5jubliv
.bkp
-rw-r-----   1 oracle   dba      19472896 Oct 29 10:08 Level0_VNP_1834_1_pajubon
p.bkp

Because the /u02 disk size is not large, and when it is full, I have to remove - delete all backups, purge them by shutdown database/startup database.

Finally, when I use crosscheck command line in RMAN, all of the backup pieces file appears, including in /vnprctl/backupFullVNP/*.*

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1030 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1821_1_otjubl9q.bkp recid=
1775 stamp=669373755
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1820_1_osjubl9q.bkp recid=
1776 stamp=669373755
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1823_1_ovjublh2.bkp recid=
1777 stamp=669373987
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1824_1_p0jublht.bkp recid=
1778 stamp=669374014
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1825_1_p1jubli5.bkp recid=
1779 stamp=669374022
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1826_1_p2jublid.bkp recid=
1780 stamp=669374030
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1827_1_p3jublil.bkp recid=
1781 stamp=669374038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1828_1_p4jublit.bkp recid=
1782 stamp=669374046
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1829_1_p5jubliv.bkp recid=
1783 stamp=669374048
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1822_1_oujublem.bkp recid=
1784 stamp=669373911
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p7jublj9_1_1 r
ecid=1785 stamp=669374058
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p8jubnmc_1_1 r
ecid=1786 stamp=669376204
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p9jubnsf_1_1 r
ecid=1787 stamp=669376400
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p6jublj9_1_1 r
ecid=1788 stamp=669374058
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnprctl/backupFullVNP/Level0_VNP_1834_1_pajubonp.bkp recid=
1789 stamp=669377274
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/c-54722743-200
81029-01 recid=1790 stamp=669377281
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnporadataSYSTEM/backupIncrementalVNP/Level1/Level1_VNP_183
6_669384865_pcjuc051.bkp recid=1791 stamp=669384866
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnporadataSYSTEM/backupIncrementalVNP/Level1/Level1_VNP_183
7_669384902_pdjuc066.bkp recid=1792 stamp=669384903
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pejuc06m_1_1 r
ecid=1793 stamp=669384919
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/vnporadataSYSTEM/backupIncrementalVNP/Level1/Level1_VNP_183
9_669384965_pfjuc085.bkp recid=1794 stamp=669384966
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/c-54722743-200
81029-02 recid=1795 stamp=669384967
Crosschecked 21 objects

RMAN>

Does the backup as compressed backupset command cause?

May you clarify more?

Thank you very much!

[Updated on: Wed, 29 October 2008 00:10]

Report message to a moderator

Re: I think something wrong with my rman_script! [message #356076 is a reply to message #356001]

Wed, 29 October 2008 06:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

post your rman configuration

Report message to a moderator

Re: I think something wrong with my rman_script! [message #356199 is a reply to message #356076]

Wed, 29 October 2008 23:16

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Yes, I though about RMAN configuration, but I configured it correctly. You see

login: oracle
Password:
Last login: Thu Oct 30 08:48:46 from 10.149.33.17
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
You have mail.
$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 30 11:20:50 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: VNP (DBID=54722743)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/vnprctl/backupFullVNP/FullVNP%d_%s
_%p_%u';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/vnprctl/snapshotVNP/snapcf_VNP.f';

RMAN>

It is the Newest Incremental Level 1

RMAN> list backup of database;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1785    Incr 0  3.57G      DISK        00:35:42     29-OCT-08
        BP Key: 1785   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p7jublj9_1_1
  List of Datafiles in backup set 1785
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 23572220511 29-OCT-08 /vnporadataUSERS/oradataUSERS/users02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1786    Incr 0  1.59M      DISK        00:03:10     29-OCT-08
        BP Key: 1786   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p8jubnmc_1_1
  List of Datafiles in backup set 1786
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7    0  Incr 23572762394 29-OCT-08 /vnporadataUSERS/oradataUSERS/logvnp.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1787    Incr 0  294.36M    DISK        00:02:19     29-OCT-08
        BP Key: 1787   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p9jubnsf_1_1
  List of Datafiles in backup set 1787
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 23572820707 29-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1788    Incr 0  5.83G      DISK        00:53:24     29-OCT-08
        BP Key: 1788   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p6jublj9_1_1
  List of Datafiles in backup set 1788
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/system01.dbf
  2    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/undotbs01.dbf
  3    0  Incr 23572220508 29-OCT-08 /vnporadataSYSTEM/VNP/sysaux01.dbf
  4    0  Incr 23572220508 29-OCT-08 /vnporadataUSERS/oradataUSERS/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1793    Incr 1  68.70M     DISK        00:00:44     29-OCT-08
        BP Key: 1793   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T1215
18
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pejuc06m_1_1
  List of Datafiles in backup set 1793
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 23575182489 29-OCT-08 /vnporadataSYSTEM/VNP/system01.dbf
  2    1  Incr 23575182489 29-OCT-08 /vnporadataSYSTEM/VNP/undotbs01.dbf
  3    1  Incr 23575182489 29-OCT-08 /vnporadataSYSTEM/VNP/sysaux01.dbf
  4    1  Incr 23575182489 29-OCT-08 /vnporadataUSERS/oradataUSERS/users01.dbf
  5    1  Incr 23575182489 29-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf
  6    1  Incr 23575182489 29-OCT-08 /vnporadataUSERS/oradataUSERS/users02.dbf
  7    1  Incr 23575182489 29-OCT-08 /vnporadataUSERS/oradataUSERS/logvnp.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1798    Incr 1  28.63M     DISK        00:00:42     30-OCT-08
        BP Key: 1798   Status: AVAILABLE  Compressed: YES  Tag: TAG20081030T0912
41
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pkjue9s9_1_1
  List of Datafiles in backup set 1798
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    1  Incr 23596779347 30-OCT-08 /vnporadataUSERS/oradataUSERS/users02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1799    Incr 1  32.00K     DISK        00:00:00     30-OCT-08
        BP Key: 1799   Status: AVAILABLE  Compressed: YES  Tag: TAG20081030T0912
41
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pljue9tn_1_1
  List of Datafiles in backup set 1799
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7    1  Incr 23596788117 30-OCT-08 /vnporadataUSERS/oradataUSERS/logvnp.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1800    Incr 1  6.75M      DISK        00:00:04     30-OCT-08
        BP Key: 1800   Status: AVAILABLE  Compressed: YES  Tag: TAG20081030T0912
41
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pmjue9to_1_1
  List of Datafiles in backup set 1800
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    1  Incr 23596788125 30-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1801    Incr 1  1.75G      DISK        00:15:08     30-OCT-08
        BP Key: 1801   Status: AVAILABLE  Compressed: YES  Tag: TAG20081030T0912
41
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pjjue9s9_1_1
  List of Datafiles in backup set 1801
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 23596779345 30-OCT-08 /vnporadataSYSTEM/VNP/system01.dbf
  2    1  Incr 23596779345 30-OCT-08 /vnporadataSYSTEM/VNP/undotbs01.dbf
  3    1  Incr 23596779345 30-OCT-08 /vnporadataSYSTEM/VNP/sysaux01.dbf
  4    1  Incr 23596779345 30-OCT-08 /vnporadataUSERS/oradataUSERS/users01.dbf

RMAN>

and then, I re-test with manual command

2> allocate channel d1 type disk;
3> backup tablespace "TOOL" plus archivelog
4> tag=VNP_TOOL_DBF
5> format '/vnprctl/backupFullVNP/TOOL_%d_%s_%t_%u.bkp';
6> release channel d1;
7> }

allocated channel: d1
channel d1: sid=1018 devtype=DISK


Starting backup at 30-OCT-08
current log archived
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_826_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_826_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_827_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_827_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_828_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_828_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_829_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_829_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_830_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_830_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_831_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_831_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_832_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_832_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_833_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_833_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_834_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_834_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_835_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_835_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_836_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_836_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_837_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_837_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_838_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_838_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_839_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_839_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_840_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_840_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_841_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_841_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_842_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_842_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_843_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_843_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_844_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_844_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_845_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_845_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_846_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_846_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_847_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_847_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_848_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_848_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_849_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_849_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_850_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_850_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest1/1_851_650457529.arc;
 already backed up 2 time(s)
skipping archive log file /vnporadataUSERS/archiveVNP_dest2/1_851_650457529.arc;
 already backed up 2 time(s)
channel d1: starting archive log backupset
channel d1: specifying archive log(s) in backup set
input archive log thread=1 sequence=852 recid=1629 stamp=669462885
input archive log thread=1 sequence=853 recid=1631 stamp=669463578
input archive log thread=1 sequence=854 recid=1633 stamp=669466299
input archive log thread=1 sequence=855 recid=1635 stamp=669468214
channel d1: starting piece 1 at 30-OCT-08
channel d1: finished piece 1 at 30-OCT-08
piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pqjuehhv_1_1 tag=TAG2
0081030T112343 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:35
Finished backup at 30-OCT-08

Starting backup at 30-OCT-08
current log archived
channel d1: starting archive log backupset
channel d1: specifying archive log(s) in backup set
input archive log thread=1 sequence=856 recid=1638 stamp=669468259
channel d1: starting piece 1 at 30-OCT-08
channel d1: finished piece 1 at 30-OCT-08
piece handle=/vnprctl/backupFullVNP/TOOL_VNP_1851_669468259_prjuehj3.bkp tag=VNP
_TOOL_DBF comment=NONE
channel d1: backup set complete, elapsed time: 00:00:02
Finished backup at 30-OCT-08

Starting Control File and SPFILE Autobackup at 30-OCT-08
piece handle=/u02/app/oracle/oracle/product/10.2.0/NEO/dbs/c-54722743-20081030-0
1 comment=NONE
Finished Control File and SPFILE Autobackup at 30-OCT-08

released channel: d1

RMAN>

Now, where is the backup_piece of tablespace TOOL?

RMAN> list backup of tablespace "TOOL";


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1787    Incr 0  294.36M    DISK        00:02:19     29-OCT-08
        BP Key: 1787   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T0914
16
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/p9jubnsf_1_1
  List of Datafiles in backup set 1787
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 23572820707 29-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1793    Incr 1  68.70M     DISK        00:00:44     29-OCT-08
        BP Key: 1793   Status: AVAILABLE  Compressed: YES  Tag: TAG20081029T1215
18
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pejuc06m_1_1
  List of Datafiles in backup set 1793
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    1  Incr 23575182489 29-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1800    Incr 1  6.75M      DISK        00:00:04     30-OCT-08
        BP Key: 1800   Status: AVAILABLE  Compressed: YES  Tag: TAG20081030T0912
41
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pmjue9to_1_1
  List of Datafiles in backup set 1800
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    1  Incr 23596788125 30-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1805    Full    1.39G      DISK        00:00:32     30-OCT-08
        BP Key: 1805   Status: AVAILABLE  Compressed: NO  Tag: TAG20081030T11234
3
        Piece Name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pqjuehhv_1_1
  List of Datafiles in backup set 1805
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 23598335508 30-OCT-08 /vnporadataUSERS/oradataUSERS/tool.dbf

RMAN>

Piece name: /u02/app/oracle/oracle/product/10.2.0/NEO/dbs/pqjuehhv_1_1

Backup_location_file:

RMAN> host;
$ ls -l /vnprctl/backupFullVNP/T*
-rw-r-----   1 oracle   dba      217720320 Oct 30 11:23 /vnprctl/backupFullVNP/T
OOL_VNP_1849_669468215_ppjuehhn.bkp
-rw-r-----   1 oracle   dba       150528 Oct 30 11:24 /vnprctl/backupFullVNP/TOO
L_VNP_1851_669468259_prjuehj3.bkp
$

30-10: Today, and this is the newest file.

And, I have just found that, the initialization parameter
db_flashback_retetion_target was set before, but the database was not configured with FLASHBACK database option.

sys@VNP> set pagesize 6000
sys@VNP> set linesize 600
sys@VNP> col NAME format a30
sys@VNP> col VALUE format 99999
sys@VNP> select name, value
  2  from v$parameter
  3  where name like 'db_re%';
NAME                           VALUE
------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
db_recycle_cache_size          0
db_recovery_file_dest
db_recovery_file_dest_size     42949672960

sys@VNP>

I though, may be it - the RMAN understands that, the recovery area would be backed up with.

May you clarify more?

Thank you!

[Updated on: Thu, 30 October 2008 04:52]

Report message to a moderator

Re: I think something wrong with my rman_script! [message #356335 is a reply to message #356199]

Thu, 30 October 2008 07:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
You are using controlfile autobackup which will use $ORACLE_HOME/dbs by default unless you specify some other area.
You are using two channels to backup and but set parallelism to 1.
A simpler test would be doing things a little manual.
something like this

 run {
        allocate channel disk1 type disk format 'yourlocation/format';
        allocate channel disk2 type disk format 'yourlocation/format'
        backup database and all the rest options
   }

Report message to a moderator

Re: I think something wrong with my rman_script! [message #356510 is a reply to message #356335]

Thu, 30 October 2008 23:35

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

oh, thank you very much!

I've forgotten to allocate parallelism in my script.

I'll feedback when I finish this job.

Thanks again!

Report message to a moderator

Re: I think something wrong with my rman_script! [message #356857 is a reply to message #356510]

Sun, 02 November 2008 21:49

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

@Mahesh Rajendran: Thank you very much, I've just resolved this my tasks. All of the backup pieces were placed at right location.

Thank again!

Report message to a moderator

Previous Topic:	mount data files
Next Topic:	standby recovery help please

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 01:08:40 CDT 2024