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.
|
|
|
|
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.
|
|
|
|
|
Re: Physical Standby [message #660543 is a reply to message #660538] |
Mon, 20 February 2017 14:32 |
John Watson
Messages: 8962 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 |
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 #660683 is a reply to message #660682] |
Fri, 24 February 2017 05:51 |
John Watson
Messages: 8962 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 |
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 |
John Watson
Messages: 8962 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.
|
|
|
|
|
|