|
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman catalog u90/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:28:24 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> connect catalog win90/oracle_4U@192.168.0.199:1521/utforcl.example.com
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected
RMAN> import catalog win90/oracle_4U@192.168.0.199:1521/utforcl.example.com
2> ;
Starting import catalog at 2017-08-19:21:29:29
connected to source recovery catalog database
import validation complete
database unregistered from the source recovery catalog
Finished import catalog at 2017-08-19:21:29:31
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:31:45 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn u90/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
2 1343950367 4
804 1347195613 806
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
2 1343950367 4
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ rman catalog u90/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:34:22 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> import catalog win90/oracle_4U@192.168.0.199:1521/utforcl.example.com no unregister;
Starting import catalog at 2017-08-19:21:34:48
connected to source recovery catalog database
import validation complete
Finished import catalog at 2017-08-19:21:34:50
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:35:10 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn u90/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
2 1343950367 4
1685 1347195613 1687
SQL> conn / as sysdba
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string orcl
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@station90 ~]$ . oraenv
ORACLE_SID = [orcl] ? rcat
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:39:20 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string rcat
SQL> create user v1 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.
SQL> create user v2 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.
SQL> create user v3 identified by oracle_4U default tablespace rcat quota unlimited on rcat ;
User created.
SQL> grant recovery_Catalog_owner to v1;
Grant succeeded.
SQL> grant recovery_Catalog_owner to v2;
Grant succeeded.
SQL> grant recovery_Catalog_owner to v3;
Grant succeeded.
SQL> conn u90/oracle_4U
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
2 1343950367 4
1685 1347195613 1687
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ rman catalog u90/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:43:43 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> grant catalog for database 1359978017 to v1 ;
Grant succeeded.
RMAN> grant catalog for database 1343950367 to v2 ;
Grant succeeded.
RMAN> grant catalog for database 1347195613 to v3 ;
Grant succeeded.
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:46:27 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog ;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:47:15 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog ;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog u90/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:48:00 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> grant catalog for database 1359978017 to v1 ;
Grant succeeded.
RMAN> grant catalog for database 1343950367 to v2 ;
Grant succeeded.
RMAN> grant catalog for database 1347195613 to v3 ;
Grant succeeded.
RMAN> connect catalog v1/oracle_4U@rcat
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:48:48 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog ;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v2/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:49:03 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog ;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:50:48 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn v1/oracle_4U@rcat
Connected.
SQL> select * from tab;
no rows selected
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:51:03 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog ;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
出现以上报错的原因是U90里头已经注册的莫个库,在U3/U9/U15中也重复注册了。应该是修钦的数据库那个dbid。
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog u90/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:52:58 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> grant register database to v1;
Grant succeeded.
RMAN> grant register database to v2;
Grant succeeded.
RMAN> grant register database to v3;
Grant succeeded.
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:53:17 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by U90
found ineligible base catalog owned by U3
found ineligible base catalog owned by U9
found ineligible base catalog owned by U15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20015: not authorized to share this catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:53:50 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> drop user u3 cascade ;
User dropped.
SQL> drop user u9 cascade ;
drop user u9 cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> drop user u15 cascade ;
User dropped.
SQL> drop user u9 cascade ;
drop user u9 cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select sid,serial# from v$session where username='U9';
SID SERIAL#
---------- ----------
313 43
SQL> alter system kill session '313,43' immediate ;
System altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:55:08 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> drop user u9 cascade ;
User dropped.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ rman catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:55:25 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by U90
created virtual catalog against base catalog owned by U90
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v2/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:55:39 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by U90
created virtual catalog against base catalog owned by U90
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman catalog v3/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:56:05 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by U90
created virtual catalog against base catalog owned by U90
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:56:35 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn v1/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
SQL> conn v2/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
2 1343950367 4
SQL> conn v3/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
1685 1347195613 1687
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 19 21:57:36 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn u90/oracle_4U@rcat
Connected.
SQL> select * from db;
DB_KEY DB_ID CURR_DBINC_KEY
---------- ---------- --------------
130 1359978017 131
2 1343950367 4
1685 1347195613 1687
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@station90 ~]$ rman target / v1/oracle_4U@rcat
Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "identifier": expecting one of: "append, auxiliary, catalog, checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target, timeout, using, @, ;"
RMAN-01008: the bad identifier was: v1
RMAN-01007: at line 2 column 1 file: command line arguments
[oracle@station90 ~]$ rman target / catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:58:08 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCAT (DBID=590260915)
connected to recovery catalog database
RMAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/19/2017 21:58:13
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman target / catalog v2/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:58:20 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RCAT (DBID=590260915)
connected to recovery catalog database
RMAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/19/2017 21:58:23
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ . oraenv
ORACLE_SID = [rcat] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@station90 ~]$ rman target / catalog v1/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:58:36 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1343950367)
connected to recovery catalog database
RMAN> list backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/19/2017 21:58:38
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog
RMAN> exit
Recovery Manager complete.
[oracle@station90 ~]$ rman target / catalog v2/oracle_4U@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 21:58:49 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1343950367)
connected to recovery catalog database
RMAN> list backup;
user interrupt received
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/19/2017 21:59:50
RMAN-06004: ORACLE error from recovery catalog database: ORA-01013: user requested cancel of current operation
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
97 10.25M SBT_TAPE 00:00:15 2017-05-18:16:42:49
BP Key: 105 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
Handle: 11s4ih3q_1_1 Media: station90-000001
List of Archived Logs in backup set 97
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 18 1053749 2017-05-18:16:25:05 1057190 2017-05-18:16:42:22
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
98 Incr 0 502.25M SBT_TAPE 00:00:20 2017-05-18:16:43:19
BP Key: 106 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
Handle: 13s4ih4j_1_1 Media: station90-000002
List of Datafiles in backup set 98
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 0 Incr 1057424 2017-05-18:16:43:00 +DATA/orcl/datafile/sysaux.257.816169553
3 0 Incr 1057424 2017-05-18:16:43:00 +DATA/orcl/datafile/undotbs1.258.816169553
4 0 Incr 1057424 2017-05-18:16:43:00 +DATA/orcl/datafile/users.259.816169553
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
99 Incr 0 657.75M SBT_TAPE 00:00:27 2017-05-18:16:43:26
BP Key: 107 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
Handle: 12s4ih4j_1_1 Media: station90-000001
List of Datafiles in backup set 99
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 1057421 2017-05-18:16:42:59 +DATA/orcl/datafile/system.256.816169553
5 0 Incr 1057421 2017-05-18:16:42:59 +DATA/orcl/datafile/example.265.816169651
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
100 2.00M SBT_TAPE 00:00:15 2017-05-18:16:43:50
BP Key: 108 Status: AVAILABLE Compressed: NO Tag: 0T_INCR0_WHOLE
Handle: 14s4ih5n_1_1 Media: station90-000001
List of Archived Logs in backup set 100
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 19 1057190 2017-05-18:16:42:22 1057470 2017-05-18:16:43:34
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
101 Full 9.50M SBT_TAPE 00:00:16 2017-05-18:16:44:16
BP Key: 109 Status: AVAILABLE Compressed: NO Tag: TAG20170518T164400
Handle: c-1343950367-20170518-00 Media: station90-000001
SPFILE Included: Modification time: 2017-05-18:16:21:50
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1057507 Ckp time: 2017-05-18:16:44:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
102 Full 9.36M DISK 00:00:00 2017-08-19:20:30:07
BP Key: 110 Status: AVAILABLE Compressed: NO Tag: TAG20170819T203007
Piece Name: +FRA/orcl/autobackup/2017_08_19/s_952461007.261.952461007
SPFILE Included: Modification time: 2017-08-19:19:59:16
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1062266 Ckp time: 2017-08-19:20:30:07
BS Key Type LV Size
------- ---- -- ----------
103 Full 3.27M
List of Datafiles in backup set 103
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
4 Full 1062253 2017-08-19:20:30:06 +DATA/orcl/datafile/users.259.816169553
Backup Set Copy #1 of backup set 103
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:00 2017-08-19:20:32:59 NO TAG20170819T203006
List of Backup Pieces for backup set 103 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
111 1 AVAILABLE /home/oracle/users2.bkp
Backup Set Copy #2 of backup set 103
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:00 2017-08-19:21:20:35 NO TAG20170819T203006
List of Backup Pieces for backup set 103 Copy #2
BP Key Pc# Status Piece Name
------- --- ----------- ----------
1741 1 AVAILABLE /home/oracle/users3.bkp
RMAN>
RMAN>
|
|