Re: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine
were to crash: Cloning I would use standards methods as it is much faster:
But once u restored the database you can rename it.
But the steps that I take are
1.Install executables on other machine as same owner and group id as
original database(this is very important)(RESTORE using Netbackup rather
than re-install)
2.Update bp.conf in oracle home and /usr/openv/netbackup/
3. set nb_ora_client=Original client
4.startup taget database nomount
5.connect rman catalog
6.Run scripts
Sam
p.s. scripts I use are
run {
allocate channel ch1 type 'sbt_tape';
restore controlfile;
alter database mount;
}
--select min(scn) from (select max(next_change#)scn from
v$archived_log
group by thread#); -- get the last scn in svrmgrl
run {
set until scn=100075926; allocate channel ch1 type
'sbt_tape';restore database;recover database;
}
--back in svrmgrl
alter database open resetlogs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
winmail.dat
Re: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I
keep getting a file not found error:
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle=EML_L0-EML- 455497207-2852-1, parms=
I'm missing something somewhere???
Origin DB EML on dolphin...
Duplicate DB EMLC on cobra...
rman
RMAN connect target sys/@eml
RMAN connect rcvcat rman/@ds8i
RMAN connect auxiliary /
RMAN the usual file re-definition redo log file descriptions
RMAN run {
RMAN allocate auxiliary channel t type 'sbt_tape' parms
'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1;
5 duplicate target database to EMLC
RMAN }
RTFM no help
Oracle TAR no help
Sun ticket - completely useless (we get our Veritas support from Sun
[ big mistake])
TIA
..JIM...
[EMAIL PROTECTED] 3/6/02 11:53:34 AM
I use RMAN with veritas Netbackup and it is sweet. Recovery is
ridiculously
easy: Even recovering to an alternative host (not as fast as cloning)
is a
doddle and u can apply redo logs to the recovery to bring it up to
current
time: All in all well worth the learning curve to set up
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 9:03 PM
hmmm, the question of the day, a good one! I don't use it now but plan
on
using it. The question is when :)
[EMAIL PROTECTED] 03/06/02 10:48AM
Hi,
I'm in the process of upgrading my database to 9i and I was trying
to
decide whether I wanted to change my backup strategy to use RMAN. Do
most of
you use it? If you use it, what is your opinion of it? If you don't use
it,
why did you decide not to?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALINF
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Roberts
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
winmail.dat
Re: Do you use RMAN? DB clone problem
Hi Lists I have encountered error(ORA-00600: internal error code, arguments arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while running package called 'JC_PR_SPLIT_PROCESS' Error message is listed below . I am using SQL Navigotor to process this package. Any idea or clue for this error. Please give me a soultion for this. * SCRIPT START : Session:prodho8i.world-MECJCPDAT:1 9-Mar-02 11:13:49 am SCRIPT File: UnNamed1 Starting from line number : 1 Processing ... BEGIN * ORA-00600: internal error code, arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 688 ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 306 ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 913 ORA-06512: at line 2 * SCRIPT END : 9-Mar-02 11:16:40 am How do I solve this error Any help is really appreciated. Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). winmail.dat
Re: Do you use RMAN? DB clone problem
Hi Lists I have encountered error(ORA-00600: internal error code, arguments arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while running package called 'JC_PR_SPLIT_PROCESS' Error message is listed below . I am using SQL Navigotor to process this package. Any idea or clue for this error. Please give me a soultion for this. * SCRIPT START : Session:prodho8i.world-MECJCPDAT:1 9-Mar-02 11:13:49 am SCRIPT File: UnNamed1 Starting from line number : 1 Processing ... BEGIN * ORA-00600: internal error code, arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 688 ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 306 ORA-06512: at MECJCPDAT.JC_PR_SPLIT_PROCESS, line 913 ORA-06512: at line 2 * SCRIPT END : 9-Mar-02 11:16:40 am How do I solve this error Any help is really appreciated. Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I
keep getting a file not found error:
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle=EML_L0-EML- 455497207-2852-1, parms=
I'm missing something somewhere???
Origin DB EML on dolphin...
Duplicate DB EMLC on cobra...
rman
RMAN connect target sys/@eml
RMAN connect rcvcat rman/@ds8i
RMAN connect auxiliary /
RMAN the usual file re-definition redo log file descriptions
RMAN run {
RMAN allocate auxiliary channel t type 'sbt_tape' parms
'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1;
5 duplicate target database to EMLC
RMAN }
RTFM no help
Oracle TAR no help
Sun ticket - completely useless (we get our Veritas support from Sun
[ big mistake])
TIA
...JIM...
[EMAIL PROTECTED] 3/6/02 11:53:34 AM
I use RMAN with veritas Netbackup and it is sweet. Recovery is
ridiculously
easy: Even recovering to an alternative host (not as fast as cloning)
is a
doddle and u can apply redo logs to the recovery to bring it up to
current
time: All in all well worth the learning curve to set up
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 9:03 PM
hmmm, the question of the day, a good one! I don't use it now but plan
on
using it. The question is when :)
[EMAIL PROTECTED] 03/06/02 10:48AM
Hi,
I'm in the process of upgrading my database to 9i and I was trying
to
decide whether I wanted to change my backup strategy to use RMAN. Do
most of
you use it? If you use it, what is your opinion of it? If you don't use
it,
why did you decide not to?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carle, William T (Bill), ALINF
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Roberts
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine
were to crash: Cloning I would use standards methods as it is much faster:
But once u restored the database you can rename it.
But the steps that I take are
1.Install executables on other machine as same owner and group id as
original database(this is very important)(RESTORE using Netbackup rather
than re-install)
2.Update bp.conf in oracle home and /usr/openv/netbackup/
3. set nb_ora_client=Original client
4.startup taget database nomount
5.connect rman catalog
6.Run scripts
Sam
p.s. scripts I use are
run {
allocate channel ch1 type 'sbt_tape';
restore controlfile;
alter database mount;
}
--select min(scn) from (select max(next_change#)scn from
v$archived_log
group by thread#); -- get the last scn in svrmgrl
run {
set until scn=100075926; allocate channel ch1 type
'sbt_tape';restore database;recover database;
}
--back in svrmgrl
alter database open resetlogs
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
