OraFAQ Forum: Data Guard » Physical Standby

Home » Server Options » Data Guard » Physical Standby (102040 Solaris 5.9)

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

Physical Standby [message #660538]

Mon, 20 February 2017 09:57

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.

Report message to a moderator

Re: Physical Standby [message #660539 is a reply to message #660538]

Mon, 20 February 2017 10:01

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.

Report message to a moderator

Re: Physical Standby [message #660540 is a reply to message #660539]

Mon, 20 February 2017 10:03

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.

Report message to a moderator

Re: Physical Standby [message #660541 is a reply to message #660540]

Mon, 20 February 2017 10:06

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

Report message to a moderator

Re: Physical Standby [message #660542 is a reply to message #660538]

Mon, 20 February 2017 12:01

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

John Watson
Messages: 8976
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.

Report message to a moderator

Re: Physical Standby [message #660679 is a reply to message #660538]

Fri, 24 February 2017 05:29

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

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Quote:

I have uploaded the script i used.

I don't see it.

Report message to a moderator

Re: Physical Standby [message #660682 is a reply to message #660679]

Fri, 24 February 2017 05:44

hexmanju
Messages: 78
Registered: September 2005
Location: MUMBAI

Member

This is the one.

Attachment: restore.txt
(Size: 19.02KB, Downloaded 4490 times)

Report message to a moderator

Re: Physical Standby [message #660683 is a reply to message #660682]

Fri, 24 February 2017 05:51

John Watson
Messages: 8976
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???

Report message to a moderator

Re: Physical Standby [message #660684 is a reply to message #660683]

Fri, 24 February 2017 06:01

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.

Report message to a moderator

Re: Physical Standby [message #660685 is a reply to message #660684]

Fri, 24 February 2017 06:07

John Watson
Messages: 8976
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.

Report message to a moderator

Re: Physical Standby [message #660687 is a reply to message #660685]

Fri, 24 February 2017 06:20

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 4126 times)

Report message to a moderator

Re: Physical Standby [message #660689 is a reply to message #660687]

Fri, 24 February 2017 08:49

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

I don't see any backup of the archive logs.

Report message to a moderator

Re: Physical Standby [message #660761 is a reply to message #660689]

Sun, 26 February 2017 12:23

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/

Report message to a moderator

Previous Topic:	dropping RAC standby database
Next Topic:	Switch over Primary Database TO Standby Database via SQL COMMAND

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 07:45:56 CDT 2025