Home » RDBMS Server » Backup & Recovery » Database Synchronisation
Database Synchronisation [message #336422] Sat, 26 July 2008 11:52 Go to next message
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
Re: Database Synchronisation [message #336423 is a reply to message #336422] Sat, 26 July 2008 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Database Synchronisation [message #336424 is a reply to message #336422] Sat, 26 July 2008 11:58 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Database Synchronisation [message #336450 is a reply to message #336424] Sat, 26 July 2008 23:20 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Database Synchronisation [message #336454 is a reply to message #336451] Sun, 27 July 2008 00:34 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 25050
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?
Previous Topic: Duplication of db with rman
Next Topic: Is it possible to recover with only users datafile
Goto Forum:
  


Current Time: Sun Dec 11 04:01:03 CST 2016

Total time taken to generate the page: 0.08253 seconds