============================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS==============
RMAN-00571: ===================================================
RMAN-03002: failure of list command at 11/13/2015 04:00:00
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target
database not found in recovery catalog
From Production
$ ./rman target / catalog catman/pwd@catsserp
Recovery Manager: Release 11.2.0.4.0 - Production on Mon NOV 13 16:04:11 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: SSAERP (DBID=3389811866)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> report schema;
Report of database schema for database with db_unique_name SSAERP
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 610 SYSTEM YES /ora_dat/ssaerp/system01.dbf
2 25805 UNDOTBS1 YES /ora_dat/ssaerp/undotbs01.dbf
3 6720 SYSAUX NO /ora_dat/ssaerp/sysaux01.dbf
4 1020 USERS NO /ora_dat/ssaerp/users01.dbf
5 2048 SYSTEM YES /ora_dat/ssaerp/system02.dbf
6 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP01.dbf
7 10240 BAANIDX NO /ora_idx/ssaerp/xdb_SSAERP01.dbf
8 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP02.dbf
9 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP03.dbf
10 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP04.dbf
11 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP05.dbf
12 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP06.dbf
13 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP07.dbf
14 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP08.dbf
15 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP09.dbf
16 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP10.dbf
17 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP11.dbf
18 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP12.dbf
19 10240 BAANIDX NO /ora_idx/ssaerp/idb_SSAERP02.dbf
20 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP03.dbf
21 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP04.dbf
22 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP05.dbf
23 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP06.dbf
24 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP07.dbf
25 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP08.dbf
26 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP09.dbf
27 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP10.dbf
28 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP11.dbf
29 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP12.dbf
30 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP13.dbf
31 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP14.dbf
32 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP15.dbf
33 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP13.dbf
34 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP14.dbf
35 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP15.dbf
36 10240 BAANIDX NO /ora_dat/ssaerp/idx_SSAERP16.dbf
37 10240 BAANIDX NO /ora_dat/ssaerp/idx_SSAERP17
38 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP16.dbf
39 10240 BAANIDX NO /ora_dat/ssaerp/idx_SSAERP18.dbf
40 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP19.dbf
41 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP19.dbf
42 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP20.dbf
43 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP20.dbf
44 10240 BAANDAT NO /ora_dat/ssaerp/xdb_SSAERP21.dbf
45 10240 BAANIDX NO /ora_idx/ssaerp/idx_SSAERP21.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /ora_dat/ssaerp/temp01.dbf
2 30000 TEMP 30000 /ora_dat/ssaerp/temp02.dbf
3 30000 TEMP 30000 /ora_dat/ssaerp/temp03
4 500 TEMP 500 /ora_dat/ssaerp/temp04.dbf
5 30000 TEMP 30000 /ora_dat/ssaerp/temp05.dbf
6 30000 TEMP 30000 /ora_dat/ssaerp/temp06.dbf
RMAN>
No comments:
Post a Comment