No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Creating a standby DataGuard database from RMAN backup done through Commvault
Next thread: Where to find history of v$process and v$session
Prev thread: database recovery

Message Score Author Date
Hi, I am trying to get the RMAN code to create ...... Lauri Oct 29, 2019, 08:32

Follow up by mail Click here


Subject: Creating a standby DataGuard database from RMAN backup done through Commvault
Author: Lauri, Netherlands
Date: Oct 29, 2019, 08:32, 212 days ago
Os info: Linux x86 64bit
Oracle info: 12cR2
Error info: na
Message: Hi,

I am trying to get the RMAN code to create a standby database from an RMAN backup done through Commvault.
I am not sure of the syntax of the code.

Does someone has experience with RMAN Commvault backups and standby database (DataGuard)?

Here are the steps I thought about:

Primary database unqiue name: AMS1PC1
Standby database unique name: AMS1PC1SBY

TNS name primary database: AMS1PC1
TNS name standby database: AMS1PC1SBY

1) Stap 1: connect to auxiliary (standby database to be created):

connect target sys/<password>@AMS1PC1

connect auxiliary sys/<password>@AMS1PC1SBY

2) Stap 2: backup archive logs frpm primary database:

-- Backup archivelogs
run
{
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/commvault/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)" TRACE 0;
allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/commvault/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2)" TRACE 0;
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
sql 'alter system switch logfile';
sql 'alter system switch logfile';
sql 'alter system switch logfile';
backup archivelog all not backed up 1 times;
}

3) Step 3: create the standby database from Commvault RMAN backup:

-- Create standby from RMAN backup
run
{
allocate auxiliary channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/commvault/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)" TRACE 0;
allocate auxiliary channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/simpana/commvault/Base/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2)" TRACE 0;
set until time "to_date('<date in format DD-MM-YYYY HH24:MI:SS', 'DD-MM-YYYY HH24:MI:SS')";
duplicate target database to AMS1PC1SBY
spfile
set db_unique_name="ams1pc1sby"
set log_file_name_convert="ams1pc1","ams1pc1","ams1pc1","ams1pc1"
set archive_lag_target="900"
set local_listener="server-db-10.amr.local:12000"
nofilenamecheck;
}

Any idea or suggestions?
Thanks by advance for sharing your exprience.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here