Home » Server Options » Data Guard » Physical Standby (102040 Solaris 5.9)
Physical Standby [message #660538] Mon, 20 February 2017 09:57 Go to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Need to setup Physical standby between source and target on 10240 when the file system layout is not the same.

Can you please assist or point to a document
We will use RMAN restore from Tape.
File system layout wont be same.
Re: Physical Standby [message #660539 is a reply to message #660538] Mon, 20 February 2017 10:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suggest you make file system look the same by using soft links; since this will simplify the task at hand.
Re: Physical Standby [message #660540 is a reply to message #660539] Mon, 20 February 2017 10:03 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
I plan to use RMAN restore and set newname to map source and target filenames.Still i need to know what all steps i need to do to set this up apart from this one.
Re: Physical Standby [message #660541 is a reply to message #660540] Mon, 20 February 2017 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Unwilling or incapable to use GOOGLE yourself?

https://www.google.com/webhp?hl=en&tab=ww#hl=en&q=oracle+rman+restore
Re: Physical Standby [message #660542 is a reply to message #660538] Mon, 20 February 2017 12:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Backup and Recovery Advanced User's Guide, section Physical Standby Database Creation with RMAN
Data Guard Concepts and Administration, chapter 3 Creating a Physical Standby Database
Data Guard Concepts and Administration, Annex F Creating a Standby Database with Recovery Manager

[Updated on: Mon, 20 February 2017 12:02]

Report message to a moderator

Re: Physical Standby [message #660543 is a reply to message #660538] Mon, 20 February 2017 14:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I always use Oracle Managed Files and Fast Recovery Area. Then you can just trust Uncle Oracle to manage your directories and file names.
Re: Physical Standby [message #660679 is a reply to message #660538] Fri, 24 February 2017 05:29 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
I created a Physical Standby using the Restore Datafile option.I had to do this as my filesystem layout is entirely diff compared to Source.

So i followed the metalink ID 469493.1.

I have uploaded the script i used.
As step 5 of Metalink suggested after doing archive log recovery the recovery succeeded but it also gave the message File 1 was not restored from a suffficiently old backup.By that time Primary had moved a lot furthur.

So i decided to take an incremental backup and sync up the standby.

I took the current SCN of the standby and took a backup from this current SCN against the primary database.
I took it to Disk
I catalogued it in standby and did a recover database noredo;

It simply did nothing and came back saying

RMAN> recover database noredo;

Starting recover at 24-FEB-2017 04:35:04
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=4380 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=4377 devtype=DISK
Finished recover at 24-FEB-2017 04:35:17

I thought it will apply the entire backup to the standby and bring it to a certain SCN.

I dont know why this catalogued backup is not working to apply or rollforward in the standby.

Only after all this i wished to enable shipping from Primary.

Pls advise.

[Updated on: Fri, 24 February 2017 05:30]

Report message to a moderator

Re: Physical Standby [message #660681 is a reply to message #660679] Fri, 24 February 2017 05:35 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I have uploaded the script i used.
I don't see it.
Re: Physical Standby [message #660682 is a reply to message #660679] Fri, 24 February 2017 05:44 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
This is the one.
  • Attachment: restore.txt
    (Size: 19.02KB, Downloaded 3580 times)
Re: Physical Standby [message #660683 is a reply to message #660682] Fri, 24 February 2017 05:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You are doing things the hard way, aren't you?

How did you make the backup? What happened when you ran the script?? What happened next???
Re: Physical Standby [message #660684 is a reply to message #660683] Fri, 24 February 2017 06:01 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Yes the hard-way due to 2 reasons

1)The team wants collapsed number of mount points.
2)There are duplicates in Source and i cant get a downtime at all.So i have to work around the duplicate file names .
I have only 2 mount points for restore of the entire DB.Both of them are really spacious.But due to dups i have been careful crafting my set newname.

Backup was done using RMAN directly to SBT_TAPE(TSM)
Restore was done from TSM into the standby host.(Which is different from primary)

When i ran the restore script in standby it took some 24 hrs to restore all datafiles from TSM .
Thereafter i did a list backup of archivelog all;
Then i applied recovery till +1 of the list backup archive log.
Recovery succceed but gave the file 1 not restored from sufficiently old backup.(Which i ignored if you see the Metalink note)
I saw the primary has moved a lot furthur when i compared SCN.
So i took an incremental backup from the primary database using SCN of Standby into DISK.
Copied the backup pieces to standby host
Catalogued them-It was successful
Tried to do a recover database noredo; and it simply said finish recover and did not do any recovery.

I have been trying to get a SCN near to the Primary.
Once they get close enough i wish to enable log shipping from primary and enable managed recovery for standby.
At that point if i have just few archives i plan to register them one by one and bring it up to sync with primary.
Re: Physical Standby [message #660685 is a reply to message #660684] Fri, 24 February 2017 06:07 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So what were your backups commands?

As for "the hard way", I would use OMF. Much simpler and more reliable. Debugging a script as long as yours would be awful.
Re: Physical Standby [message #660687 is a reply to message #660685] Fri, 24 February 2017 06:20 Go to previous messageGo to next message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
I understand..I will try other ways now as its been long enough i have been struggling with this.
Pls find the backup log.
  • Attachment: backup.txt
    (Size: 126.30KB, Downloaded 3246 times)
Re: Physical Standby [message #660689 is a reply to message #660687] Fri, 24 February 2017 08:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I don't see any backup of the archive logs.
Re: Physical Standby [message #660761 is a reply to message #660689] Sun, 26 February 2017 12:23 Go to previous message
hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI
Member
Backup of archive logs happens via a different Script..I have been able to fix my issue.

I took the lowest of the SCN among v$datafile_header ,v$database and v$datafile and took and incremental backup from the lowest SCN point.Then restored and recovered and it worked.

This link helped

http://thegeekdiary.com/how-to-roll-forward-a-standby-database-using-rman-incremental-backup-in-11g/
Previous Topic: dropping RAC standby database
Next Topic: Switch over Primary Database TO Standby Database via SQL COMMAND
Goto Forum:
  


Current Time: Thu Mar 28 14:33:17 CDT 2024