Home » RDBMS Server » Backup & Recovery » RMAN Clone database using SMU / ZFS (Solaris 10, 11 & 11.2.0.4.4)
RMAN Clone database using SMU / ZFS [message #626223] Wed, 22 October 2014 22:18 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Question In RMAN Incremental image backup with ZFS Storage appliance and Oracle snap management utility Clone.

As per Notes: 1522925.1

> Backup must be in image copy format
> Backup files must use the RMAN %U format spec
> Backup set must only contain one controlfile, one or more datafiles and one or more archived logs

In ZFS Appliance I have 3 shares with respective of datafiles, archive and control file for RMAN Image copy. I am using below script to have the incremental l0 & l1 backup to ZFS shares.

In End of the script, I have copy of current control file to "/backup/test/control" control share. When I run the Level 0 & level 1 RMAN create unique control file to control share but according to oracle notes I should have only one copy of control file. In such case oracle snap management not able to do the clone database.

Is there any ways to have copy of current control file with %U format by using reuse option ? but again %U create unique name, for every level 1 I have different control file backup.

run {
set nocfau;
 configure device type disk parallelism 10 backup type to copy;
 allocate channel ch1 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch2 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch3 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch4 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch5 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch6 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch7 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch8 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch9 device type disk format '/backup/test/datafiles/%U';
 allocate channel ch10 device type disk format '/backup/test/datafiles/%U';
 backup incremental level 1
 for recover of copy with tag 'zfssa_clone' database reuse;
 recover copy of database with tag 'zfssa_clone';
 release channel ch1;
 release channel ch2;
 release channel ch3;
 release channel ch4;
 release channel ch5;
 release channel ch6;
 release channel ch7;
 release channel ch8;
}

sql 'alter system switch logfile';
sql 'alter system switch logfile';

run {
 allocate channel ch1 device type disk format '/backup/test/archive/%U';
 allocate channel ch2 device type disk format '/backup/test/archive/%U';
 allocate channel ch3 device type disk format '/backup/test/archive/%U';
 allocate channel ch4 device type disk format '/backup/test/archive/%U';
 allocate channel ch5 device type disk format '/backup/test/archive/%U';
 allocate channel ch6 device type disk format '/backup/test/archive/%U';
backup as copy archivelog all;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
}

run
{
set nocfau;
allocate channel ch1 device type disk format '/backup/test/control/%U';
backup as copy current controlfile ;
configure controlfile autobackup off;
}


Oracle snap management utility clone error [ SMU ]

Deleting clone application account
--- TASK FAILED ---
No controlfiles found in the backup
Re: RMAN Clone database using SMU / ZFS [message #626244 is a reply to message #626223] Thu, 23 October 2014 06:47 Go to previous message
EdStevens
Messages: 976
Registered: September 2013
Senior Member
https://community.oracle.com/thread/3622442
Previous Topic: Rman backup with keep
Next Topic: invalid objects after db restore
Goto Forum:
  


Current Time: Tue Oct 16 05:35:07 CDT 2018