Oracle 10g RAC backup RMAN

[Oracle @ node1 dbs] $ rman target/

Recovery Manager: Release 10.2.0.1.0-Production on Thu Sep 27 16:37:55 2012

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to target database: MYRAC (DBID = 4177338842)

RMAN> list backup;

Using target database control file insteadof recovery catalog

 

RMAN> show all;

 

RMAN configuration parameters 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 fordevice type disk to '% F'; # default

Configure device type disk parallelism 1 backup type to backupset; # default

Configure datafile backup copies for devicetype disk to 1; # default

Configure archivelog backup copies fordevice type disk to 1; # default

Configure maxsetsize to unlimited; # default

Configure encryption for database off; # default

Configure encryption algorithm 'aes128 '; # default

Configure archivelog deletion policy tonone; # default

Configure snapshot controlfile name to '/opt/oracle/database/product/10.2.0/db_1/dbs/snapcf_myrac1.f'; # default

 

RMAN> backup database plus archivelog;

 

 

Starting backup at 27-SEP-12

Current log archived

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid = 133 instance = MYRAC1devtype = DISK

Channel ORA_DISK_1: starting archive logbackupset

Channel ORA_DISK_1: specifying archivelog (s) in backup set

Input archive log thread = 1 sequence = 88 recid = 1 stamp = 795093263

Input archive log thread = 1 sequence = 89 recid = 2 stamp = 795108837

Input archive log thread = 1 sequence = 90 recid = 4 stamp = 795112903

Input archive log thread = 2 sequence = 47 recid = 3 stamp = 795108939

Input archive log thread = 2 sequence = 48 recid = 5 stamp = 795112824

Channel ORA_DISK_1: starting piece 1 at27-SEP-12

Channel ORA_DISK_1: finished piece 1 at27-SEP-12

Piece handle =/opt/oracle/database/product/10.2.0/db_1/dbs/01nm8tei_1_1tag = tag20120927t162132 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting full datafilebackupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno = 00001 name = + DATA/myrac/datafile/system.259.772910401

Input datafile fno = 00003 name = + DATA/myrac/datafile/sysaux.261.772910481

Input datafile fno = 00002 name = + DATA/myrac/datafile/undotbs1.260.772920.65

Input datafile fno = 00004 name = + DATA/myrac/datafile/undotbs2.263.772910521

Input datafile fno = 00005 name = + DATA/myrac/datafile/users.264.772910533

Channel ORA_DISK_1: starting piece 1 at27-SEP-12

RMAN-00571: ========================================================== ==============================

RMAN-00569: ==================== error messagestack follows ======================

RMAN-00571: ========================================================== ==============================

RMAN-03002: failure of backup plusarchivelog command at 09/27/2012 16:42:58

ORA-19502: write error on file "/opt/oracle/database/product/10.2.0/db_1/dbs/02nm8ter_1_1", blockno 63361 (blocksize = 8192)

ORA-27072: File I/O error.

Linux Error: 2: No such file or directory

Additional information: 4

Additional information: 63361

Additional information: 102400

 

Reconfigure the path

RMAN> configure device type disk backuptype to compressed backupset;

 

New RMAN configuration parameters:

Configure device type disk backup type tocompressed backupset parallelism 1;

New RMAN configuration parameters aresuccessfully stored

Released channel: ORA_DISK_1

RMAN> configure channel 1 device typedisk format '+ backup/bak _ % U ';

 

New RMAN configuration parameters:

Configure channel 1 device type diskformat' + backup/bak _ % U ';

New RMAN configuration parameters aresuccessfully stored

RMAN> configure controlfile autobackupformat for device type disk to '+ backup/autobackup_control _ % F ';

 

Old RMAN configuration parameters:

Configure controlfile autobackup format fordevice type disk to '+ DATA/MYRAC/controlfile/autobackup_control _ % F ';

New RMAN configuration parameters:

Configure controlfile autobackup format fordevice type disk to '+ backup/autobackup_control _ % F ';

New RMAN configuration parameters aresuccessfully stored

 

RMAN> configure snapshot controlfilename to '+ backup/snapcf_myrac1.f ';

 

Snapshot control file name set to: + backup/snapcf_myrac1.f

New RMAN configuration parameters aresuccessfully stored

RMAN> show all;

 

RMAN configuration parameters are:

Configure retention policy to redundancy 1; # default

Configure backup optimization off; # default

Configure default device type to disk; # default

Configure controlfile autobackup on;

Configure controlfile autobackup format fordevice type disk to '+ backup/autobackup_control _ % F ';

Configure device type disk backup type tocompressed backupset parallelism 1;

Configure datafile backup copies for devicetype disk to 1; # default

Configure archivelog backup copies fordevice type disk to 1; # default

Configure channel 1 device type diskformat' + backup/bak _ % U ';

Configure maxsetsize to unlimited; # default

Configure encryption for database off; # default

Configure encryption algorithm 'aes128 '; # default

Configure archivelog deletion policy tonone; # default

Configure snapshot controlfile name to '+ BACKUP/snapcf_myrac1.f ';

 

RMAN> backup database plus archivelog;

 

 

Starting backup at 27-SEP-12

Current log archived

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid = 133 instance = MYRAC1devtype = DISK

Channel ORA_DISK_1: starting compressedarchive log backupset

Channel ORA_DISK_1: specifying archivelog (s) in backup set

Input archive log thread = 1 sequence = 88 recid = 1 stamp = 795093263

Input archive log thread = 1 sequence = 89 recid = 2 stamp = 795108837

Input archive log thread = 1 sequence = 90 recid = 4 stamp = 795112903

Input archive log thread = 1 sequence = 91 recid = 7 stamp = 795115175

Input archive log thread = 2 sequence = 47 recid = 3 stamp = 795108939

Input archive log thread = 2 sequence = 48 recid = 5 stamp = 795112824

Input archive log thread = 2 sequence = 49 recid = 6 stamp = 795115090

Channel ORA_DISK_1: starting piece 1 at27-SEP-12

Channel ORA_DISK_1: finished piece 1 at27-SEP-12

Piece handle = + BACKUP/bak_03nm8vl8_1_1tag = TAG20120927T171935 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:11

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressedfull datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno = 00001 name = + DATA/myrac/datafile/system.259.772910401

Input datafile fno = 00003 name = + DATA/myrac/datafile/sysaux.261.772910481

Input datafile fno = 00002 name = + DATA/myrac/datafile/undotbs1.260.772920.65

Input datafile fno = 00004 name = + DATA/myrac/datafile/undotbs2.263.772910521

Input datafile fno = 00005 name = + DATA/myrac/datafile/users.264.772910533

Channel ORA_DISK_1: starting piece 1 at27-SEP-12

Channel ORA_DISK_1: finished piece 1 at27-SEP-12

Piece handle = + BACKUP/bak_04nm8vll_1_1tag = TAG20120927T171949 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35

Finished backup at 27-SEP-12

 

Starting backup at 27-SEP-12

Current log archived

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressedarchive log backupset

Channel ORA_DISK_1: specifying archivelog (s) in backup set

Input archive log thread = 1 sequence = 92 recid = 8 stamp = 795115285

Input archive log thread = 2 sequence = 50 recid = 9 stamp = 795115204

Channel ORA_DISK_1: starting piece 1 at27-SEP-12

Channel ORA_DISK_1: finished piece 1 at27-SEP-12

Piece handle = + BACKUP/bak_05nm8vos_1_1tag = TAG20120927T172132 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 27-SEP-12

 

Starting Control File and SPFILE Autobackupat 27-SEP-12

Piecehandle = + BACKUP/autobackup_control_c-4177338842-20120927-00 comment = NONE

Finished Control File and SPFILE Autobackupat 27-SEP-12

 

View shared disks:

ASMCMD> pwd

+ Backup

ASMCMD> ls

MYRAC/

Autobackup_control_c-4177338842-20120927-00

Bak_03nm8vl8_1_1

Bak_04nm8vll_1_1

Bak_05nm8vos_1_1

Snapcf_myrac1.f

ASMCMD>

In fact, these are shortcuts to connect to the MYRAC

ASMCMD> ls-ls

Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name

Y myrac/

N autobackup_control_c-4177338842-20120927-00 => + BACKUP/MYRAC/AUTOBACKUP/2012_09_27/s_795115295.260.795115299

N bak_03nm8vl8_1_1 => + BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_TAG20120927T171935_0.256.795115181

N bak_04nm8vll_1_1 => + BACKUP/MYRAC/BACKUPSET/2012_09_27/nnndf0_TAG20120927T171949_0.257.795115191

N bak_05nm8vos_1_1 => + BACKUP/MYRAC/BACKUPSET/2012_09_27/annnf0_tag20120927t171_2_0.258.795115295

N snapcf_myrac1.f => + BACKUP/MYRAC/CONTROLFILE/Backup.259.795115295