Sunday, May 15, 2011

Client want to go for DR test.The changes During DR Test should Not REflect On Prod(Means the changed Data during DR Test should Not reflect on primar

Possibility1:Planned Fail over


Note:Primary Database will be down until DR Test completes

a.Take cold/hot/RMAN backup on primary before DR test

b.Take cold/hot/RMAN backup on standby Database before DR test.
c.Shutdown Primary Database

d.On standby Database fire the below command sql> alter database activate standby database;

e.Once standby Database is activated,Execute the below command. sql > alter database open

f.Now standby Database is converted to primary Database.

g.Go For DR Test
Post Fail over:After DR test.

a.shutdown standby Database(Which was activated as per step d) b.remove all the datafile,controlfile,redologfile....except pfile or spfile or Drop Database on standby Database

c.Restore the backup on standby Database (which was taken on step b)
d.After successful Restore,Execute below commands
startup nomount

sql > alter database mount standby Database


alter database recover managed standby database disconnect from session;


e.start the Primary Database(This step can be done as per the requirement..means you can start earlier also)


f.Do Manual switches sql > alter system switch logfile ;

g.check the synchronization with standby Database.


Other Possibility will be posted shortly..Hope the above scenario makes helps..Be free to comment or suggestion... Cheers, Ayyappa Y
------------*****--****----------------------
Possibility2 :Using FLASHBACK ON STANDBY DATABASE

Requirements

The following requirements need to be met in order to create a snapshot standby.

1.Database version should be 10.2* or higher
2.Primary & standby Database should be in archive log mode
3.Database should be in sync before you proceed.
4.Flash Recovery Area (FRA) is required on the standby database to implement a Flashback database.


ON PRIMARY DATABASE:

a.Do Manual switches
sql > ALTER SYSTEM ARCHIVE LOG CURRENT;

b.check the synchronization with standby Database
sql > select max(sequence#) from v$log_history;

c.Stop the synchronization & shipping of the archives from primary:
sql > alter system set log_archive_dest_stat2_2=defer;

On standby Database:

a.Cancel The Recovery Process:
sql > alter database recover managed standby database cancel;

b.Create Guarantee Restore point
CREATE RESTORE POINT ayyu_stdby GUARANTEE FLASHBACK DATABASE;

c.Activate the standby Database
sql > alter database activate standby database;

d.Open the standby Database
sql > alter database open

Now You can use the DR box for testing purpose..

e.Once testing is completed.Perform the Following

sql > shu immediate;
sql > startup Mount;

sql>Flashback Database to restore point ayyu_stdby;
sql > ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Post DR test:

On Primary:

a.Enable the archive destination
sql > alter system set log_archive_dest_stat2_2=enable;

On standby:

a.start the recovery Process
sql > alter database recover managed standby database disconnect from session;


============================================================

Possibility-3 :Using SNAPSHOT STANDBY FEATURE IN 11G(Below Document is from ORACLE_BASE)

Snapshot standby allows the standby database to be opened in read-write mode. When switched back into standby mode, all changes made whilst in read-write mode are lost. This is achieved using flashback database, but the standby database does not need to have flashback database explicitly enabled to take advantage of this feature, thought it works just the same if it is.
If you are using RAC, turn off all but one of the RAC instances. Make sure the instance is in MOUNT mode.
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
Make sure managed recovery is disabled.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Convert the standby to a snapshot standby. The following example queries the V$DATABASE view to show that flashback database is not enabled prior to the conversion operation.
SELECT flashback_on FROM v$database;

FLASHBACK_ON
------------------
NO

ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
ALTER DATABASE OPEN;
SELECT flashback_on FROM v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY

SQL>
You can now do treat the standby like any read-write database.
To convert it back to the physical standby, losing all the changes made since the conversion to snapshot standby, issue the following commands.
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
SELECT flashback_on FROM v$database;

FLASHBACK_ON
------------------
NO

SQL>
The standby is once again in managed recovery and archivelog shipping is resumed. Notice that flashback database is still not enabled.

============================================================

8 comments:

Coskan Gundogar said...

Why don't you just use free flashback database option instead of backup restore ?

ayyudba said...

Hey..Thanks For Visiting my BLOG
I replied mail to your individual mail...As i said..the earlier post was possibility1...and was about to publish the 2nd possibility..which you mention..Thanks for suggestion...Here we go for the possibility 2...--Feel Free for any suggestion/clarification/comments

Anonymous said...

http://acheter-base-email.fr/

http://acheter-fichier-email.fr/

http://acheter-fichier-email.com/

http://acheter-fichiers-emails.fr/

http://acheter-fichier-emails.fr/

http://acheter-fichier-client-prospection.fr/

http://acheter-base-de-donnees-emails.fr/

http://acheter-base-de-donnee-email.com/



Website: acheter-base-email.fr
Title: acheter fichier email ,fichier email ,acheter base de donnee email - acheter fichier email
Description: acheter fichier email ,fichier email ,acheter base de donnee email ,acheter fichier email

Website: acheter-fichier-email.fr
Title: acheter fichier email professionnels,Acheter fichiers e-mails de professionnels,acheter fi
Description: acheter fichier email ,fichier email ,acheter fichier email professionnels,acheter fichier


Website: acheter-fichier-email.com
Title: acheter fichier email,Achat fichier Email,acheter base de donnees emails - acheter-fichier
Description: fichier email,acheter fichier email, Achat fichier Email , acheter base de donnees emails

Website: acheter-fichiers-emails.fr
Title: Acheter fichier email, base de donnee email, Achat Fichier email et adresse emails liste e
Description: achat email et fichier email , nous vous proposons acheter des fichiers e-mail de france e

Website: acheter-fichier-emails.fr
Title: Acheter fichier email, Acheter fichier, fichier email, Acheter fichier email, Acheter fich
Description: acheter fichier email, Location fichiers et base de données btob pour des entreprises,

Website: acheter-fichier-client-prospection.fr
Title: Acheter fichier email, fichier email, base de données mailing - Acheter fichier email, ac
Description: Acheter fichier email de professionnels et particuliers pour gérer vos campagnes emailing

Website: acheter-base-de-donnees-emails.fr
Title: Acheter base de donnée email , achat base de données email - Acheter Base de Données Em
Description: acheter base de donnee email , acheter base de donnee ,acheter base de donnee email

Website: acheter-base-de-donnee-email.com
Description: acheter base de donnée email acheter fichier email acheter fichier email fichier email ac
Type: fashion,Marketing


raybanoutlet001 said...

ugg boots
omega watches sale
ugg boots
coach outlet
hermes belts
gucci shoes
coach outlet store online
coach outlet store
mont blanc outlet
valentino outlet

Unknown said...

longchamp bags
adidas gazelle sale
adidas stan smith uk
led light up shoes
adidas tubular UK
nmd
gucci belts for men
pandora jewelry
nike air max
air jordans

yanmaneee said...

off white nike
golden goose sale
yeezy shoes
curry shoes
yeezy boost 350 v2
moncler coat
curry 8
yeezy boost 350 v2
kyrie 7
kd 12

Anonymous said...

jordan shoes
supreme clothing
moncler outlet
hermes handbags
supreme clothing
palm angels
supreme hoodie
off white hoodie
bape sta
kyrie 7

Anonymous said...

fear of god outlet
jordans
kyrie shoes
golden goose sneakers
yeezy boost 350
fear of god
air jordan
supreme outlet
golden goose sneakers
jordan 4