Labels

Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts

Thursday, March 6, 2014

Oracle 12c Multisection Incremental backup

Starting with Oracle Database 12c Release 1 (12.1), RMAN supports multisection incremental backups. Wherever applicable, RMAN also uses unused block compression and block change tracking while creating multisection incremental backups. When backup sets are used, you can create multisection full or incremental backups.

To create level 0 multisection incremental backups, the COMPATIBLE parameter must be set to 11.0 or higher. However, to create multisection incremental backups of level 1 or higher, you must set the COMPATIBLE parameter to 12.0.0 or higher. RMAN always creates multisection incremental backups withFILESPERSET set to 1.

The SECTION SIZE clause specifies the size of each backup section. If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backups for that file.

Multisection Incremental Backup of Database as Backup Sets
SQL> select name from v$database;

NAME
---------
ORA12C
SQL> show user
USER is "SYS"
SQL> create user c##x identified by c##x;

User created.
SQL> grant sysbackup to c##x;

Grant succeeded.

SQL> grant connect,resource to c##x;

Grant succeeded.
C:\Users\xxxxxx>rman target 'c##x@ORA12C as sysbackup'

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Mar 6 16:47:51 2014

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

target database Password:
connected to target database: ORA12C (DBID=218350063)
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

RMAN> backup incremental level 1 section size 300m datafile 'C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF';

Starting backup at 06-MAR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=34 device type=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 38400
channel ORA_DISK_1: starting piece 1 at 06-MAR-14
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 38401 through 76800
channel ORA_DISK_2: starting piece 2 at 06-MAR-14
channel ORA_DISK_1: finished piece 1 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPL2B2_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:05:31
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 76801 through 98560
channel ORA_DISK_1: starting piece 3 at 06-MAR-14
channel ORA_DISK_2: finished piece 2 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPWFGG_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: finished piece 3 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_TAG20140306T165137_9KJPWKS0_.BKP tag=TAG20140306T165137 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-MAR-14

Starting Control File and SPFILE Autobackup at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\AUTOBACKUP\2014_03_06\O1_MF_S_841510637_9KJPWP6R_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 06-MAR-14



Making Multisection Backups Using Image Copies
While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file. If the section size that you specify is larger than the size of the file, then RMAN does not use multisection backups for that file.

Ensure that the COMPATIBLE parameter for the target database is set to 12.0.0 or higher.
RMAN> BACKUP AS COPY SECTION SIZE 500M DATABASE;

Starting backup at 06-MAR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=32 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_2: starting datafile copy
input datafile file number=00003 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSAUX01.DBF
backing up blocks 1 through 64000
level 1 incremental backup of image copy.

RMAN> RUN {
   RECOVER COPY OF DATABASE WITH TAG 'incr_update';
   BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' section size 500m
       DATABASE;
   }
Starting backup at 06-MAR-14
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSTEM01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_1: starting piece 1 at 06-MAR-14
channel ORA_DISK_2: starting incremental level 1 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\APP\XXXXXX\ORADATA\ORA12C\SYSAUX01.DBF
backing up blocks 1 through 64000
channel ORA_DISK_2: starting piece 1 at 06-MAR-14
channel ORA_DISK_1: finished piece 1 at 06-MAR-14
piece handle=C:\APP\XXXXXX\RECOVERY_AREA\ORA12C\BACKUPSET\2014_03_06\O1_MF_NNND1_INCR_UPDATE_9KJSKMP
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set


at No comments:
Labels:

Monday, February 24, 2014

Patch set reference

Database Patch Number Description
11.2.0.3.2 13696216 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)
11.2.0.3.1 13343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
11.2.0.3 10404530 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
11.2.0.2.6 13696224 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)
11.2.0.2.5 13343424 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)
11.2.0.2.4 12827726 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
11.2.0.2.3 12419331 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
11.2.0.2.2 11724916 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
11.2.0.2.1 10248523 DATABASE PSU 11.2.0.2.1
11.2.0.2 10098816 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER
        
11.2.0.1.6 12419378  DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
11.2.0.1.5 11724930 DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)
11.2.0.1.4 10248516 DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)
11.2.0.1.3 9952216 DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)
11.2.0.1.2 9654983 DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
11.2.0.1.1 9352237 DATABASE PSU 11.2.0.1.1
        
11.1.0.7.11 13621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
11.1.0.7.10 13343461 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)
11.1.0.7.9 12827740 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
11.1.0.7.8 12419384 DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
11.1.0.7.7 11724936 DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
11.1.0.7.6 10248531 DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11.1.0.7.5 9952228 DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
11.1.0.7.4 9654987 DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
11.1.0.7.3 9352179 DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
11.1.0.7.2 9209238 DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
11.1.0.7.1 8833297 DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
11.1.0.7 6890831 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER
        
10.2.0.5.7 13632743 [*] DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)
10.2.0.5.6 13343471 [*] DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)
10.2.0.5.5 12827745 DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
10.2.0.5.4 12419392 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
10.2.0.5.3 11724962 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
10.2.0.5.2 10248542 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10.2.0.5.1 9952230 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10.2.0.5 8202632 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER
        
10.2.0.4.11 12879929 [*] DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
10.2.0.4.10 12827778 DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2011)
10.2.0.4.9 12419397 DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2011)
10.2.0.4.8 11724977 DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUAPR2011)
10.2.0.4.7 10248636 DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJAN2011)
10.2.0.4.6 9952234 DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUOCT2010) 
10.2.0.4.5 9654991 DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE 10.2.0.4.4|INCLUDES CPUJUL2010)    [overlay PSU]
10.2.0.4.4 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
10.2.0.4.3 9119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
10.2.0.4.2 8833280 DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
10.2.0.4.1 8576156 DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
10.2.0.4 6810189 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.3 5337014 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.2 4547817 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
at No comments:
Labels: , ,

Wednesday, February 19, 2014

Oracle RMAN backup Example

Oracle RMAN backup Example
************Converting No archive log mode to Archive mode database***************
C:\Users\smohanty46>set ORACLE_SID=xe

C:\Users\smohanty46>sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Mon Feb 17 16:08:52 2014

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


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> select name from v$database;

NAME
---------
XE
SQL> show user
USER is "SYS"

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     13
Current log sequence           14
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1388352 bytes
Variable Size             813695168 bytes
Database Buffers          251658240 bytes
Redo Buffers                4591616 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.

SQL> alter database open;

Database altered.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     13
Next log sequence to archive   14
Current log sequence           14
*********************Recovery Catalog configuration****************************
SQL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                                        TABLESPACE_NAME
-------------------------------------------------------------------------------- --------------------
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF                                      USERS
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF                                     UNDOTBS1
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF                                   SYSAUX
C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF                                     SYSTEM

SQL> create tablespace rman datafile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\rman.dbf' size 10m;

Tablespace created.
SQL> create user rman identified by rman default tablespace rman quota unlimited on rman;

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.
SQL> show parameter control_file_record_keep_time

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
SQL> alter system set control_file_record_keep_time=10 scope=both;

System altered.

SQL> show parameter control_file_record_keep_time

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     10
SQL>
SQL> show parameter db_recovery

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\oraclexe\app\oracle\fast_re
                                                 covery_area
db_recovery_file_dest_size           big integer 10G
SQL> alter system set db_recovery_file_dest_size=12G scope=both;

System altered.

SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\oraclexe\app\oracle\fast_re
                                                 covery_area
db_recovery_file_dest_size           big integer 12G
********************* Different Way to connect RMAN and creating recovery catalog
C:\Users\smohanty46>set ORACLE_SID=XE

C:\Users\smohanty46>rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Feb 17 16:19:45 2014

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

connected to target database: XE (DBID=2719768093)

RMAN> exit


Recovery Manager complete.

C:\Users\smohanty46>rman target sys/oracle nocatalog

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Feb 17 16:20:19 2014

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

connected to target database: XE (DBID=2719768093)
using target database control file instead of recovery catalog

RMAN> exit
C:\Users\smohanty46>rman target sys/oracle catalog rman/rman

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Feb 17 16:21:02 2014

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

connected to target database: XE (DBID=2719768093)
connected to recovery catalog database
***********************LOG File Generation
C:\Users\smohanty46>rman log c:\users\smohanty46\rman.log target /
RMAN> show all;

************************CHECKSYNTAX COMMAND
C:\Users\smohanty46>rman CHECKSYNTAX

Recovery Manager: Release 11.2.0.2.0 - Production on Mon Feb 17 16:52:15 2014

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

RMAN> run [ backup database;]

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "["

RMAN> run { backup database; }

The command has no syntax errors
********************************CMD file option
C:\Users\smohanty46>rman target / catalog rman/rman cmdfile="C:\Users\smohanty46\Desktop\rman_run_comm.txt”

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Feb 18 15:33:42 2014

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

connected to target database: XE (DBID=2719768093)
connected to recovery catalog database

RMAN> run {
2> ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;
3> backup tablespace users;
4> backup datafile 2;
5> }
6>
allocated channel: disk1
channel disk1: SID=105 device type=DISK

Starting Control File and SPFILE Autobackup at 18-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\AUTOBACKUP\2014_02_18\O1_MF_S_839864097_9J6D
Finished Control File and SPFILE Autobackup at 18-FEB-14
released channel: disk1

Recovery Manager complete.
********************************Multiple commands in run block
RMAN> run {
 ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;
 backup tablespace users;
backup datafile 2;
 }
6>
allocated channel: disk1
channel disk1: SID=105 device type=DISK

Starting backup at 18-FEB-14
channel disk1: starting full datafile backup set
channel disk1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel disk1: starting piece 1 at 18-FEB-14
channel disk1: finished piece 1 at 18-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_18\O1_MF_NNNDF_TAG20140218T153348_9J6D056H_.BKP tag=TAG20140218T153348
channel disk1: backup set complete, elapsed time: 00:00:03
Finished backup at 18-FEB-14

Starting backup at 18-FEB-14
channel disk1: starting full datafile backup set
channel disk1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
channel disk1: starting piece 1 at 18-FEB-14
*********************Recovery catalog creation and register database
RMAN> create catalog;

recovery catalog created
RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> resync catalog;

starting full resync of recovery catalog
full resync complete

**********************RMAN Commands****************************************
RMAN> show all;

RMAN configuration parameters for database with db_unique_name XE are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE 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 'C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SNCFXE.ORA'; # default

RMAN> configure retention policy to recovery window of 7 days;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure backup optimization on;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> configure default device type to sbt;

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure default device type to disk;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> SHOW SNAPSHOT CONTROLFILE NAME;

RMAN configuration parameters for database with db_unique_name XE are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SNCFXE.ORA'; # defau
RMAN> report schema;

Report of database schema for database with db_unique_name XE

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    390      SYSTEM               YES     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
2    670      SYSAUX               NO      C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
3    40       UNDOTBS1             YES     C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
4    100      USERS                NO      C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
5    10       RMAN                 NO      C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEMP.DBF

********************Backup commands
RMAN> backup datafile 3;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T1
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 17-FEB-14
RMAN> backup datafile 5,3;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG201
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14
RMAN> backup datafile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF';

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
RMAN> backup tablespace users,temp;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/17/2014 16:34:46
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: Tablespace not found in
RMAN-06019: could not translate tablespace name "TEMP"

RMAN> backup tablespace users,undotbs1;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TA
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14
RMAN> backup database;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
…………………………………………………………………………………………………………………………………………………………………..
…………………………continue………………………………………………………………………………………………………………………………
#override optimization 
RMAN> BACKUP DATABASE FORCE;  

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
RMAN> backup database plus archivelog;

Starting backup at 17-FEB-14
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
…………………………………………………………………………………………………………………………………………………………………..
…………………………continue………………………………………………………………………………………………………………………………
RMAN> backup archivelog all;

Starting backup at 17-FEB-14
current log archived
…………………………………………………………………………………………………………………………………………………………………..
…………………………continue………………………………………………………………………………………………………………………………
RMAN> backup spfile;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
…………………………………………………………………………………………………………………………………………………………………..
…………………………continue………………………………………………………………………………………………………………………………
RMAN> backup current controlfile;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
…………………………………………………………………………………………………………………………………………………………………..
…………………………continue………………………………………………………………………………………………………………………………

RMAN> backup as backupset tablespace users;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=108 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG2014
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14
RMAN> backup as copy tablespace users;
Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_USERS_9J3VKKFN_.DBF tag=TAG20140217T164040 REC
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14
*******************Exclude Tablespace in the backup
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE users;

Tablespace USERS will be excluded from future whole database backups
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> BACKUP DATABASE;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
file 4 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE users clear;

Tablespace USERS will be included in future whole database backups
old RMAN configuration parameters are successfully deleted
starting full resync of recovery catalog
full resync complete
RMAN> backup database;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
RMAN> backup tablespace users format 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\BACKUP_%U';

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\BACKUP_0CP0S4U5_1_1 tag=TAG20140217T170924
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14

Starting Control File and SPFILE Autobackup at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\AUTOBACKUP\2014_02_17\O1_MF_S_83
Finished Control File and SPFILE Autobackup at 17-FEB-14

RMAN> BACKUP AS COPY TABLESPACE users,undotbs1 TAG mondaycpy;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_USERS_9J3XPSHY_.DBF tag=MONDAYCPY RECID=2 STAMP=839783860
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_UNDOTBS1_9J3XPWO9_.DBF tag=MONDAYCPY RECID=3 STAMP=839783862
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14

Starting Control File and SPFILE Autobackup at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\AUTOBACKUP\2014_02_17\O1_MF_S_839783864_9J3XQ12J_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-FEB-14
RMAN> backup as compressed backupset tablespace users;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NN
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
RMAN> backup as compressed copy tablespace users;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "copy": expecting one of: "backupset"
RMAN-01007: at line 1 column 22 file: standard input
*********************Incremental backup
RMAN> backup incremental level 1 database;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 3 found
RMAN> backup incremental level 0 database;

Starting backup at 17-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DB
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
RMAN> backup incremental level 1 database;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14

RMAN> backup incremental level 1 cumulative database;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14

RMAN> backup incremental level 1 tablespace users;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNND1
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14
RMAN> backup incremental level 1 cumulative tablespace users;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 17-FEB-14
channel ORA_DISK_1: finished piece 1 at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNND1_TAG2014021
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-FEB-14

Starting Control File and SPFILE Autobackup at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\AUTOBACKUP\2014_02_17\O1_MF_S_839784460_9J3
Finished Control File and SPFILE Autobackup at 17-FEB-14
RMAN> backup as copy incremental level 1 tablespace users;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/17/2014 17:30:21
RMAN-06022: invalid level specified for image copy: 1

RMAN> backup as copy database tag monday;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSAUX_9J3YOWBZ_.DBF tag=MONDAY RECID=9 STAMP=839784870
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSTEM_9J3YPOLY_.DBF tag=MONDAY RECID=10 STAMP=839784888
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_USERS_9J3YQ4QT_.DBF tag=MONDAY RECID=11 STAMP=839784895
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_UNDOTBS1_9J3YQ7WH_.DBF tag=MONDAY RECID=12 STAMP=839784897
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_RMAN_9J3YQC2X_.DBF tag=MONDAY RECID=13 STAMP=839784899
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
RMAN> backup incremental level 1 for recover of copy with tag 'monday' database;

Starting backup at 17-FEB-14
using channel ORA_DISK_1
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 5 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\UNDOTBS1.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSAUX_9J3YSZLG_.DBF tag=MONDAY RECID=14 STAMP=839785001
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSTEM_9J3YTRRS_.DBF tag=MONDAY RECID=15 STAMP=839785025
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\USERS.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_USERS_9J3YVL0F_.DBF tag=MONDAY RECID=16 STAMP=839785036
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_UNDOTBS1_9J3YVO5P_.DBF tag=MONDAY RECID=17 STAMP=839785038
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\RMAN.DBF
output file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_RMAN_9J3YVRC5_.DBF tag=MONDAY RECID=18 STAMP=839785040
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 17-FEB-14

Starting Control File and SPFILE Autobackup at 17-FEB-14
piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\AUTOBACKUP\2014_02_17\O1_MF_S_839785042_9J3YVTSF_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-FEB-14
***************************List, report commands
RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52      Full    8.65M      DISK        00:00:02     17-FEB-14
        BP Key: 53   Status: AVAILABLE  Compressed: NO  Tag: TAG20140217T163256
        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T
  List of Datafiles in backup set 52
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 678652     17-FEB-14 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
RMAN> list backupset;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52      Full    8.65M      DISK        00:00:02     17-FEB-14
        BP Key: 53   Status: AVAILABLE  Compressed: NO  Tag: TAG20140217T163256
        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_T
  List of Datafiles in backup set 52
RMAN> list backupset summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
52      B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T163256
65      B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T163331
82      B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T163429
103     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T163514
182     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T164009
282     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T164304
512     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T170924
548     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T170929
772     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T171744
898     B  F  A DISK        17-FEB-14       1       1       YES        TAG20140217T171928
944     B  F  A DISK        17-FEB-14       1       1       NO         TAG20140217T171938
RMAN> list backupset 52;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52      Full    8.65M      DISK        00:00:02     17-FEB-14
        BP Key: 53   Status: AVAILABLE  Compressed: NO  Tag: TAG20140217T163256
        Piece Name: C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20
  List of Datafiles in backup set 52
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 678652     17-FEB-14 C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found

RMAN> report need backup;

starting full resync of recovery catalog
full resync complete
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Report of files that must be backed up to satisfy 7 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> REPORT UNRECOVERABLE;

Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------

RMAN> configure retention policy to redundancy 1;

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          33     17-FEB-14          C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\ARCHIVELOG\2014_02_17\O1_MF_1_14_9J3TNWKJ_.ARC
Backup Set           52     17-FEB-14
  Backup Piece       53     17-FEB-14          C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T163256_9J3V31V9_.BKP
Backup Set           65     17-FEB-14
  Backup Piece       67     17-FEB-14          C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T163331_9J3V44VV_.BKP
Backup Set           82     17-FEB-14
  Backup Piece       85     17-FEB-14          C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T163429_9J3V5YOS_.BKP
**********************Corsscheck and validate
RMAN> crosscheck backup;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_T
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_T
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_T
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_T
crosschecked backup piece: found to be 'AVAILABLE'
RMAN> crosscheck backupset;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=107 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T163256_9J3V31V9_.BKP RECID=1 STAMP=839781177
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\BACKUPSET\2014_02_17\O1_MF_NNNDF_TAG20140217T163331_9J3V44VV_.BKP RECID=2 STAMP=839781212
RMAN> crosscheck copy;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=107 device type=DISK
specification does not match any control file copy in the repository
validation succeeded for datafile copy
datafile copy file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSTEM_9J3YT
validation succeeded for datafile copy
datafile copy file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSTEM_9J3YP
validation succeeded for datafile copy
datafile copy file name=C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE\DATAFILE\O1_MF_SYSTEM_9J3YL
validation succeeded for datafile copy

RMAN> validate datafile 3;

Starting validate at 18-FEB-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00003 name=C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              1            5120            695166
  File Name: C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSAUX.DBF
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              5119

Finished validate at 18-FEB-14


at No comments:
Labels:
Subscribe to: Posts (Atom)