Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog
Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, December 08, 2010

Diffrent Clauses to be used in RMAN script

There can be many different clauses can be used in RMAN script. You should use any clause which suites your environment. I'm providing them as single by single so that concept is clear with the help of the output.
First read the RMAN Backup Intro - Example (10gR2) and then you can add any clause from the given below.

not backed up since time -  
There are cases when backups faile and the stand becomes unclear. To avoid any risk the clause not backed up since time can be used. This commands makes rman save only the datafiles (or the archived logs) that haven't be backed up for a certain span of time and skip the rest.
RMAN> backup database format 'D:\Home_Backup\ASMRMAN\%d_%u_%s' not backed up since time 'sysdate -5';
RMAN> BACKUP CURRENT CONTROLFILE format 'D:\Home_Backup\ASMRMAN\CF_%d_%u_%s';
Starting backup at 08-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\CF_ASMDB_1HLV1ID7_49 tag=TAG20101208T095551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-DEC-10

RMAN> backup database format 'D:\Home_Backup\ASMRMAN\%d_%u_%s';
 Starting backup at 08-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
input datafile fno=00006 name=+DB_DATA/asmdb/datafile/ggs_data.267.734093627
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
input datafile fno=00008 name=+DB_DATA/asmdb/datafile/example.dbf
input datafile fno=00002 name=+DB_DATA/asmdb/datafile/undotbs1.260.733408851
input datafile fno=00005 name=+DB_DATA/asmdb/datafile/xdb.264.733412967
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\ASMDB_11LV1EOO_33 tag=TAG20101208T085344 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\ASMDB_12LV1EPR_34 tag=TAG20101208T085344 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-DEC-10
RMAN> backup archivelog all format 'D:\HOME_BACKUP\ASMRMAN\arch_%d_%u_%s' delete input; 
Starting backup at 08-DEC-10
 current log archived
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: sid=15 devtype=DISK
 channel ORA_DISK_1: starting archive log backupset
 channel ORA_DISK_1: specifying archive log(s) in backup set
 input archive log thread=1 sequence=44 recid=26 stamp=737135294
 input archive log thread=1 sequence=45 recid=27 stamp=737135298
 input archive log thread=1 sequence=46 recid=28 stamp=737135312
 input archive log thread=1 sequence=47 recid=29 stamp=737135339
 input archive log thread=1 sequence=48 recid=30 stamp=737196664
 channel ORA_DISK_1: starting piece 1 at 08-DEC-10
 channel ORA_DISK_1: finished piece 1 at 08-DEC-10
 piece handle=D:\HOME_BACKUP\ASMRMAN\ARCH_ASMDB_10LV1EJS_32 tag=TAG20101208T085106 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05
 channel ORA_DISK_1: deleting archive log(s)
 archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00044_0733408811.001.arc recid=26 stamp=737135294
 archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00045_0733408811.001.arc recid=27 stamp=737135298
 archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00046_0733408811.001.arc recid=28 stamp=737135312
 archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00047_0733408811.001.arc recid=29 stamp=737135339
 archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/2010_12_08/thread_1_seq_48.265.737196655 recid=30 stamp=737196664
 Finished backup at 08-DEC-10
 
RMAN> BACKUP DATABASE PLUS ARCHIVELOG format 'D:\HOME_BACKUP\ASMRMAN\arch_%d_%u_%s' DELETE INPUT TAG Daily_ASMDB_bkp; 
Starting backup at 07-DEC-10
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=20 recid=1 stamp=736266895
input archive log thread=1 sequence=26 recid=8 stamp=736603525
input archive log thread=1 sequence=43 recid=25 stamp=737131747
channel ORA_DISK_1: starting piece 1 at 07-DEC-10
channel ORA_DISK_1: finished piece 1 at 07-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\ARCH_ASMDB_0ELUVF74_14 tag=DAILY_ASMDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: deleting archive log(s)
archive log filename=D:\ORACLE\PRODUCT\10.2.0\DB_1\RDBMS\ARC00020_0733408811.001 recid=1 stamp=736266895
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00026_0733408811.001.arc recid=8 stamp=736603525
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00043_0733408811.001.arc recid=25 stamp=737131747
Finished backup at 07-DEC-10

Starting backup at 07-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
input datafile fno=00006 name=+DB_DATA/asmdb/datafile/ggs_data.267.734093627
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
input datafile fno=00008 name=+DB_DATA/asmdb/datafile/example.dbf
input datafile fno=00002 name=+DB_DATA/asmdb/datafile/undotbs1.260.733408851
input datafile fno=00005 name=+DB_DATA/asmdb/datafile/xdb.264.733412967
channel ORA_DISK_1: starting piece 1 at 07-DEC-10
channel ORA_DISK_1: finished piece 1 at 07-DEC-10
piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\0FLUVF7D_1_1 tag=TAG20101207T144917 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 07-DEC-10
channel ORA_DISK_1: finished piece 1 at 07-DEC-10
piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\0GLUVF8G_1_1 tag=TAG20101207T144917 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-10

Starting backup at 07-DEC-10
ORACLE error from target database:
ORA-16038: log 2 sequence# 44 cannot be archived
ORA-00254: error in archive control string ''
ORA-00312: online log 2 thread 1: '+DB_DATA/asmdb/onlinelog/group_2.258.733408833'
ORA-15173: entry 'asmdb' does not exist in directory '/'

using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 07-DEC-10

RMAN> CROSSCHECK BACKUP;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\06LUVC47_1_1 recid=6 stamp=737128585
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\07LUVC7L_1_1 recid=7 stamp=737128694
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=D:\HOME_BACKUP\ASMRMAN\ASMDB_0BLUVDSN_11 recid=11 stamp=737130392
Crosschecked 3 objects
RMAN> CROSSCHECK ARCHIVELOG ALL;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/arc00020_0733408811.001 recid=7 stamp=736426851
validation succeeded for archived log
archive log filename=D:\ORACLE\PRODUCT\10.2.0\DB_1\RDBMS\ARC00020_0733408811.001 recid=1 stamp=736266895
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/2010_11_28/thread_1_seq_21.256.736267637 recid=2 stamp=736267637
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/arc00022_0733408811.001 recid=3 stamp=736268303
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00023_0733408811.001.arc recid=4 stamp=736268549
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00024_0733408811.001.arc recid=5 stamp=736384321
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00025_0733408811.001.arc recid=6 stamp=736425084
validation succeeded for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00026_0733408811.001.arc recid=8 stamp=736603525
validation failed for archived log
archive log filename=+DB_ARCHIVELOG/asmdb/archivelog/asmdb_00027_0733408811.001.arc recid=9 stamp=736604997
Crosschecked 9 objects
RMAN> DELETE EXPIRED BACKUP;
using channel ORA_DISK_1
List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6       6       1   1   EXPIRED     DISK        D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\06LUVC47_1_1
7       7       1   1   EXPIRED     DISK        D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\07LUVC7L_1_1

Do you really want to delete the above objects (enter YES or NO)? no
RMAN> DELETE EXPIRED BACKUPSET 6;
using channel ORA_DISK_1
List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6       6       1   1   EXPIRED     DISK        D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\06LUVC47_1_1
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\06LUVC47_1_1 recid=6 stamp=737128585
Deleted 1 EXPIRED objects
RMAN> DELETE NOPROMPT EXPIRED BACKUP;
using channel ORA_DISK_1
List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
7       7       1   1   EXPIRED     DISK        D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\07LUVC7L_1_1
deleted backup piece
backup piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\07LUVC7L_1_1 recid=7 stamp=737128694
Deleted 1 EXPIRED objects
RMAN> BACKUP VALIDATE DATABASE;
Starting backup at 07-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
input datafile fno=00006 name=+DB_DATA/asmdb/datafile/ggs_data.267.734093627
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
input datafile fno=00008 name=+DB_DATA/asmdb/datafile/example.dbf
input datafile fno=00002 name=+DB_DATA/asmdb/datafile/undotbs1.260.733408851
input datafile fno=00005 name=+DB_DATA/asmdb/datafile/xdb.264.733412967
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-10
RMAN> BACKUP AS COPY TABLESPACE users format 'D:\Home_Backup\ASMRMAN\%d_%u_%s_USERSTS'; -- (list backupset will not show)
Starting backup at 07-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0KLUVG2S_20_USERSTS tag=TAG20101207T150356 recid=4 stamp=737132643
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 07-DEC-10
RMAN> BACKUP AS COPY DATAFILE 1 format 'D:\Home_Backup\ASMRMAN\%d_%u_%s_DataFile1';  -- not listed in list backupset command
Starting backup at 07-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0LLUVGAH_21_DATAFILE1 tag=TAG20101207T150801 recid=5 stamp=737132888
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0MLUVGAO_22_DATAFILE1 tag=TAG20101207T150801 recid=6 stamp=737132890
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 07-DEC-10
RMAN> report need backup; 
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
2    0     +DB_DATA/asmdb/datafile/undotbs1.260.733408851
3    0     +DB_DATA/asmdb/datafile/sysaux.261.733408851
4    0     +DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
5    0     +DB_DATA/asmdb/datafile/xdb.264.733412967
6    0     +DB_DATA/asmdb/datafile/ggs_data.267.734093627
8    0     +DB_DATA/asmdb/datafile/example.dbf
RMAN> BACKUP AS COPY DATABASE format 'D:\Home_Backup\ASMRMAN\%d_%u_%s_copyDB';  -- does not create backupset
Starting backup at 07-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0NLUVIUH_23_COPYDB tag=TAG20101207T155249 recid=7 stamp=737135576
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0OLUVIUO_24_COPYDB tag=TAG20101207T155249 recid=8 stamp=737135583
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0PLUVIV0_25_COPYDB tag=TAG20101207T155249 recid=9 stamp=737135590
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=+DB_DATA/asmdb/datafile/ggs_data.267.734093627
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0QLUVIV7_26_COPYDB tag=TAG20101207T155249 recid=10 stamp=737135597
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0RLUVIVE_27_COPYDB tag=TAG20101207T155249 recid=11 stamp=737135604
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00008 name=+DB_DATA/asmdb/datafile/example.dbf
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0SLUVIVL_28_COPYDB tag=TAG20101207T155249 recid=12 stamp=737135611
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=+DB_DATA/asmdb/datafile/undotbs1.260.733408851
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0TLUVIVS_29_COPYDB tag=TAG20101207T155249 recid=13 stamp=737135617
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=+DB_DATA/asmdb/datafile/xdb.264.733412967
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0ULUVJ03_30_COPYDB tag=TAG20101207T155249 recid=14 stamp=737135623
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=D:\HOME_BACKUP\ASMRMAN\ASMDB_0VLUVJ0A_31_COPYDB tag=TAG20101207T155249 recid=15 stamp=737135627
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 07-DEC-10
CATALOG BACKUPPIECE: 
This allows backup files to be moved to alternate locations or manually archived to tape and brought back for restore operations.
catalog backuppiece ; {repeat this for each backup file}
# Catalog all files and the contents of directories which
# begin with the pattern "/backup/MYSID/arch". 
CATALOG START WITH '/backup/MYSID/arch';
RMAN> CATALOG BACKUPPIECE 'D:\HOME_BACKUP\ASMRMAN\NEWLOC\ARCH_ASMDB_10LV1EJS_32';
cataloged backuppiece
backup piece handle=D:\HOME_BACKUP\ASMRMAN\NEWLOC\ARCH_ASMDB_10LV1EJS_32 recid=19 stamp=737197432

RMAN> BACKUP AS BACKUPSET DATAFILE '+DB_DATA/asmdb/datafile/system.259.733408841', '+DB_DATA/asmdb/datafile/sysaux.261.733408851';Starting backup at 08-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\1ILV1IK9_1_1 tag=TAG20101208T095937 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\1JLV1IKO_1_1 tag=TAG20101208T095937 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-DEC-10

RMAN> BACKUP TABLESPACE MYTS_ON_ASM format 'D:\Home_Backup\ASMRMAN\myts_on_asm_%d_%u_%s';Starting backup at 08-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.733412067
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\MYTS_ON_ASM_ASMDB_1MLV1IVK_54 tag=TAG20101208T100540 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-DEC-10

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE  format 'D:\Home_Backup\ASMRMAN\DBBKP_%d_%u_%s';
Starting backup at 08-DEC-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DB_DATA/asmdb/datafile/system.259.733408841
input datafile fno=00003 name=+DB_DATA/asmdb/datafile/sysaux.261.733408851
input datafile fno=00004 name=+DB_DATA/asmdb/datafile/myts_on_asm.263.737207077
input datafile fno=00006 name=+DB_DATA/asmdb/datafile/ggs_data.267.734093627
input datafile fno=00007 name=+DB_DATA/asmdb/datafile/users.dbf
input datafile fno=00008 name=+DB_DATA/asmdb/datafile/example.dbf
input datafile fno=00002 name=+DB_DATA/asmdb/datafile/undotbs1.260.733408851
input datafile fno=00005 name=+DB_DATA/asmdb/datafile/xdb.264.733412967
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\DBBKP_ASMDB_1VLV1Q23_63 tag=TAG20101208T120627 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-DEC-10
channel ORA_DISK_1: finished piece 1 at 08-DEC-10
piece handle=D:\HOME_BACKUP\ASMRMAN\DBBKP_ASMDB_20LV1Q37_64 tag=TAG20101208T120627 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 08-DEC-10

backup AS COMPRESSED BACKUPSET archivelog all format 'D:\Home_Backup\ASMRMAN\ARC_%d_%u_%s';

Observation: for the same db backup compressed to 72M from 432M
RMAN> HOST 'DIR > d:\output.txt'; -- runs any OS command
host command complete
RMAN> SQL "ALTER SYSTEM ARCHIVE LOG CURRENT"; -- run sql from rman, cannot --use Select statements
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';

Some Other Clauses

Displaying Current RMAN Configuration Settings: SHOW

RMAN> SHOW ALL;    # shows all CONFIGURE settings, both user-entered and default
RMAN> SHOW RETENTION POLICY;
RMAN> SHOW DEFAULT DEVICE TYPE;
LIST
List the backups and copies recorded in the repository.
  RMAN> LIST BACKUP;
  RMAN> LIST BACKUP OF DATABASE;
  RMAN> LIST BACKUP SUMMARY;
  RMAN> LIST INCARNATION;
  RMAN> LIST BACKUP BY FILE;
  RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
  RMAN> LIST COPY OF DATAFILE 1, 2, 3;
  RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;
  RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
  RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
  RMAN> LIST BACKUPSET OF DATAFILE 1; 
 
Report 
Report backup status: 
  database files, status of files and  backups (obsolete or   unrecoverable.) 
The REPORT command performs more complex analysis than LIST. 
 



 

  









 

















Posted by



at


























Labels:

















No comments:











Post a Comment













        

      









Subscribe to:
Post Comments (Atom)