OraFAQ Forum: Backup & Recovery » We got a trouble with catalog

Home » RDBMS Server » Backup & Recovery » We got a trouble with catalog (Oracle 11.2.0.1, Sun Sparc)

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

We got a trouble with catalog [message #569143]

Sun, 21 October 2012 07:04

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

Senior Member

Hi everyone!

First, I describe the tasks following:

1- I've got one single database (11.2.0.1 with grid, the owner of database and grid is same: oracle). All of datafile was belonged to SAN FC(ASM) were normal, the Database had been being worked at that time (10/18/2012). Because of problem OS - internal disk missing system file, I decided to re-install new OS. Of course I backup Database at level 0 (compressed method) with RMAN (strategy: recovery window of 7 days). I've got the full backup and copied them to another machine.

2- After I re-install new OS on, re-install Grid, Oracle Server, some configuration objects, .. then I gone to re-build Database from backup.
2.1. Make directories under ASM such as: controlfile, datafile, onlinelog, ... : '+DATA/ssp/...' same to the old data group.
2.2. Restore controlfile to +DATA/ssp/controlfile successfully
2.3. Mounted database successfully
2.4. Catalog backup with new location (/data/app/ssp/sspbkp/) successfully
2.5. Catalog all of archivelog with new location (/data/app/ssp/ssparc') successfully

However, I can not restore database because:

RMAN> crosscheck backup;
RMAN> delete expired archivelog all;
RMAN> delete expired backup;
RMAN> list archivelog all;
RMAN> list backupset;
RMAN> list backup recoverable;

The result of list backup or list backup recoverable show me all of backup piece with new location (/data/app/sspbkp/)

But RMAN did not show any result when I execute: RMAN> list backup of database;

Will you verify me some thing to make I can restore/recover database?

Thank you very much!

Report message to a moderator

Re: We got a trouble with catalog [message #569146 is a reply to message #569143]

Sun, 21 October 2012 09:09

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

Senior Member

1- Delete old controlfile, recreate directory under ASM

$ echo $ORA_GRID_HOME
/data/app/oracle/grid
$ export ORACLE_HOME=/data/app/oracle/grid
$ echo $ORACLE_HOME
/data/app/oracle/grid
$ export ORACLE_SID=+ASM
$ asmcmd
ASMCMD> cd data
ASMCMD> cd dktt
ASMCMD> cd controlfile
ASMCMD> ls -l
Type         Redund  Striped  Time             Sys  Name
CONTROLFILE  UNPROT  FINE     OCT 21 20:00:00  Y    current.256.797278757
                                               N    current.ctl => +DATA/dktt/controlfile/current.256.797278757
ASMCMD> rm -f current*
ORA-15032: not all alterations performed
ORA-15173: entry 'current.ctl' does not exist in directory 'controlfile' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
ASMCMD> pwd

2- Remove the line "controlfile" in init pfile

$ vi $HOME/initdktt.ora
"/data/app/initdktt.ora" 18 lines, 559 characters
*.audit_file_dest='/data/app/oracle/admin/dktt/adump'
*.audit_trail='db'
*.compatible='11.2.0.1.0'
# *.control_files='+DATA/dktt/controlfile/current.ctl' <<-- Comment this line
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='dktt'
*.diagnostic_dest='/data/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dkttXDB)'
*.log_archive_dest_1='LOCATION=/data/app/dkttarc'
*.log_archive_format='dktt_%s_%r_%t.arc'
*.memory_target=16106127360
*.open_cursors=300
*.processes=450
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=500
*.undo_tablespace='UNDOTBS1'

3- Using RMAN startup nomount

$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 21 20:43:18 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount pfile='/data/app/initdktt.ora';

Oracle instance started

Total System Global Area   16039002112 bytes

Fixed Size                     2163920 bytes
Variable Size               7952407344 bytes
Database Buffers            7918845952 bytes
Redo Buffers                 165584896 bytes

RMAN>

4- Verify the backup file

$ pwd
/data/app/dkttbkp/dkttbkp
$ ls -lrt
total 455688
-rw-r--r--   1 oracle   oinstall 9592320 Oct 18 15:34 full_DKTT_0hno2pnj_1_1
-rw-r--r--   1 oracle   oinstall 14466048 Oct 18 15:34 full_DKTT_0ino2pnj_1_1
-rw-r--r--   1 oracle   oinstall 14249472 Oct 18 15:34 full_DKTT_0gno2pnj_1_1
-rw-r--r--   1 oracle   oinstall 14337024 Oct 18 15:34 full_DKTT_0jno2po3_1_1
-rw-r--r--   1 oracle   oinstall 14991872 Oct 18 15:34 full_DKTT_0lno2po4_1_1
-rw-r--r--   1 oracle   oinstall 14371328 Oct 18 15:34 full_DKTT_0kno2po3_1_1
-rw-r--r--   1 oracle   oinstall 4899840 Oct 18 15:34 full_DKTT_0nno2poj_1_1
-rw-r--r--   1 oracle   oinstall 6261760 Oct 18 15:34 full_DKTT_0ono2pok_1_1
-rw-r--r--   1 oracle   oinstall 11752960 Oct 18 15:34 full_DKTT_0mno2poj_1_1
-rw-r--r--   1 oracle   oinstall 4909568 Oct 18 15:34 full_DKTT_0pno2por_1_1
-rw-r--r--   1 oracle   oinstall 6772224 Oct 18 15:34 full_DKTT_0qno2pos_1_1
-rw-r--r--   1 oracle   oinstall 6241792 Oct 18 15:35 full_DKTT_0rno2pov_1_1
-rw-r--r--   1 oracle   oinstall 6175744 Oct 18 15:35 full_DKTT_0sno2pp1_1_1
-rw-r--r--   1 oracle   oinstall 4806144 Oct 18 15:35 full_DKTT_0tno2pp4_1_1
-rw-r--r--   1 oracle   oinstall 6144512 Oct 18 15:35 full_DKTT_0uno2pp6_1_1
-rw-r--r--   1 oracle   oinstall 4857856 Oct 18 15:35 full_DKTT_11no2ppc_1_1
-rw-r--r--   1 oracle   oinstall 7933440 Oct 18 15:35 full_DKTT_10no2ppb_1_1
-rw-r--r--   1 oracle   oinstall 11201536 Oct 18 15:35 full_DKTT_0vno2pp7_1_1
-rw-r--r--   1 oracle   oinstall 4868096 Oct 18 15:35 full_DKTT_12no2ppk_1_1
-rw-r--r--   1 oracle   oinstall 4898816 Oct 18 15:35 full_DKTT_14no2ppk_1_1
-rw-r--r--   1 oracle   oinstall 8113664 Oct 18 15:35 full_DKTT_13no2ppk_1_1
-rw-r--r--   1 oracle   oinstall 4836352 Oct 18 15:35 full_DKTT_16no2pps_1_1
-rw-r--r--   1 oracle   oinstall 4884480 Oct 18 15:35 full_DKTT_15no2pps_1_1
-rw-r--r--   1 oracle   oinstall 4820480 Oct 18 15:35 full_DKTT_17no2ppt_1_1
-rw-r--r--   1 oracle   oinstall 4880384 Oct 18 15:35 full_DKTT_18no2pq4_1_1
-rw-r--r--   1 oracle   oinstall 6927360 Oct 18 15:35 full_DKTT_19no2pq5_1_1
-rw-r--r--   1 oracle   oinstall 2505216 Oct 18 15:35 full_DKTT_1bno2pqd_1_1
-rw-r--r--   1 oracle   oinstall 12038144 Oct 18 15:35 full_DKTT_1ano2pq5_1_1
-rw-r--r--   1 oracle   oinstall   36352 Oct 18 15:49 full_DKTT_1eno2qkq_1_1
-rw-r--r--   1 oracle   oinstall 10190848 Oct 18 15:49 ctl_1fno2qks_1_1
$

5- Using RMAN restore controlfile, add controlfile line in init pfile, startup mount

RMAN> restore controlfile to '+DATA/dktt/controlfile/current.ctl'
2> from '/data/app/dkttbkp/dkttbkp/ctl_1fno2qks_1_1';

Starting restore at 21-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=217 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 21-OCT-12

RMAN> shutdown immediate

Oracle instance shut down

RMAN> exit


Recovery Manager complete.
$ vi $HOME/initdktt.ora
"/data/app/initdktt.ora" 17 lines, 506 characters
*.audit_file_dest='/data/app/oracle/admin/dktt/adump'
*.audit_trail='db'
*.compatible='11.2.0.1.0'
*.control_files='+DATA/dktt/controlfile/current.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='dktt'
*.diagnostic_dest='/data/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dkttXDB)'
*.log_archive_dest_1='LOCATION=/data/app/dkttarc'
*.log_archive_format='dktt_%s_%r_%t.arc'
*.memory_target=16106127360
*.open_cursors=300
*.processes=450
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=500
*.undo_tablespace='UNDOTBS1'
~
~
~
~
~
"/data/app/initdktt.ora" 18 lines, 559 characters
$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 21 20:49:31 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> startup mount pfile='/data/app/initdktt.ora'

Oracle instance started
database mounted

Total System Global Area   16039002112 bytes

Fixed Size                     2163920 bytes
Variable Size               7952407344 bytes
Database Buffers            7918845952 bytes
Redo Buffers                 165584896 bytes

RMAN>

6- Crosscheck expired backup, archivelog

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DKTT     1326922654       PARENT  1          02-NOV-09
2       2       DKTT     1326922654       CURRENT 933501     28-AUG-12

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=241 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=247 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=253 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0hno2pnj_1_1 RECID=16 STAMP=797009651
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0gno2pnj_1_1 RECID=17 STAMP=797009651
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0ino2pnj_1_1 RECID=18 STAMP=797009651
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0jno2po3_1_1 RECID=19 STAMP=797009667
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0kno2po3_1_1 RECID=20 STAMP=797009667
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0lno2po4_1_1 RECID=21 STAMP=797009668
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0nno2poj_1_1 RECID=22 STAMP=797009683
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0ono2pok_1_1 RECID=23 STAMP=797009684
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0mno2poj_1_1 RECID=24 STAMP=797009683
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0pno2por_1_1 RECID=25 STAMP=797009691
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0qno2pos_1_1 RECID=26 STAMP=797009692
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0rno2pov_1_1 RECID=27 STAMP=797009695
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0sno2pp1_1_1 RECID=28 STAMP=797009697
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0tno2pp4_1_1 RECID=29 STAMP=797009700
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0uno2pp6_1_1 RECID=30 STAMP=797009702
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_11no2ppc_1_1 RECID=31 STAMP=797009708
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_10no2ppb_1_1 RECID=32 STAMP=797009707
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_0vno2pp7_1_1 RECID=33 STAMP=797009703
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_12no2ppk_1_1 RECID=34 STAMP=797009716
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_14no2ppk_1_1 RECID=35 STAMP=797009716
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_13no2ppk_1_1 RECID=36 STAMP=797009716
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_15no2pps_1_1 RECID=37 STAMP=797009724
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_16no2pps_1_1 RECID=38 STAMP=797009724
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_17no2ppt_1_1 RECID=39 STAMP=797009725
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_18no2pq4_1_1 RECID=40 STAMP=797009732
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_19no2pq5_1_1 RECID=41 STAMP=797009733
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_1bno2pqd_1_1 RECID=42 STAMP=797009741
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_1ano2pq5_1_1 RECID=43 STAMP=797009733
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/app/product/11.2.0/dktt/dbs/1cno2pql_1_1 RECID=44 STAMP=797009749
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/app/product/11.2.0/dktt/dbs/1dno2pql_1_1 RECID=45 STAMP=797009750
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u04/dkttbkp/full_DKTT_1eno2qkq_1_1 RECID=46 STAMP=797010586
Crosschecked 31 objects

RMAN> delete expired backup;

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
16      16      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0hno2pnj_1_1
17      17      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0gno2pnj_1_1
18      18      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0ino2pnj_1_1
19      19      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0jno2po3_1_1
20      20      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0kno2po3_1_1
21      21      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0lno2po4_1_1
22      22      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0nno2poj_1_1
23      23      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0ono2pok_1_1
24      24      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0mno2poj_1_1
25      25      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0pno2por_1_1
26      26      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0qno2pos_1_1
27      27      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0rno2pov_1_1
28      28      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0sno2pp1_1_1
29      29      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0tno2pp4_1_1
30      30      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0uno2pp6_1_1
31      31      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_11no2ppc_1_1
32      32      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_10no2ppb_1_1
33      33      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_0vno2pp7_1_1
34      34      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_12no2ppk_1_1
35      35      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_14no2ppk_1_1
36      36      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_13no2ppk_1_1
37      37      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_15no2pps_1_1
38      38      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_16no2pps_1_1
39      39      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_17no2ppt_1_1
40      40      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_18no2pq4_1_1
41      41      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_19no2pq5_1_1
42      42      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_1bno2pqd_1_1
43      43      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_1ano2pq5_1_1
44      44      1   1   EXPIRED     DISK        /u03/app/product/11.2.0/dktt/dbs/1cno2pql_1_1
45      45      1   1   EXPIRED     DISK        /u03/app/product/11.2.0/dktt/dbs/1dno2pql_1_1
46      46      1   1   EXPIRED     DISK        /u04/dkttbkp/full_DKTT_1eno2qkq_1_1

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_17no2ppt_1_1 RECID=39 STAMP=797009725
deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_18no2pq4_1_1 RECID=40 STAMP=797009732
deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_19no2pq5_1_1 RECID=41 STAMP=797009733
deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_1bno2pqd_1_1 RECID=42 STAMP=797009741
deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_1ano2pq5_1_1 RECID=43 STAMP=797009733
deleted backup piece
backup piece handle=/u03/app/product/11.2.0/dktt/dbs/1cno2pql_1_1 RECID=44 STAMP=797009749
deleted backup piece
backup piece handle=/u03/app/product/11.2.0/dktt/dbs/1dno2pql_1_1 RECID=45 STAMP=797009750
deleted backup piece
backup piece handle=/u04/dkttbkp/full_DKTT_1eno2qkq_1_1 RECID=46 STAMP=797010586
Deleted 31 EXPIRED objects

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=241 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=247 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=253 device type=DISK
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1787_792512417.dbf RECID=1 STAMP=797000741
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1788_792512417.dbf RECID=2 STAMP=797000763
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1789_792512417.dbf RECID=3 STAMP=797000820
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1790_792512417.dbf RECID=4 STAMP=797000859
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1791_792512417.dbf RECID=5 STAMP=797000903
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1792_792512417.dbf RECID=6 STAMP=797000933
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1793_792512417.dbf RECID=7 STAMP=797000969
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1794_792512417.dbf RECID=8 STAMP=797001040
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1795_792512417.dbf RECID=9 STAMP=797001060
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1796_792512417.dbf RECID=10 STAMP=797001071
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1797_792512417.dbf RECID=11 STAMP=797001084
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1798_792512417.dbf RECID=12 STAMP=797001100
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1799_792512417.dbf RECID=13 STAMP=797001110
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1800_792512417.dbf RECID=14 STAMP=797001121
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1801_792512417.dbf RECID=15 STAMP=797001132
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1802_792512417.dbf RECID=16 STAMP=797001142
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1803_792512417.dbf RECID=17 STAMP=797001159
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1804_792512417.dbf RECID=18 STAMP=797001170
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1805_792512417.dbf RECID=19 STAMP=797001187
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1806_792512417.dbf RECID=20 STAMP=797001203
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1807_792512417.dbf RECID=21 STAMP=797001216
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1808_792512417.dbf RECID=22 STAMP=797001227
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1809_792512417.dbf RECID=23 STAMP=797001237
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1810_792512417.dbf RECID=24 STAMP=797001247
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1811_792512417.dbf RECID=25 STAMP=797001263
validation failed for archived log
archived log file name=/u04/dkttarchivelog/1_1812_792512417.dbf RECID=26 STAMP=797001274
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1813_792512417.arc RECID=27 STAMP=797001608
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1814_792512417.arc RECID=28 STAMP=797001630
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1815_792512417.arc RECID=29 STAMP=797001667
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1816_792512417.arc RECID=30 STAMP=797001680
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1817_792512417.arc RECID=31 STAMP=797001691
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1818_792512417.arc RECID=32 STAMP=797001702
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1819_792512417.arc RECID=33 STAMP=797001714
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1820_792512417.arc RECID=34 STAMP=797001732
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1821_792512417.arc RECID=35 STAMP=797001746
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1822_792512417.arc RECID=36 STAMP=797001755
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1823_792512417.arc RECID=37 STAMP=797001763
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1824_792512417.arc RECID=38 STAMP=797001770
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1825_792512417.arc RECID=39 STAMP=797001779
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1826_792512417.arc RECID=40 STAMP=797001786
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1827_792512417.arc RECID=41 STAMP=797001794
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1828_792512417.arc RECID=42 STAMP=797001801
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1829_792512417.arc RECID=43 STAMP=797001809
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1830_792512417.arc RECID=44 STAMP=797001817
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1831_792512417.arc RECID=45 STAMP=797001824
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1832_792512417.arc RECID=46 STAMP=797001839
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1833_792512417.arc RECID=47 STAMP=797001847
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1834_792512417.arc RECID=48 STAMP=797001856
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1835_792512417.arc RECID=49 STAMP=797002065
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1836_792512417.arc RECID=50 STAMP=797003026
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1837_792512417.arc RECID=51 STAMP=797009642
validation failed for archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1838_792512417.arc RECID=52 STAMP=797010585
Crosschecked 52 objects


RMAN> delete expired archivelog all;
22      1    1808    X 18-OCT-12
        Name: /u04/dkttarchivelog/1_1808_792512417.dbf

23      1    1809    X 18-OCT-12
        Name: /u04/dkttarchivelog/1_1809_792512417.dbf

24      1    1810    X 18-OCT-12
        Name: /u04/dkttarchivelog/1_1810_792512417.dbf

25      1    1811    X 18-OCT-12
        Name: /u04/dkttarchivelog/1_1811_792512417.dbf

26      1    1812    X 18-OCT-12
        Name: /u04/dkttarchivelog/1_1812_792512417.dbf

27      1    1813    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1813_792512417.arc

28      1    1814    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1814_792512417.arc

29      1    1815    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1815_792512417.arc

30      1    1816    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1816_792512417.arc

31      1    1817    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1817_792512417.arc

32      1    1818    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1818_792512417.arc

33      1    1819    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1819_792512417.arc

34      1    1820    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1820_792512417.arc

35      1    1821    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1821_792512417.arc

36      1    1822    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1822_792512417.arc

37      1    1823    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1823_792512417.arc

38      1    1824    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1824_792512417.arc

39      1    1825    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1825_792512417.arc

40      1    1826    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1826_792512417.arc

41      1    1827    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1827_792512417.arc

42      1    1828    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1828_792512417.arc

43      1    1829    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1829_792512417.arc

44      1    1830    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1830_792512417.arc

45      1    1831    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1831_792512417.arc

46      1    1832    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1832_792512417.arc

47      1    1833    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1833_792512417.arc

48      1    1834    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1834_792512417.arc

49      1    1835    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1835_792512417.arc

50      1    1836    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1836_792512417.arc

51      1    1837    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1837_792512417.arc

52      1    1838    X 18-OCT-12
        Name: /u04/dkttarchivelog/dktt_1_1838_792512417.arc


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1830_792512417.arc RECID=44 STAMP=797001817
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1831_792512417.arc RECID=45 STAMP=797001824
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1832_792512417.arc RECID=46 STAMP=797001839
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1833_792512417.arc RECID=47 STAMP=797001847
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1834_792512417.arc RECID=48 STAMP=797001856
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1835_792512417.arc RECID=49 STAMP=797002065
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1836_792512417.arc RECID=50 STAMP=797003026
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1837_792512417.arc RECID=51 STAMP=797009642
deleted archived log
archived log file name=/u04/dkttarchivelog/dktt_1_1838_792512417.arc RECID=52 STAMP=797010585
Deleted 52 EXPIRED objects

RMAN> list archivelog all;

specification does not match any archived log in the repository

RMAN> list backupset;

specification does not match any backup in the repository

RMAN>

7- Catalog with backup files

$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Oct 21 20:59:16 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DKTT (DBID=1326922654, not open)

RMAN> catalog start with '/data/app/dkttbkp/dkttbkp/';

using target database control file instead of recovery catalog
searching for all files that match the pattern /data/app/dkttbkp/dkttbkp/

List of Files Unknown to the Database
=====================================
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0gno2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/ctl_1fno2qks_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1eno2qkq_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0hno2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0ino2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0jno2po3_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0kno2po3_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0lno2po4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0mno2poj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0nno2poj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0ono2pok_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0pno2por_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0rno2pov_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0sno2pp1_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0tno2pp4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0uno2pp6_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0vno2pp7_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_10no2ppb_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_11no2ppc_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_12no2ppk_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_13no2ppk_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1ano2pq5_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1bno2pqd_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_19no2pq5_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_18no2pq4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_17no2ppt_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_15no2pps_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_16no2pps_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_14no2ppk_1_1

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0gno2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/ctl_1fno2qks_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1eno2qkq_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0hno2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0ino2pnj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0jno2po3_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0kno2po3_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0lno2po4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0mno2poj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0nno2poj_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0ono2pok_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0pno2por_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0rno2pov_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0sno2pp1_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0tno2pp4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0uno2pp6_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0vno2pp7_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_10no2ppb_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_11no2ppc_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_12no2ppk_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_13no2ppk_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1ano2pq5_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1bno2pqd_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_19no2pq5_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_18no2pq4_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_17no2ppt_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_15no2pps_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_16no2pps_1_1
File Name: /data/app/dkttbkp/dkttbkp/full_DKTT_14no2ppk_1_1

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=235 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=241 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=247 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0gno2pnj_1_1 RECID=47 STAMP=797288382
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/ctl_1fno2qks_1_1 RECID=48 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_1eno2qkq_1_1 RECID=49 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0hno2pnj_1_1 RECID=50 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0ino2pnj_1_1 RECID=51 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0jno2po3_1_1 RECID=52 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0kno2po3_1_1 RECID=53 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0lno2po4_1_1 RECID=54 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0mno2poj_1_1 RECID=55 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0nno2poj_1_1 RECID=56 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0ono2pok_1_1 RECID=57 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0pno2por_1_1 RECID=58 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1 RECID=59 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0rno2pov_1_1 RECID=60 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0sno2pp1_1_1 RECID=61 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0tno2pp4_1_1 RECID=62 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0uno2pp6_1_1 RECID=63 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_0vno2pp7_1_1 RECID=64 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_10no2ppb_1_1 RECID=65 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_11no2ppc_1_1 RECID=66 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_12no2ppk_1_1 RECID=67 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_13no2ppk_1_1 RECID=68 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_1ano2pq5_1_1 RECID=69 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_1bno2pqd_1_1 RECID=70 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_19no2pq5_1_1 RECID=71 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_18no2pq4_1_1 RECID=72 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_17no2ppt_1_1 RECID=73 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_15no2pps_1_1 RECID=74 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_16no2pps_1_1 RECID=75 STAMP=797288383
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/data/app/dkttbkp/dkttbkp/full_DKTT_14no2ppk_1_1 RECID=76 STAMP=797288383
Crosschecked 30 objects


RMAN>

And ...
9- Show all backupset in repository when listing backup, recoverable

RMAN> list backupset;
  1    1801    6016071    18-OCT-12 6016083    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
59      6.46M      DISK        00:00:00     18-OCT-12
        BP Key: 59   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1

  List of Archived Logs in backup set 59
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1802    6016083    18-OCT-12 6016093    18-OCT-12
  1    1803    6016093    18-OCT-12 6016111    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
60      5.95M      DISK        00:00:00     18-OCT-12
        BP Key: 60   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0rno2pov_1_1

  List of Archived Logs in backup set 60
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1804    6016111    18-OCT-12 6016121    18-OCT-12
  1    1805    6016121    18-OCT-12 6016135    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
61      5.89M      DISK        00:00:00     18-OCT-12
        BP Key: 61   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0sno2pp1_1_1

  List of Archived Logs in backup set 61
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1806    6016135    18-OCT-12 6016150    18-OCT-12
  1    1807    6016150    18-OCT-12 6016161    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
62      4.58M      DISK        00:00:00     18-OCT-12
        BP Key: 62   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0tno2pp4_1_1

  List of Archived Logs in backup set 62
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1808    6016161    18-OCT-12 6016170    18-OCT-12
  1    1809    6016170    18-OCT-12 6016181    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
63      5.86M      DISK        00:00:00     18-OCT-12
        BP Key: 63   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0uno2pp6_1_1

  List of Archived Logs in backup set 63
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1810    6016181    18-OCT-12 6016190    18-OCT-12
  1    1811    6016190    18-OCT-12 6016204    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
64      10.68M     DISK        00:00:00     18-OCT-12
        BP Key: 64   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0vno2pp7_1_1

  List of Archived Logs in backup set 64
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1812    6016204    18-OCT-12 6016214    18-OCT-12
  1    1813    6016214    18-OCT-12 6045726    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
65      7.57M      DISK        00:00:00     18-OCT-12
        BP Key: 65   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_10no2ppb_1_1

  List of Archived Logs in backup set 65
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1814    6045726    18-OCT-12 6055112    18-OCT-12
  1    1815    6055112    18-OCT-12 6060212    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
66      4.63M      DISK        00:00:00     18-OCT-12
        BP Key: 66   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_11no2ppc_1_1

  List of Archived Logs in backup set 66
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1816    6060212    18-OCT-12 6065164    18-OCT-12
  1    1817    6065164    18-OCT-12 6069793    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
67      4.64M      DISK        00:00:00     18-OCT-12
        BP Key: 67   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_12no2ppk_1_1

  List of Archived Logs in backup set 67
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1818    6069793    18-OCT-12 6074537    18-OCT-12
  1    1819    6074537    18-OCT-12 6079972    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
68      7.74M      DISK        00:00:00     18-OCT-12
        BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_13no2ppk_1_1

  List of Archived Logs in backup set 68
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1820    6079972    18-OCT-12 6081801    18-OCT-12
  1    1821    6081801    18-OCT-12 6081817    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
69      11.48M     DISK        00:00:00     18-OCT-12
        BP Key: 69   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1ano2pq5_1_1

  List of Archived Logs in backup set 69
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1834    6081971    18-OCT-12 6081980    18-OCT-12
  1    1835    6081980    18-OCT-12 6082285    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
70      2.39M      DISK        00:00:00     18-OCT-12
        BP Key: 70   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1bno2pqd_1_1

  List of Archived Logs in backup set 70
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1836    6082285    18-OCT-12 6083373    18-OCT-12
  1    1837    6083373    18-OCT-12 6086614    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
71      6.61M      DISK        00:00:00     18-OCT-12
        BP Key: 71   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_19no2pq5_1_1

  List of Archived Logs in backup set 71
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1832    6081927    18-OCT-12 6081955    18-OCT-12
  1    1833    6081955    18-OCT-12 6081971    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
72      4.65M      DISK        00:00:00     18-OCT-12
        BP Key: 72   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_18no2pq4_1_1

  List of Archived Logs in backup set 72
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1830    6081905    18-OCT-12 6081917    18-OCT-12
  1    1831    6081917    18-OCT-12 6081927    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
73      4.60M      DISK        00:00:00     18-OCT-12
        BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_17no2ppt_1_1

  List of Archived Logs in backup set 73
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1828    6081878    18-OCT-12 6081896    18-OCT-12
  1    1829    6081896    18-OCT-12 6081905    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74      4.66M      DISK        00:00:00     18-OCT-12
        BP Key: 74   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_15no2pps_1_1

  List of Archived Logs in backup set 74
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1824    6081842    18-OCT-12 6081851    18-OCT-12
  1    1825    6081851    18-OCT-12 6081859    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75      4.61M      DISK        00:00:00     18-OCT-12
        BP Key: 75   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_16no2pps_1_1

  List of Archived Logs in backup set 75
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1826    6081859    18-OCT-12 6081866    18-OCT-12
  1    1827    6081866    18-OCT-12 6081878    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76      4.67M      DISK        00:00:00     18-OCT-12
        BP Key: 76   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_14no2ppk_1_1

  List of Archived Logs in backup set 76
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1822    6081817    18-OCT-12 6081832    18-OCT-12
  1    1823    6081832    18-OCT-12 6081842    18-OCT-12

RMAN> list backup recoverable;
  1    1801    6016071    18-OCT-12 6016083    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
59      6.46M      DISK        00:00:00     18-OCT-12
        BP Key: 59   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1

  List of Archived Logs in backup set 59
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1802    6016083    18-OCT-12 6016093    18-OCT-12
  1    1803    6016093    18-OCT-12 6016111    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
60      5.95M      DISK        00:00:00     18-OCT-12
        BP Key: 60   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0rno2pov_1_1

  List of Archived Logs in backup set 60
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1804    6016111    18-OCT-12 6016121    18-OCT-12
  1    1805    6016121    18-OCT-12 6016135    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
61      5.89M      DISK        00:00:00     18-OCT-12
        BP Key: 61   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0sno2pp1_1_1

  List of Archived Logs in backup set 61
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1806    6016135    18-OCT-12 6016150    18-OCT-12
  1    1807    6016150    18-OCT-12 6016161    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
62      4.58M      DISK        00:00:00     18-OCT-12
        BP Key: 62   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0tno2pp4_1_1

  List of Archived Logs in backup set 62
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1808    6016161    18-OCT-12 6016170    18-OCT-12
  1    1809    6016170    18-OCT-12 6016181    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
63      5.86M      DISK        00:00:00     18-OCT-12
        BP Key: 63   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0uno2pp6_1_1

  List of Archived Logs in backup set 63
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1810    6016181    18-OCT-12 6016190    18-OCT-12
  1    1811    6016190    18-OCT-12 6016204    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
64      10.68M     DISK        00:00:00     18-OCT-12
        BP Key: 64   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_0vno2pp7_1_1

  List of Archived Logs in backup set 64
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1812    6016204    18-OCT-12 6016214    18-OCT-12
  1    1813    6016214    18-OCT-12 6045726    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
65      7.57M      DISK        00:00:00     18-OCT-12
        BP Key: 65   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_10no2ppb_1_1

  List of Archived Logs in backup set 65
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1814    6045726    18-OCT-12 6055112    18-OCT-12
  1    1815    6055112    18-OCT-12 6060212    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
66      4.63M      DISK        00:00:00     18-OCT-12
        BP Key: 66   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_11no2ppc_1_1

  List of Archived Logs in backup set 66
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1816    6060212    18-OCT-12 6065164    18-OCT-12
  1    1817    6065164    18-OCT-12 6069793    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
67      4.64M      DISK        00:00:00     18-OCT-12
        BP Key: 67   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_12no2ppk_1_1

  List of Archived Logs in backup set 67
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1818    6069793    18-OCT-12 6074537    18-OCT-12
  1    1819    6074537    18-OCT-12 6079972    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
68      7.74M      DISK        00:00:00     18-OCT-12
        BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_13no2ppk_1_1

  List of Archived Logs in backup set 68
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1820    6079972    18-OCT-12 6081801    18-OCT-12
  1    1821    6081801    18-OCT-12 6081817    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
69      11.48M     DISK        00:00:00     18-OCT-12
        BP Key: 69   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1ano2pq5_1_1

  List of Archived Logs in backup set 69
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1834    6081971    18-OCT-12 6081980    18-OCT-12
  1    1835    6081980    18-OCT-12 6082285    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
70      2.39M      DISK        00:00:00     18-OCT-12
        BP Key: 70   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_1bno2pqd_1_1

  List of Archived Logs in backup set 70
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1836    6082285    18-OCT-12 6083373    18-OCT-12
  1    1837    6083373    18-OCT-12 6086614    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
71      6.61M      DISK        00:00:00     18-OCT-12
        BP Key: 71   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_19no2pq5_1_1

  List of Archived Logs in backup set 71
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1832    6081927    18-OCT-12 6081955    18-OCT-12
  1    1833    6081955    18-OCT-12 6081971    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
72      4.65M      DISK        00:00:00     18-OCT-12
        BP Key: 72   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_18no2pq4_1_1

  List of Archived Logs in backup set 72
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1830    6081905    18-OCT-12 6081917    18-OCT-12
  1    1831    6081917    18-OCT-12 6081927    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
73      4.60M      DISK        00:00:00     18-OCT-12
        BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_17no2ppt_1_1

  List of Archived Logs in backup set 73
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1828    6081878    18-OCT-12 6081896    18-OCT-12
  1    1829    6081896    18-OCT-12 6081905    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
74      4.66M      DISK        00:00:00     18-OCT-12
        BP Key: 74   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_15no2pps_1_1

  List of Archived Logs in backup set 74
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1824    6081842    18-OCT-12 6081851    18-OCT-12
  1    1825    6081851    18-OCT-12 6081859    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
75      4.61M      DISK        00:00:00     18-OCT-12
        BP Key: 75   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_16no2pps_1_1

  List of Archived Logs in backup set 75
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1826    6081859    18-OCT-12 6081866    18-OCT-12
  1    1827    6081866    18-OCT-12 6081878    18-OCT-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76      4.67M      DISK        00:00:00     18-OCT-12
        BP Key: 76   Status: AVAILABLE  Compressed: YES  Tag: DKTT
        Piece Name: /data/app/dkttbkp/dkttbkp/full_DKTT_14no2ppk_1_1

  List of Archived Logs in backup set 76
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1822    6081817    18-OCT-12 6081832    18-OCT-12
  1    1823    6081832    18-OCT-12 6081842    18-OCT-12

RMAN>

10- But ...

RMAN> list backup of database;

specification does not match any backup in the repository

RMAN>

11- I tried to restore database, of course I did not

RMAN> restore database;

Starting restore at 21-OCT-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/21/2012 21:03:22
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> restore datafile 1 from '/data/app/dkttbkp/dkttbkp/full_DKTT_0qno2pos_1_1';

Starting restore at 21-OCT-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/21/2012 21:05:49
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

Do you have any idea to me?

Thank you very much!

Report message to a moderator

Re: We got a trouble with catalog [message #569165 is a reply to message #569146]

Sun, 21 October 2012 22:17

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

Senior Member

Hi everyone!
I found the problem cause, that is the missing copy backup from another machine to server, then I re-configure new db up now.

Thanks for your time

Report message to a moderator

Re: We got a trouble with catalog [message #569170 is a reply to message #569165]

Mon, 22 October 2012 01:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Previous Topic:	Cloning Doubt
Next Topic:	incremental rman backups (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 22:15:27 CST 2024