Home » RDBMS Server » Backup & Recovery » RMAN AND ASM (Solaris 2.10 Oracle 11203)
RMAN AND ASM [message #546879] Fri, 09 March 2012 10:17 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
I am looking into backuping up my DB to an ASM diskgroup using
RMAN.

I saw an example of setting a disk group for backing up
CONTROL files


CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+CONTROL';



What command do I need to specify to backup my DB and .arc
files to a location called '+FRA'? Can somebody provide
an example?

when all is said and done I want to issue this command from
RMAN


 BACKUP DATABASE PLUS ARCHIVELOG;



Thanks to all who answer
RMAN AND ASM [message #546883 is a reply to message #546879] Fri, 09 March 2012 11:50 Go to previous messageGo to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
Got it!!


CONFIGURE CHANNEL 0 DEVICE TYPE DISK FORMAT   '+FRA';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '+FRA';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '+FRA';


RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Starting backup at 03-09-2012 09:47:05
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1140 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=62 RECID=58 STAMP=777288598
input archived log thread=1 sequence=63 RECID=59 STAMP=777308456
input archived log thread=1 sequence=64 RECID=60 STAMP=777330037
input archived log thread=1 sequence=65 RECID=61 STAMP=777333767
input archived log thread=1 sequence=66 RECID=62 STAMP=777345578
input archived log thread=1 sequence=67 RECID=63 STAMP=777365941
input archived log thread=1 sequence=68 RECID=64 STAMP=777385850
input archived log thread=1 sequence=69 RECID=65 STAMP=777399730
input archived log thread=1 sequence=70 RECID=66 STAMP=777420020
input archived log thread=1 sequence=71 RECID=67 STAMP=777420188
input archived log thread=1 sequence=72 RECID=68 STAMP=777438034
input archived log thread=1 sequence=73 RECID=69 STAMP=777459103
input archived log thread=1 sequence=74 RECID=70 STAMP=777462425
channel ORA_DISK_1: starting piece 1 at 03-09-2012 09:47:17
channel ORA_DISK_1: finished piece 1 at 03-09-2012 09:47:24
piece handle=+FRA/vsccst1/backupset/2012_03_09/annnf0_tag20120309t094712_0.311.777462437 tag=TAG20120309T094712 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 03-09-2012 09:47:24

Starting backup at 03-09-2012 09:47:24
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=00001 name=+DATA/vsccst1/datafile/system.257.776442365
input datafile file number=00002 name=+DATA/vsccst1/datafile/sysaux.256.776442365
input datafile file number=00003 name=+DATA/vsccst1/datafile/undotbs1.260.776442365
input datafile file number=00006 name=+DATA/vsccst1/datafile/vscc_data01.270.777215855
input datafile file number=00004 name=+DATA/vsccst1/datafile/users.261.776442365
input datafile file number=00005 name=+DATA/vsccst1/datafile/tools.269.776493019
input datafile file number=00007 name=+DATA/vsccst1/datafile/vscc_idx01.271.777215867
channel ORA_DISK_1: starting piece 1 at 03-09-2012 09:47:29
channel ORA_DISK_1: finished piece 1 at 03-09-2012 09:47:54
piece handle=+FRA/vsccst1/backupset/2012_03_09/nnndf0_tag20120309t094724_0.309.777462451 tag=TAG20120309T094724 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 03-09-2012 09:47:54

Starting backup at 03-09-2012 09:47:55
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=75 RECID=71 STAMP=777462475
channel ORA_DISK_1: starting piece 1 at 03-09-2012 09:48:04
channel ORA_DISK_1: finished piece 1 at 03-09-2012 09:48:05
piece handle=+FRA/vsccst1/backupset/2012_03_09/annnf0_tag20120309t094800_0.308.777462485 tag=TAG20120309T094800 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-09-2012 09:48:05

Starting Control File and SPFILE Autobackup at 03-09-2012 09:48:05
piece handle=+FRA/vsccst1/autobackup/2012_03_09/s_777462490.307.777462491 comment=NONE
Finished Control File and SPFILE Autobackup at 03-09-2012 09:48:11


Re: RMAN AND ASM [message #546890 is a reply to message #546883] Fri, 09 March 2012 14:25 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know.

Regards
Michel
Previous Topic: Backup selected data
Next Topic: Multiple Times DB PITR from the same database snapshot
Goto Forum:
  


Current Time: Mon Oct 22 05:49:04 CDT 2018