OraFAQ Forum: Backup & Recovery » Database Synchronisation

Home » RDBMS Server » Backup & Recovery » Database Synchronisation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Synchronisation [message #336422]

Sat, 26 July 2008 11:52

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Before synchronising primary database with standby database , we found some of the current datafiles missing ( to be synced with standby db)in primary database(may be deleted accidently).i want to synced the missing datafiles with standby database.Please provide me the steps to sync missing datafiles(primary db) with standby database.

Regards
Balaji

Report message to a moderator

Re: Database Synchronisation [message #336423 is a reply to message #336422]

Sat, 26 July 2008 11:55

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As I said in the previous topic you hijacked, this is not the correct forum.
Don't you see there is a forum whose purpose is:
"physical (redo apply) and logical (SQL apply) standby databases."
Don't you think that your question relative to standby database would be appropriate in this forum?

Regards
Michel

Report message to a moderator

Re: Database Synchronisation [message #336424 is a reply to message #336422]

Sat, 26 July 2008 11:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

If these files are missing from the primary & not causing any problems, what is gained by recovering them?

You need to determine a few "details" before proceeding.
1) when did these files go missing?
2) Do you have backups which contain these files?

If you do not have backups that contain the missing files, no recovery is possible.

Report message to a moderator

Re: Database Synchronisation [message #336450 is a reply to message #336424]

Sat, 26 July 2008 23:20

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

i never said b4 the missing files are causing problem.i want the currently generated arhivelogfiles (sorry not datafiles) to be synced with standby database everyday.so that in case if primary database is in problem we can use standby database in replace of it.

hope it is clear for you.

[Updated on: Sat, 26 July 2008 23:23]

Report message to a moderator

Re: Database Synchronisation [message #336451 is a reply to message #336422]

Sat, 26 July 2008 23:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>if archivelog files are missing, then what would be the solution for this?
You can not recover standby DB, beyond missing archived redo logfile.

Report message to a moderator

Re: Database Synchronisation [message #336454 is a reply to message #336451]

Sun, 27 July 2008 00:34

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

"You can not recover standby DB, beyond missing archived redo logfile."

Please understand my question properly anacedent.

I mean to say this type of incident happens in primary database(missing datafile) which is later to be synchronised with standby db .

[Updated on: Sun, 27 July 2008 00:36]

Report message to a moderator

Re: Database Synchronisation [message #336488 is a reply to message #336422]

Sun, 27 July 2008 18:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I mean to say this type of incident happens in primary database(missing datafile) which is later to be synchronised with standby db.

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

Do NOT describe problems.
Using sqlplus along with CUT & PASTE to show actual errors.

You need to determine a few "details" before proceeding.
1) when did these files go missing?
2) Do you have backups which contain these files?

Why won't you answer these questions?

Report message to a moderator

Previous Topic:	Duplication of db with rman
Next Topic:	Is it possible to recover with only users datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 09:42:03 CDT 2024