Re: Duplicate for standby didn't duplicate all datafiles
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Fri, 13 Feb 2015 18:05:04 -0500
Message-ID: <54DE8320.9000600_at_yahoo.com>
On 02/13/2015 04:23 PM, Sandra Becker wrote:
> Oracle 11.2.0.2
>
> We are trying to create a standby of a 19T database. After 4 days to
> do the restore, it failed on the recovery. Twelve of the datafiles
> were not restored. They contain critical application data, so I need
> to get them in the standby. Question: How do I get those 12 datafiles
> into my standby? Can I do a "restore datafile..." on the standby?
>
> Appreciate any help you can give me.
>
> --
> Sandy
> GHX
Yes you can restore files on the standby. All you need is a control file. You mount the database and restore datafiles, with possible "set newname" commands. Also, if the network link between primary and standby is fast enough and your DB is not a monster, you can try something like this:
duplicate target database for standby using active database nofilenamecheck dorecover;
}
Date: Fri, 13 Feb 2015 18:05:04 -0500
Message-ID: <54DE8320.9000600_at_yahoo.com>
On 02/13/2015 04:23 PM, Sandra Becker wrote:
> Oracle 11.2.0.2
>
> We are trying to create a standby of a 19T database. After 4 days to
> do the restore, it failed on the recovery. Twelve of the datafiles
> were not restored. They contain critical application data, so I need
> to get them in the standby. Question: How do I get those 12 datafiles
> into my standby? Can I do a "restore datafile..." on the standby?
>
> Appreciate any help you can give me.
>
> --
> Sandy
> GHX
Yes you can restore files on the standby. All you need is a control file. You mount the database and restore datafiles, with possible "set newname" commands. Also, if the network link between primary and standby is fast enough and your DB is not a monster, you can try something like this:
run {
allocate channel c0 device type disk; allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type disk;
duplicate target database for standby using active database nofilenamecheck dorecover;
}
The aux. instance needs to be started in nomount mode and you need to be connected to both target instance and the auxiliary instance using password file (SYS/<PASSWD>_at_<TNS>
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 14 2015 - 00:05:04 CET