|
上完1Z0-052第16章/1Z0-053第2章
1Z0-052共19章(上完12章),1Z0-053共21章(上完6章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的18章
1a实验,对应图形界面上的DRA:
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 16 15:22:43 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 6664212480 bytes
- Fixed Size 2240944 bytes
- Variable Size 3640659536 bytes
- Database Buffers 3003121664 bytes
- Redo Buffers 18190336 bytes
- Database mounted.
- ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sat Sep 16 15:23:09 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367, not open)
- RMAN> list failure;
- using target database control file instead of recovery catalog
- List of Database Failures
- =========================
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 482 CRITICAL OPEN 16-SEP-17 System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- RMAN> advise failure;
- List of Database Failures
- =========================
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 482 CRITICAL OPEN 16-SEP-17 System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- analyzing automatic repair options; this may take some time
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- analyzing automatic repair options complete
- Mandatory Manual Actions
- ========================
- 1. If file +DATA/orcl/datafile/system.256.816169553 was unintentionally renamed or moved, restore it
- 2. If file +DATA/orcl/datafile/sysaux.257.816169553 was unintentionally renamed or moved, restore it
- 3. If file +DATA/orcl/datafile/undotbs1.258.816169553 was unintentionally renamed or moved, restore it
- 4. If file +DATA/orcl/datafile/users.259.816169553 was unintentionally renamed or moved, restore it
- 5. If file +DATA/orcl/datafile/example.265.816169651 was unintentionally renamed or moved, restore it
- 6. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair
- Optional Manual Actions
- =======================
- no manual actions available
- Automated Repair Options
- ========================
- no automatic repair options available
- RMAN> restore database;
- Starting restore at 16-SEP-17
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: reading from backup piece 1ls4tgjd_1_1
- channel ORA_SBT_TAPE_2: starting datafile backup set restore
- channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_2: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
- channel ORA_SBT_TAPE_2: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
- channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
- channel ORA_SBT_TAPE_2: reading from backup piece 1ks4tgjd_1_1
- channel ORA_SBT_TAPE_1: piece handle=1ls4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
- channel ORA_SBT_TAPE_2: piece handle=1ks4tgjd_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_2: restored backup piece 1
- channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:55
- Finished restore at 16-SEP-17
- RMAN> list failure;
- no failures found that match specification
- RMAN> alter database open ;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of alter db command at 09/16/2017 15:27:36
- ORA-01113: file 1 needs media recovery
- ORA-01110: data file 1: '+DATA/orcl/datafile/system.257.954861995'
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure all;
- no failures found that match specification
- RMAN> list failure ;
- no failures found that match specification
- RMAN> recover database;
- Starting recover at 16-SEP-17
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765
- archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333
- archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887
- archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455
- archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455
- archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467
- archived log for thread 1 with sequence 115 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469
- archived log for thread 1 with sequence 116 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of recover command at 09/16/2017 15:28:19
- RMAN-06053: unable to perform media recovery because of missing log
- RMAN-06025: no backup of archived log for thread 1 with sequence 114 and starting SCN of 2101539 found to restore
- RMAN> list failure ;
- no failures found that match specification
- RMAN> run {
- 2> set until sequence 114 thread 1;
- 3> recover database;
- 4> }
- executing command: SET until clause
- Starting recover at 16-SEP-17
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765
- archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333
- archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887
- archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455
- archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455
- archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467
- channel ORA_SBT_TAPE_1: starting archived log restore to default destination
- channel ORA_SBT_TAPE_1: restoring archived log
- archived log thread=1 sequence=107
- channel ORA_SBT_TAPE_1: reading from backup piece 1ms4tgk7_1_1
- channel ORA_SBT_TAPE_1: piece handle=1ms4tgk7_1_1 tag=0T_INCR0_WHOLE
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:33
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_107.327.954862151 thread=1 sequence=107
- channel default: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_107.327.954862151 RECID=109 STAMP=954862150
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765 thread=1 sequence=108
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333 thread=1 sequence=109
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887 thread=1 sequence=110
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455 thread=1 sequence=111
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455 thread=1 sequence=112
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467 thread=1 sequence=113
- media recovery complete, elapsed time: 00:00:04
- Finished recover at 16-SEP-17
- RMAN> list failure ;
- no failures found that match specification
- RMAN> alter database open ;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of alter db command at 09/16/2017 15:29:37
- ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
- RMAN> alter database open RESETLOGS;
- database opened
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- List of Database Failures
- =========================
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 561 HIGH OPEN 16-SEP-17 Tablespace 4: 'USERS' is offline
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- RMAN> advise failure;
- List of Database Failures
- =========================
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 561 HIGH OPEN 16-SEP-17 Tablespace 4: 'USERS' is offline
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- analyzing automatic repair options; this may take some time
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- analyzing automatic repair options complete
- Not all specified failures can currently be repaired.
- The following failures must be repaired before advise for others can be given.
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- Mandatory Manual Actions
- ========================
- no manual actions available
- Optional Manual Actions
- =======================
- 1. If file +DATA/orcl/datafile/users.256.954861995 was unintentionally renamed or moved, restore it
- Automated Repair Options
- ========================
- Option Repair Description
- ------ ------------------
- 1 Restore and recover datafile 4
- Strategy: The repair includes complete media recovery with no data loss
- Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1239215094.hm
- RMAN> repair failure preview;
- Strategy: The repair includes complete media recovery with no data loss
- Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1239215094.hm
- contents of repair script:
- # restore and recover datafile
- sql 'alter database datafile 4 offline';
- restore datafile 4;
- recover datafile 4;
- sql 'alter database datafile 4 online';
- RMAN> list failure;
- no failures found that match specification
- RMAN> list failure;
- List of Database Failures
- =========================
- Failure ID Priority Status Time Detected Summary
- ---------- -------- --------- ------------- -------
- 561 HIGH OPEN 16-SEP-17 Tablespace 4: 'USERS' is offline
- 485 HIGH OPEN 16-SEP-17 One or more non-system datafiles are missing
- RMAN> show all;
- RMAN configuration parameters for database with db_unique_name ORCL are:
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
- CONFIGURE BACKUP OPTIMIZATION ON;
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
- CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE MAXSETSIZE TO UNLIMITED; # default
- CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
- CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
- CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
- CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
- RMAN> delete noprompt backup;
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- List of Backup Pieces
- BP Key BS Key Pc# Cp# Status Device Type Piece Name
- ------- ------- --- --- ----------- ----------- ----------
- 51 51 1 1 AVAILABLE SBT_TAPE 1js4tgij_1_1
- 52 52 1 1 AVAILABLE SBT_TAPE 1ls4tgjd_1_1
- 53 53 1 1 AVAILABLE SBT_TAPE 1ks4tgjd_1_1
- 54 54 1 1 AVAILABLE SBT_TAPE 1ms4tgk7_1_1
- 55 55 1 1 AVAILABLE SBT_TAPE c-1343950367-20170522-00
- 56 56 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2017_09_16/s_954862192.324.954862193
- 57 57 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2017_09_16/s_954862677.317.954862679
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_09_16/s_954862192.324.954862193 RECID=56 STAMP=954862193
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_09_16/s_954862677.317.954862679 RECID=57 STAMP=954862677
- Deleted 2 objects
- deleted backup piece
- backup piece handle=1js4tgij_1_1 RECID=51 STAMP=944685651
- deleted backup piece
- backup piece handle=1ls4tgjd_1_1 RECID=52 STAMP=944685678
- deleted backup piece
- backup piece handle=1ks4tgjd_1_1 RECID=53 STAMP=944685677
- deleted backup piece
- backup piece handle=1ms4tgk7_1_1 RECID=54 STAMP=944685703
- deleted backup piece
- backup piece handle=c-1343950367-20170522-00 RECID=55 STAMP=944685728
- Deleted 5 objects
- RMAN> list backup;
- specification does not match any backup in the repository
- RMAN> delete noprompt copy;
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- released channel: ORA_SBT_TAPE_1
- released channel: ORA_SBT_TAPE_2
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 100 1 108 A 22-MAY-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765
- 101 1 109 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333
- 102 1 110 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887
- 103 1 111 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455
- 104 1 112 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455
- 105 1 113 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467
- 106 1 114 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- 107 1 115 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469
- 108 1 116 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473
- 110 1 117 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_117.327.954862185
- 111 1 1 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_1.323.954862277
- 112 1 2 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_2.322.954862277
- 113 1 3 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_3.321.954862279
- 114 1 4 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_4.320.954862279
- 115 1 5 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_5.319.954862283
- 116 1 6 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_6.318.954862285
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765 RECID=100 STAMP=954849764
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333 RECID=101 STAMP=954850333
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887 RECID=102 STAMP=954850886
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455 RECID=103 STAMP=954861454
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455 RECID=104 STAMP=954861454
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467 RECID=105 STAMP=954861466
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469 RECID=107 STAMP=954861469
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473 RECID=108 STAMP=954861472
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_117.327.954862185 RECID=110 STAMP=954862185
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_1.323.954862277 RECID=111 STAMP=954862277
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_2.322.954862277 RECID=112 STAMP=954862277
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_3.321.954862279 RECID=113 STAMP=954862279
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_4.320.954862279 RECID=114 STAMP=954862279
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_5.319.954862283 RECID=115 STAMP=954862283
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_6.318.954862285 RECID=116 STAMP=954862285
- Deleted 15 objects
- RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
- RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
- RMAN-06210: List of Mismatched objects
- RMAN-06211: ==========================
- RMAN-06212: Object Type Filename/Handle
- RMAN-06213: --------------- ---------------------------------------------------
- RMAN-06214: Archivelog +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN> list copy;
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 106 1 114 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN> delete noprompt copy;
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 106 1 114 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
- RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
- RMAN-06210: List of Mismatched objects
- RMAN-06211: ==========================
- RMAN-06212: Object Type Filename/Handle
- RMAN-06213: --------------- ---------------------------------------------------
- RMAN-06214: Archivelog +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN> list backup;
- specification does not match any backup in the repository
- RMAN> list copy;
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 106 1 114 A 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN> crosscheck copy;
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- validation failed for archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469 RECID=106 STAMP=954861468
- Crosschecked 1 objects
- RMAN> list copy;
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 106 1 114 X 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- RMAN> delete expired copy;
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=131 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=192 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=8 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=69 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=132 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=193 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=9 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=70 device type=DISK
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 106 1 114 X 16-SEP-17
- Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469
- Do you really want to delete the above objects (enter YES or NO)? YES
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469 RECID=106 STAMP=954861468
- Deleted 1 EXPIRED objects
- RMAN> list copy;
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- specification does not match any archived log in the repository
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ echo $NLS_DATE_FORMAT
- [oracle@station90 ~]$ vim .bash_profile
- [oracle@station90 ~]$ . .bash_profile
- [oracle@station90 ~]$ echo $NLS_DATE_FORMAT
- YYYY-MM-DD:HH24:MI:SS
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sat Sep 16 15:54:31 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> show all;
- using target database control file instead of recovery catalog
- RMAN configuration parameters for database with db_unique_name ORCL are:
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
- CONFIGURE BACKUP OPTIMIZATION ON;
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
- CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE MAXSETSIZE TO UNLIMITED; # default
- CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
- CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
- CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
- CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
- RMAN> backup tag '1T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-09-16:15:57:01
- current log archived
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=71 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=147 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=7 RECID=118 STAMP=954863821
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:57:13
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:57:38
- piece handle=1rsek46p_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_7.319.954863821 RECID=118 STAMP=954863821
- Finished backup at 2017-09-16:15:57:38
- Starting backup at 2017-09-16:15:57:38
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
- input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:57:38
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-16:15:57:39
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:58:14
- piece handle=1ssek47i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-16:15:58:14
- piece handle=1tsek47i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
- Finished backup at 2017-09-16:15:58:14
- Starting backup at 2017-09-16:15:58:14
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=8 RECID=119 STAMP=954863894
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:58:14
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:58:33
- piece handle=1usek48m_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:19
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_8.319.954863895 RECID=119 STAMP=954863894
- Finished backup at 2017-09-16:15:58:33
- Starting Control File and SPFILE Autobackup at 2017-09-16:15:58:34
- piece handle=c-1343950367-20170916-03 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-09-16:15:58:59
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Sep 17 16:00:50 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '2T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-09-17:16:01:14
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=14 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=16 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=9 RECID=120 STAMP=954950475
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:01:27
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:01:52
- piece handle=20semoqn_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_17/thread_1_seq_9.319.954950475 RECID=120 STAMP=954950475
- Finished backup at 2017-09-17:16:01:52
- Starting backup at 2017-09-17:16:01:52
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
- input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:01:52
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-17:16:01:52
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:02:27
- piece handle=21semorg_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-17:16:02:27
- piece handle=22semorg_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
- Finished backup at 2017-09-17:16:02:27
- Starting backup at 2017-09-17:16:02:27
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=10 RECID=121 STAMP=954950548
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:02:28
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:02:53
- piece handle=23semosk_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_17/thread_1_seq_10.319.954950547 RECID=121 STAMP=954950548
- Finished backup at 2017-09-17:16:02:53
- Starting Control File and SPFILE Autobackup at 2017-09-17:16:02:53
- piece handle=c-1343950367-20170917-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-09-17:16:03:18
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Sun Sep 17 23:59:02 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:50:13 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:54:04 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:58:02 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> list backup;
- using target database control file instead of recovery catalog
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 16:01:03 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- RMAN> list backup ;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- RMAN> list backup with tag '2T_INCR0_WHOLE';
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-00558: error encountered while parsing input commands
- RMAN-01009: syntax error: found "with": expecting one of: "backed, by, completed, controlfile, device, for, like, of, recoverable, summary, tag, ;"
- RMAN-01007: at line 1 column 14 file: standard input
- RMAN> list backup ;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- Backup Set 61 2017-09-16:15:58:09
- Backup Piece 61 2017-09-16:15:58:09 1ssek47i_1_1
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- Backup Set 61 2017-09-16:15:58:09
- Backup Piece 61 2017-09-16:15:58:09 1ssek47i_1_1
- Backup Set 60 2017-09-16:15:58:06
- Backup Piece 60 2017-09-16:15:58:06 1tsek47i_1_1
- Backup Set 62 2017-09-16:15:58:30
- Backup Piece 62 2017-09-16:15:58:30 1usek48m_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 23:59:03 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 58 2017-09-16:15:53:00
- Backup Piece 58 2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- Backup Set 59 2017-09-16:15:57:29
- Backup Piece 59 2017-09-16:15:57:29 1rsek46p_1_1
- Backup Set 61 2017-09-16:15:58:09
- Backup Piece 61 2017-09-16:15:58:09 1ssek47i_1_1
- Backup Set 60 2017-09-16:15:58:06
- Backup Piece 60 2017-09-16:15:58:06 1tsek47i_1_1
- Backup Set 62 2017-09-16:15:58:30
- Backup Piece 62 2017-09-16:15:58:30 1usek48m_1_1
- Backup Set 63 2017-09-16:15:58:50
- Backup Piece 63 2017-09-16:15:58:50 c-1343950367-20170916-03
- Backup Set 64 2017-09-17:16:01:42
- Backup Piece 64 2017-09-17:16:01:42 20semoqn_1_1
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- 1 2 +DATA/orcl/datafile/system.257.954861995
- 2 2 +DATA/orcl/datafile/sysaux.258.954861995
- 3 2 +DATA/orcl/datafile/undotbs1.259.954861991
- 4 2 +DATA/orcl/datafile/users.256.954863059
- 5 2 +DATA/orcl/datafile/example.265.954861991
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 19 08:00:17 2017
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> alter tablespace users read only;
- Tablespace altered.
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Data Mining
- and Real Application Testing options
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Tue Sep 19 08:00:33 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '4T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-09-19:08:01:08
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=210 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=11 RECID=122 STAMP=954979207
- input archived log thread=1 sequence=12 RECID=123 STAMP=954979211
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:01:21
- channel ORA_SBT_TAPE_2: starting archived log backup set
- channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=13 RECID=124 STAMP=955065571
- input archived log thread=1 sequence=14 RECID=125 STAMP=955094469
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:08:01:21
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:01:46
- piece handle=25ser5eh_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_11.319.954979207 RECID=122 STAMP=954979207
- archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_12.320.954979211 RECID=123 STAMP=954979211
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:08:01:56
- piece handle=26ser5eh_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_13.321.955065571 RECID=124 STAMP=955065571
- archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_14.322.955094469 RECID=125 STAMP=955094469
- Finished backup at 2017-09-19:08:01:56
- Starting backup at 2017-09-19:08:01:56
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
- input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:01:57
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:08:01:57
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:02:22
- piece handle=27ser5fk_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:08:02:22
- piece handle=28ser5fl_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-09-19:08:02:22
- Starting backup at 2017-09-19:08:02:22
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=15 RECID=126 STAMP=955094542
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:02:22
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:02:47
- piece handle=29ser5ge_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_15.322.955094543 RECID=126 STAMP=955094542
- Finished backup at 2017-09-19:08:02:48
- Starting Control File and SPFILE Autobackup at 2017-09-19:08:02:48
- piece handle=c-1343950367-20170919-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-09-19:08:03:13
- RMAN> show all;
- RMAN configuration parameters for database with db_unique_name ORCL are:
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
- CONFIGURE BACKUP OPTIMIZATION ON;
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
- CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE MAXSETSIZE TO UNLIMITED; # default
- CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
- CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
- CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
- CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
- CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
- RMAN> list backup ;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 82.25M SBT_TAPE 00:00:15 2017-09-19:08:01:36
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 25ser5eh_1_1 Media: station90-000003
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 11 2116162 2017-09-17:16:02:27 2128971 2017-09-18:00:00:07
- 1 12 2128971 2017-09-18:00:00:07 2149527 2017-09-18:00:00:10
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 57.00M SBT_TAPE 00:00:30 2017-09-19:08:01:51
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 26ser5eh_1_1 Media: station90-000004
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 13 2149527 2017-09-18:00:00:10 2158292 2017-09-18:23:59:30
- 1 14 2158292 2017-09-18:23:59:30 2164478 2017-09-19:08:01:08
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 71 Incr 0 87.25M SBT_TAPE 00:00:21 2017-09-19:08:02:18
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 28ser5fl_1_1 Media: station90-000004
- List of Datafiles in backup set 71
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2164600 2017-09-19:08:02:00 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2164600 2017-09-19:08:02:00 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 72 Incr 0 1.08G SBT_TAPE 00:00:25 2017-09-19:08:02:21
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 27ser5fk_1_1 Media: station90-000003
- List of Datafiles in backup set 72
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2164596 2017-09-19:08:01:57 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2164596 2017-09-19:08:01:57 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2164140 2017-09-19:08:00:27 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 73 512.00K SBT_TAPE 00:00:16 2017-09-19:08:02:38
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 29ser5ge_1_1 Media: station90-000003
- List of Archived Logs in backup set 73
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 15 2164478 2017-09-19:08:01:08 2164666 2017-09-19:08:02:22
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 74 Full 9.75M SBT_TAPE 00:00:24 2017-09-19:08:03:12
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170919T080248
- Handle: c-1343950367-20170919-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2164686 Ckp time: 2017-09-19:08:02:48
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Tue Sep 19 23:50:09 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '4T2_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-09-19:23:50:25
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=20 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=147 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=16 RECID=127 STAMP=955151425
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:50:36
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:01
- piece handle=2bsest2c_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_16.322.955151425 RECID=127 STAMP=955151425
- Finished backup at 2017-09-19:23:51:01
- Starting backup at 2017-09-19:23:51:01
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping datafile 4; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:51:02
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:23:51:02
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:27
- piece handle=2csest35_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:23:51:27
- piece handle=2dsest36_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-09-19:23:51:27
- Starting backup at 2017-09-19:23:51:27
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=17 RECID=128 STAMP=955151487
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:51:27
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:42
- piece handle=2esest3v_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_17.322.955151487 RECID=128 STAMP=955151487
- Finished backup at 2017-09-19:23:51:43
- Starting Control File and SPFILE Autobackup at 2017-09-19:23:51:43
- piece handle=c-1343950367-20170919-01 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-09-19:23:52:08
- RMAN> list backup ;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Full 9.45M DISK 00:00:00 2017-09-16:15:53:00
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155300
- Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2105817 Ckp time: 2017-09-16:15:53:00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 59 6.00M SBT_TAPE 00:00:16 2017-09-16:15:57:29
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1rsek46p_1_1 Media: station90-000003
- List of Archived Logs in backup set 59
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 7 2102389 2017-09-16:15:31:25 2106112 2017-09-16:15:57:01
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 60 Incr 0 227.50M SBT_TAPE 00:00:28 2017-09-16:15:58:06
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1tsek47i_1_1 Media: station90-000004
- List of Datafiles in backup set 60
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2106146 2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Incr 0 1.06G SBT_TAPE 00:00:31 2017-09-16:15:58:09
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1ssek47i_1_1 Media: station90-000003
- List of Datafiles in backup set 61
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2106143 2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 256.00K SBT_TAPE 00:00:16 2017-09-16:15:58:30
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1T_INCR0_WHOLE
- Handle: 1usek48m_1_1 Media: station90-000003
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 8 2106112 2017-09-16:15:57:01 2106178 2017-09-16:15:58:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 9.50M SBT_TAPE 00:00:16 2017-09-16:15:58:50
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: TAG20170916T155834
- Handle: c-1343950367-20170916-03 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2106194 Ckp time: 2017-09-16:15:58:34
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 64 27.00M SBT_TAPE 00:00:15 2017-09-17:16:01:42
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 20semoqn_1_1 Media: station90-000003
- List of Archived Logs in backup set 64
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 9 2106178 2017-09-16:15:58:14 2114767 2017-09-17:16:01:14
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 100.75M SBT_TAPE 00:00:25 2017-09-17:16:02:17
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 22semorg_1_1 Media: station90-000004
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2116132 2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 66 Incr 0 1.07G SBT_TAPE 00:00:27 2017-09-17:16:02:19
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 21semorg_1_1 Media: station90-000003
- List of Datafiles in backup set 66
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2116128 2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 67 13.25M SBT_TAPE 00:00:15 2017-09-17:16:02:43
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2T_INCR0_WHOLE
- Handle: 23semosk_1_1 Media: station90-000003
- List of Archived Logs in backup set 67
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 10 2114767 2017-09-17:16:01:14 2116162 2017-09-17:16:02:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.50M SBT_TAPE 00:00:16 2017-09-17:16:03:09
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20170917T160253
- Handle: c-1343950367-20170917-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2116250 Ckp time: 2017-09-17:16:02:53
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 82.25M SBT_TAPE 00:00:15 2017-09-19:08:01:36
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 25ser5eh_1_1 Media: station90-000003
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 11 2116162 2017-09-17:16:02:27 2128971 2017-09-18:00:00:07
- 1 12 2128971 2017-09-18:00:00:07 2149527 2017-09-18:00:00:10
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 57.00M SBT_TAPE 00:00:30 2017-09-19:08:01:51
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 26ser5eh_1_1 Media: station90-000004
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 13 2149527 2017-09-18:00:00:10 2158292 2017-09-18:23:59:30
- 1 14 2158292 2017-09-18:23:59:30 2164478 2017-09-19:08:01:08
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 71 Incr 0 87.25M SBT_TAPE 00:00:21 2017-09-19:08:02:18
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 28ser5fl_1_1 Media: station90-000004
- List of Datafiles in backup set 71
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2164600 2017-09-19:08:02:00 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2164600 2017-09-19:08:02:00 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 72 Incr 0 1.08G SBT_TAPE 00:00:25 2017-09-19:08:02:21
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 27ser5fk_1_1 Media: station90-000003
- List of Datafiles in backup set 72
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2164596 2017-09-19:08:01:57 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2164596 2017-09-19:08:01:57 +DATA/orcl/datafile/sysaux.258.954861995
- 4 0 Incr 2164140 2017-09-19:08:00:27 +DATA/orcl/datafile/users.256.954863059
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 73 512.00K SBT_TAPE 00:00:16 2017-09-19:08:02:38
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: 4T_INCR0_WHOLE
- Handle: 29ser5ge_1_1 Media: station90-000003
- List of Archived Logs in backup set 73
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 15 2164478 2017-09-19:08:01:08 2164666 2017-09-19:08:02:22
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 74 Full 9.75M SBT_TAPE 00:00:24 2017-09-19:08:03:12
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170919T080248
- Handle: c-1343950367-20170919-00 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2164686 Ckp time: 2017-09-19:08:02:48
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 75 21.50M SBT_TAPE 00:00:15 2017-09-19:23:50:51
- BP Key: 75 Status: AVAILABLE Compressed: NO Tag: 4T2_INCR0_WHOLE
- Handle: 2bsest2c_1_1 Media: station90-000003
- List of Archived Logs in backup set 75
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 16 2164666 2017-09-19:08:02:22 2170841 2017-09-19:23:50:25
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 76 Incr 0 86.25M SBT_TAPE 00:00:19 2017-09-19:23:51:21
- BP Key: 76 Status: AVAILABLE Compressed: NO Tag: 4T2_INCR0_WHOLE
- Handle: 2dsest36_1_1 Media: station90-000004
- List of Datafiles in backup set 76
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 3 0 Incr 2171173 2017-09-19:23:51:04 +DATA/orcl/datafile/undotbs1.259.954861991
- 5 0 Incr 2171173 2017-09-19:23:51:04 +DATA/orcl/datafile/example.265.954861991
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 77 Incr 0 1.08G SBT_TAPE 00:00:23 2017-09-19:23:51:24
- BP Key: 77 Status: AVAILABLE Compressed: NO Tag: 4T2_INCR0_WHOLE
- Handle: 2csest35_1_1 Media: station90-000003
- List of Datafiles in backup set 77
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 2171159 2017-09-19:23:51:02 +DATA/orcl/datafile/system.257.954861995
- 2 0 Incr 2171159 2017-09-19:23:51:02 +DATA/orcl/datafile/sysaux.258.954861995
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 78 2.25M SBT_TAPE 00:00:15 2017-09-19:23:51:42
- BP Key: 78 Status: AVAILABLE Compressed: NO Tag: 4T2_INCR0_WHOLE
- Handle: 2esest3v_1_1 Media: station90-000003
- List of Archived Logs in backup set 78
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 17 2170841 2017-09-19:23:50:25 2171222 2017-09-19:23:51:27
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 79 Full 9.75M SBT_TAPE 00:00:15 2017-09-19:23:51:58
- BP Key: 79 Status: AVAILABLE Compressed: NO Tag: TAG20170919T235143
- Handle: c-1343950367-20170919-01 Media: station90-000003
- SPFILE Included: Modification time: 2017-09-16:15:45:57
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 2171262 Ckp time: 2017-09-19:23:51:43
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 20 00:00:05 2017
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '5T_INCR0_WHOLE' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-09-20:00:00:14
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=16 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=69 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=18 RECID=129 STAMP=955152015
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:00:26
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:00:51
- piece handle=2gsestkq_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_20/thread_1_seq_18.322.955152015 RECID=129 STAMP=955152015
- Finished backup at 2017-09-20:00:00:51
- Starting backup at 2017-09-20:00:00:51
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
- input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:00:52
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-20:00:00:52
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:01:17
- piece handle=2hsestlk_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-20:00:01:17
- piece handle=2isestlk_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-09-20:00:01:17
- Starting backup at 2017-09-20:00:01:17
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=19 RECID=130 STAMP=955152078
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:01:18
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:01:43
- piece handle=2jsestme_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_09_20/thread_1_seq_19.322.955152077 RECID=130 STAMP=955152078
- Finished backup at 2017-09-20:00:01:43
- Starting Control File and SPFILE Autobackup at 2017-09-20:00:01:43
- piece handle=c-1343950367-20170920-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-09-20:00:02:07
- RMAN>
复制代码- ORACLE_HOME=...
- ORACLE_BASE=...
- ORACLE_SID=...
- 0,5,10,15,20,25 1 * * 1-5 /u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / cmdfile=/home/oracle/ttio.rcv
复制代码- SQL> conn / as sysdba
- Connected.
- SQL> create directory dir1 as '/home/oracle';
- Directory created.
- 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 ~]$ expdp system/oracle_4U directory=dir1 dumpfile=u90.dmp schemas='U90'
- Export: Release 11.2.0.1.0 - Production on Wed Sep 20 01:27:36 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- UDE-28002: operation generated ORACLE error 28002
- ORA-28002: the password will expire within 7 days
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dir1 dumpfile=u90.dmp schemas=U90
- Estimate in progress using BLOCKS method...
- Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
- Total estimation using BLOCKS method: 1.75 MB
- Processing object type SCHEMA_EXPORT/USER
- Processing object type SCHEMA_EXPORT/ROLE_GRANT
- Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
- Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
- Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
- Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
- Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/TABLE/TABLE
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
- Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
- Processing object type SCHEMA_EXPORT/VIEW/VIEW
- Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
- . . exported "U90"."CFS" 89.83 KB 157 rows
- . . exported "U90"."BCF" 10.29 KB 1 rows
- . . exported "U90"."BDF" 16.85 KB 5 rows
- . . exported "U90"."BP" 15.61 KB 5 rows
- . . exported "U90"."BRL" 10.33 KB 2 rows
- . . exported "U90"."BS" 12.60 KB 5 rows
- . . exported "U90"."BSF" 7.835 KB 1 rows
- . . exported "U90"."CKP" 8.664 KB 1 rows
- . . exported "U90"."CONF" 7.945 KB 8 rows
- . . exported "U90"."CONFIG" 5.421 KB 1 rows
- . . exported "U90"."DB" 5.820 KB 1 rows
- . . exported "U90"."DBINC" 7.476 KB 2 rows
- . . exported "U90"."DF" 15.05 KB 5 rows
- . . exported "U90"."NODE" 20.59 KB 1 rows
- . . exported "U90"."OFFR" 8.828 KB 5 rows
- . . exported "U90"."ORL" 7.796 KB 6 rows
- . . exported "U90"."RCVER" 5.023 KB 1 rows
- . . exported "U90"."RLH" 8.726 KB 3 rows
- . . exported "U90"."ROUT" 7.554 KB 11 rows
- . . exported "U90"."RSR" 14.08 KB 2 rows
- . . exported "U90"."RT" 7.828 KB 1 rows
- . . exported "U90"."SITE_DFATT" 6.062 KB 5 rows
- . . exported "U90"."SITE_TFATT" 8.265 KB 1 rows
- . . exported "U90"."TF" 8.226 KB 1 rows
- . . exported "U90"."TS" 9.257 KB 6 rows
- . . exported "U90"."TSATT" 7.125 KB 6 rows
- . . exported "U90"."AL" 0 KB 0 rows
- . . exported "U90"."BCB" 0 KB 0 rows
- . . exported "U90"."BCR" 0 KB 0 rows
- . . exported "U90"."CCB" 0 KB 0 rows
- . . exported "U90"."CCF" 0 KB 0 rows
- . . exported "U90"."CDF" 0 KB 0 rows
- . . exported "U90"."FB" 0 KB 0 rows
- . . exported "U90"."GRSP" 0 KB 0 rows
- . . exported "U90"."NRSP" 0 KB 0 rows
- . . exported "U90"."RR" 0 KB 0 rows
- . . exported "U90"."SCR" 0 KB 0 rows
- . . exported "U90"."SCRL" 0 KB 0 rows
- . . exported "U90"."TEMPRES" 0 KB 0 rows
- . . exported "U90"."VPC_DATABASES" 0 KB 0 rows
- . . exported "U90"."VPC_USERS" 0 KB 0 rows
- . . exported "U90"."XAL" 0 KB 0 rows
- . . exported "U90"."XCF" 0 KB 0 rows
- . . exported "U90"."XDF" 0 KB 0 rows
- Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
- ******************************************************************************
- Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
- /home/oracle/u90.dmp
- Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 01:28:20
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 20 01:28:47 2017
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> drop user u90 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 ~]$ impdp system/oracle_4U directory=dir1 dumpfile=u90.dmp schemas='U90'
- Import: Release 11.2.0.1.0 - Production on Wed Sep 20 01:29:38 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- UDI-28002: operation generated ORACLE error 28002
- ORA-28002: the password will expire within 7 days
- Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
- Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=dir1 dumpfile=u90.dmp schemas=U90
- Processing object type SCHEMA_EXPORT/USER
- Processing object type SCHEMA_EXPORT/ROLE_GRANT
- Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
- Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
- Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
- Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
- Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/TABLE/TABLE
- Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
- . . imported "U90"."CFS" 89.83 KB 157 rows
- . . imported "U90"."BCF" 10.29 KB 1 rows
- . . imported "U90"."BDF" 16.85 KB 5 rows
- . . imported "U90"."BP" 15.61 KB 5 rows
- . . imported "U90"."BRL" 10.33 KB 2 rows
- . . imported "U90"."BS" 12.60 KB 5 rows
- . . imported "U90"."BSF" 7.835 KB 1 rows
- . . imported "U90"."CKP" 8.664 KB 1 rows
- . . imported "U90"."CONF" 7.945 KB 8 rows
- . . imported "U90"."CONFIG" 5.421 KB 1 rows
- . . imported "U90"."DB" 5.820 KB 1 rows
- . . imported "U90"."DBINC" 7.476 KB 2 rows
- . . imported "U90"."DF" 15.05 KB 5 rows
- . . imported "U90"."NODE" 20.59 KB 1 rows
- . . imported "U90"."OFFR" 8.828 KB 5 rows
- . . imported "U90"."ORL" 7.796 KB 6 rows
- . . imported "U90"."RCVER" 5.023 KB 1 rows
- . . imported "U90"."RLH" 8.726 KB 3 rows
- . . imported "U90"."ROUT" 7.554 KB 11 rows
- . . imported "U90"."RSR" 14.08 KB 2 rows
- . . imported "U90"."RT" 7.828 KB 1 rows
- . . imported "U90"."SITE_DFATT" 6.062 KB 5 rows
- . . imported "U90"."SITE_TFATT" 8.265 KB 1 rows
- . . imported "U90"."TF" 8.226 KB 1 rows
- . . imported "U90"."TS" 9.257 KB 6 rows
- . . imported "U90"."TSATT" 7.125 KB 6 rows
- . . imported "U90"."AL" 0 KB 0 rows
- . . imported "U90"."BCB" 0 KB 0 rows
- . . imported "U90"."BCR" 0 KB 0 rows
- . . imported "U90"."CCB" 0 KB 0 rows
- . . imported "U90"."CCF" 0 KB 0 rows
- . . imported "U90"."CDF" 0 KB 0 rows
- . . imported "U90"."FB" 0 KB 0 rows
- . . imported "U90"."GRSP" 0 KB 0 rows
- . . imported "U90"."NRSP" 0 KB 0 rows
- . . imported "U90"."RR" 0 KB 0 rows
- . . imported "U90"."SCR" 0 KB 0 rows
- . . imported "U90"."SCRL" 0 KB 0 rows
- . . imported "U90"."TEMPRES" 0 KB 0 rows
- . . imported "U90"."VPC_DATABASES" 0 KB 0 rows
- . . imported "U90"."VPC_USERS" 0 KB 0 rows
- . . imported "U90"."XAL" 0 KB 0 rows
- . . imported "U90"."XCF" 0 KB 0 rows
- . . imported "U90"."XDF" 0 KB 0 rows
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
- Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
- Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
- Processing object type SCHEMA_EXPORT/VIEW/VIEW
- Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
- Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
- Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
- Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
- Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
- Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 01:30:36
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 20 01:30:48 2017
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> coonn / as sysdba
- SP2-0734: unknown command beginning "coonn / as..." - rest of line ignored.
- SQL> conn / as sysdba
- Connected.
- SQL> alter user u90 identified by oracle_4U account unlock;
- User altered.
- SQL>
复制代码
|
|