This forum is currently locked. You can't register or post questions at this time. (read more)

Datagaurd changing mode

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Datagaurd changing mode

Postby royalyogi » Tue Jul 30, 2013 5:47 am

DataGuard:

How can we change the max protection mode to max availability mode while cloning of database? Please give me steps of link

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Re: Datagaurd changing mode

Postby royalyogi » Tue Jul 30, 2013 5:51 am

Tim one more doubt: if we have 2TB database size and we lost 100gb tablespace then how can we restore tablespace since No flashback and recycle bin is also not enabled? Please help me

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Datagaurd changing mode

Postby Tim... » Tue Jul 30, 2013 7:29 am

Hi.

The first point does not make sense. Why would you be trying to change protection mode in the middle of another operation?

If you have lost a tablespace, this is a physical loss, so your only option is to recover it from backups.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests