tag:blogger.com,1999:blog-302298286928742422.post8052439795245911336..comments2024-03-27T22:52:06.600-07:00Comments on #cloud blog: Rman duplicate of database using catalog and tape backup 11gr2 - no target connectionDBAHarrisonhttp://www.blogger.com/profile/16901239165682958859noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-302298286928742422.post-84230009639884113962018-02-04T01:08:20.894-08:002018-02-04T01:08:20.894-08:00Hi,
Did the original backup contain the spfile (i....Hi,<br />Did the original backup contain the spfile (i.e. you added 'including spfile' to the rman command in the backup block?)<br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-87151975555668528732018-02-03T19:26:44.544-08:002018-02-03T19:26:44.544-08:00Hi Rich,
we are getting the following RMAN-05565: ...Hi Rich,<br />we are getting the following RMAN-05565: SPFILE backup created before TO_DATE<br />when performing the following:<br />RMAN> run {<br />DUPLICATE DATABASE TO WPSTRN<br />2> SPFILE<br />3> 4> set control_files='/ora2/oradata/wpstrn/cntrl01.dbf', '/o ra3/oradata/wpstrn/cntrl02.dbf', '/ora2/oradata/wpstrn/cntrl03.dbf'<br /> set audit_file_dest='/ora1/oracle/wpstrn/12.1.0/rdbms/audit'<br />5> 6> set local_listener='WPSTRN_LOCAL'<br />7> set diagnostic_dest='/ora1/oracle/wpstrn/12.1.0/admin/WPSTRN _db5ebsdbtrn'<br />8> set log_archive_dest_1='LOCATION=/ora3/oradata/wpstrn/archiv e'<br />9> set db_file_name_convert='/ora3/oradata/wpsprd','/ora3/orada ta/wpstrn','/ora2/oradata/wpsprd', '/ora2/oradata/wpstrn'<br />10> set log_file_name_convert='/ora3/oradata/wpsprd','/ora3/ora data/wpstrn','/ora2/oradata/wpsprd', '/ora2/oradata/wpstrn'<br />11> until time "TO_DATE('03-FEB-2018 17:20:16','DD-MON-YYYY HH24: MI:SS')" BACKUP LOCATION '/ora2/oradata/full012818/' NOFILENAMECHECK NORESUME;<br />}12><br /><br />Starting Duplicate Db at 03-FEB-2018 20:45:39<br />RMAN-00571: ===========================================================<br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />RMAN-00571: ===========================================================<br />RMAN-03002: failure of Duplicate Db command at 02/03/2018 20:45:39<br />RMAN-05501: aborting duplication of target database<br />RMAN-05565: SPFILE backup created before TO_DATE('03-FEB-2018 17:20:16','DD-MON- YYYY HH24:MI:SS') not found in /ora2/oradata/full012818/<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-58398748750296139972013-05-27T07:45:09.432-07:002013-05-27T07:45:09.432-07:00Blake +1! thanks mate! I wish you a great fish on ...Blake +1! thanks mate! I wish you a great fish on your next trip :)<br /><br />export NLS_LANG=american was enough to overcome the silly error!Jannoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-79648002165801032932013-05-23T00:54:38.425-07:002013-05-23T00:54:38.425-07:00Cheers Blake - it does explicitly say to set NLS_L...Cheers Blake - it does explicitly say to set NLS_LANG in the rman docs but i never really thought it was used - lke you say maybe a bug (or a feature....)<br /><br />http://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmrecov.htm<br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-89086490101722051432013-05-22T12:51:01.930-07:002013-05-22T12:51:01.930-07:00Set both NLS_LANG and NLS_DATE_FORMAT. NLS_LANG is...Set both NLS_LANG and NLS_DATE_FORMAT. NLS_LANG is not used, but it is required. I think it is a bug.<br />I export to the environment before running my rman script:<br />export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'<br />export NLS_LANG=AMERICAN.WE8ISO8859P1<br /><br />Then in the rman run block:<br />set until time = '2013-05-01 08:01:01';<br /><br />BlakeAnonymoushttps://www.blogger.com/profile/10958920836547914005noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-81559122283666527542013-05-22T04:54:01.911-07:002013-05-22T04:54:01.911-07:00Hi Jan,
Have you tried:
export NLS_DATE_FORMAT=&#...Hi Jan,<br />Have you tried:<br /><br />export NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'<br /><br />run {<br />set dbid=387769350<br />set until '01-03-2013 17:00:00';<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br /><br />If that doesnt work try this inside rman before you execute the run block:<br /><br />sql "alter session set nls_date_format = 'DD-MM-YYYY:HH24:MI:SS'";<br />run {<br />set dbid=387769350<br />set until '01-03-2013 17:00:00';<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br /><br />Regards,<br />Rich<br /><br />DBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-27058547387730041862013-05-22T03:21:15.503-07:002013-05-22T03:21:15.503-07:00I did some testing already, but it's still fai...I did some testing already, but it's still failing - please see these. Thanks Jan<br /><br />---- TESTING:<br /><br /><br />export NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'<br />set |grep NLS<br /><br />NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI'<br />_='NLS_DATE_FORMAT=DD-MM-YYYY HH24:MI:SS'<br /><br />run {<br />set until time= "to_date('21-05-2013 03:37:15','DD-MM-YYYY HH24:MI:SS')";<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />>>> ORA-00907<br /><br />run {<br />set until time "to_date('21-05-2013 03:37:15','DD-MM-YYYY HH24:MI:SS')";<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />>>> ORA-00907<br /><br />RMAN> run {<br />set until time=to_date('21-05-2013 03:37:15');<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />2><br />RMAN-00571: ===========================================================<br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />RMAN-00571: ===========================================================<br />RMAN-00558: error encountered while parsing input commands<br />RMAN-01009: syntax error: found "identifier": expecting one of: "double-quoted-string, single-quoted-string"<br />RMAN-01008: the bad identifier was: to_date<br />RMAN-01007: at line 3 column 16 file: standard input<br /><br />>>> but starts full recovery until the LAST backup! we need point in time recovery!<br /><br />---------------------<br /><br />unset NLS_DATE_FORMAT<br />set |grep NLS<br /><br /><br />run {<br />set dbid=387769350<br />set until time= "to_date('01/03/2013 17:00:00','dd/mm/yyyy hh24:mi:ss')";<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br /><br />-----sql "alter session set nls_date_format<br />run {<br />set dbid=387769350<br />sql "alter session set nls_date_format = 'DD-MM-YYYY HH24:MI:SS'";<br />set until time= "to_date('21-05-2013 03:37:15','DD-MM-YYYY HH24:MI:SS')";<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />RMAN-03009: failure of sql command on unknown channel at 05/22/2013 01:35:08<br />RMAN-06171: not connected to target database<br /><br />------------ SET UNTIL SCN +1<br />run {<br />set dbid=387769350<br />SET UNTIL SCN 8435873;<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />RMAN-06136: ORACLE error from auxiliary database: ORA-01194: <br /><br /><br />set parallelmediarestore off;<br />RMAN-06136Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-44189456923876968322013-05-22T00:18:20.647-07:002013-05-22T00:18:20.647-07:00Hi,
I think the porblem might be you have an = sig...Hi,<br />I think the porblem might be you have an = sign where you don;t need it - can you remove the one in the set until time line?<br /><br />So change<br /><br />set until time= "to_date('21/05/2013 03:37:00','dd/mm/yyyy hh24:mi:ss')";<br /><br />to<br /><br />set until time "to_date('21/05/2013 03:37:00','dd/mm/yyyy hh24:mi:ss')";<br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-44182468887564284252013-05-21T16:57:08.384-07:002013-05-21T16:57:08.384-07:00Hi Rich, thanks for great article..any idea with t...Hi Rich, thanks for great article..any idea with this one ?<br />RMAN> run {<br />set until time= "to_date('21/05/2013 03:37:00','dd/mm/yyyy hh24:mi:ss')";<br />DUPLICATE TARGET DATABASE TO "CLONE"<br />BACKUP LOCATION '/u01/data/gdbtest2/'<br />PFILE=/u01/app/product/11.2.0/db_1/dbs/initclone.ora<br />NOFILENAMECHECK;<br />}<br />2> 3> 4> 5> 6> 7><br />executing command: SET until clause<br /><br />Starting Duplicate Db at 22-05-2013 00:48<br />allocated channel: ORA_AUX_SBT_TAPE_1<br />channel ORA_AUX_SBT_TAPE_1: SID=686 device type=SBT_TAPE<br />channel ORA_AUX_SBT_TAPE_1: Data Protection for Oracle: version 6.3.0.0<br />allocated channel: ORA_AUX_SBT_TAPE_2<br />channel ORA_AUX_SBT_TAPE_2: SID=800 device type=SBT_TAPE<br />channel ORA_AUX_SBT_TAPE_2: Data Protection for Oracle: version 6.3.0.0<br />allocated channel: ORA_AUX_DISK_1<br />channel ORA_AUX_DISK_1: SID=914 device type=DISK<br />allocated channel: ORA_AUX_DISK_2<br />channel ORA_AUX_DISK_2: SID=1028 device type=DISK<br />RMAN-00571: ===========================================================<br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />RMAN-00571: ===========================================================<br />RMAN-03002: failure of Duplicate Db command at 05/22/2013 00:48:04<br />RMAN-05501: aborting duplication of target database<br />RMAN-06136: ORACLE error from auxiliary database: ORA-00907Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-10631975384817199452013-03-23T04:56:43.729-07:002013-03-23T04:56:43.729-07:00Hi Rich,
I have everything resolved, I forgot to p...Hi Rich,<br />I have everything resolved, I forgot to put in the H:\Backup folder controlfile backup separately. First in the folder was only BACRUPSET and ARCHIVELOG, I thought backap of controlfile take from backupset, and it does not find the folder, so I decided to put it in a as separate file in the folder. After that, everything works.<br />Thank you, very much !<br />Regards, MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-8733713154366665612013-03-22T10:04:05.832-07:002013-03-22T10:04:05.832-07:00Hi Mike,
What backup command did you use in the fi...Hi Mike,<br />What backup command did you use in the first place to create the backup in H:\ ?<br /><br />How does archive log 1732 relate in time to that backup you took - is it afterwards - i.e. is the duplicate trying to roll forward to current time?<br /><br />Did you give the backup a tag - perhaps we can use that to restore to?<br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-17648764550503660042013-03-21T04:32:24.186-07:002013-03-21T04:32:24.186-07:00Hi Rich,
I tried without it but got another error...Hi Rich,<br /><br />I tried without it but got another error:<br /><br />RMAN-06054: media recovery requesting unknown archived log for thread 1 with seq<br />uence 1732 and starting SCN of 122054424<br /><br />Thanks<br />Regards, Mike<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-54945820404969419422013-03-19T12:00:58.899-07:002013-03-19T12:00:58.899-07:00Hi Mike,
i still think the until-time is the probl...Hi Mike,<br />i still think the until-time is the problem and i don't think it is necessary?<br /><br />have you tried without it?<br /><br />When you create the backup in the first place how are you doing that - is it just a single database backup located there?<br /><br />so something like<br /><br />backup database include archivelog format 'H:\backup\';<br /><br />so there is only actually one backup there and you can only go to one point in time anyway?<br /><br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-2064375983775861952013-03-19T03:19:04.181-07:002013-03-19T03:19:04.181-07:00Hi Rich,
I send another variant:
C:\>rman auxi...Hi Rich,<br />I send another variant:<br /><br />C:\>rman auxiliary /<br /><br />Recovery Manager: Release 11.2.0.2.0 - Production on Tue Mar 19 14:52:09 2013<br /><br />Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.<br /><br />connected to auxiliary database: TESTDB (not mounted)<br /><br />RMAN> duplicate database to TESTDB<br />2> until time "to_date('03/15/2013 11:00:00', 'mm/dd/yyyy hh24:mi:ss')"<br />3> spfile<br />4> set control_files='G:\oracle\oradata\ectest\control01.ctl','G:\oracle\oradata\ectest\control02.ctl'<br />5> set db_file_name_convert='H:\ORACLE\ORADATA\PRODDB\','G:\oracle\oradata\testdb\'<br />6> set log_file_name_convert='H:\ORACLE\ORADATA\PRODDB\','G:\oracle\oradata\testdb\'<br />7> backup location 'E:\backup'<br />8> nofilenamecheck<br />9> ;<br /><br />Starting Duplicate Db at 19-MAR-13<br />RMAN-00571: ===========================================================<br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />RMAN-00571: ===========================================================<br />RMAN-03002: failure of Duplicate Db command at 03/19/2013 14:57:54<br />RMAN-05501: aborting duplication of target database<br />RMAN-05565: SPFILE backup created before to_date('03/15/2013 11:00:00', 'mm/dd/yyyy hh24:mi:ss') not found in 'E:\backup<br /><br />RMAN><br /><br />thanks in advance<br />Regards, MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-5603318401831506472013-03-19T02:17:34.482-07:002013-03-19T02:17:34.482-07:00Hi Rich,
Thanks for the quick response.
1)'un...Hi Rich,<br /><br />Thanks for the quick response.<br />1)'until_time' my understanding is that it is possible to restore some of backup to the specified time. Or am I wrong?<br />2)I think that the control file is included in backupset<br />3)a quote trims when inserting<br /><br />I used another option, but also does not work:<br /><br />RMAN> duplicate database to testdb<br />2> until time "to_date('03/15/2013 11:00:00', 'mm/dd/yyyy hh24:mi:ss')"<br />3> spfile<br />4> set control_files='E:\backup\CONTROL01.CTL'<br />5> set db_file_name_convert='F:\ORACLE\ORADATA\PRODDB\','G:\oracle\oradata\testdb\'<br />6> set log_file_name_convert='F:\ORACLE\ORADATA\PRODDB\','G:\oracle\oradata\testdb\'<br />7> backup location 'E:\backup'<br />8> nofilenamecheck<br />9> ;<br /><br />Another error appears:<br />RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause<br />Why TARGET ? This Backup-based location, without TARGET and CATALOG.<br /><br />Regards, Mike<br /><br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-26030053998607091912013-03-18T03:36:35.665-07:002013-03-18T03:36:35.665-07:00Hi Mike,
I've never actually tried it without ...Hi Mike,<br />I've never actually tried it without the catalog connection but other posts I've seen suggest that it should work.<br /><br />Two things to try/check:<br /><br />1) why are you using until_time? - is the backup not from a certain point in time anyway - is this step needed - it might be what is confusing oracle?<br />2) is there a controlfile backup included in the h:\backup location?<br />3) is there a typo in the h:\backup path - a missing quote ? or is that just an cut and paste error?<br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-67739687444764718682013-03-18T03:23:23.335-07:002013-03-18T03:23:23.335-07:00HI Rich,
I need to restore the oracle database 11...HI Rich,<br /><br />I need to restore the oracle database 11gR2 to a new server with a new name (Windows platform).<br />I try use backup-based location without Target connection and without Catalog connection.<br /><br />C:\> rman auxiliary SYS@testdb<br /><br />Recovery Manager: Release 11.2.0.3.0 - Production on Fri Feb 22 20:01:43 2013<br />Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.<br />connected to auxiliary database: ectest (not mounted)<br /><br />RMAN> duplicate database to testdb<br /> until time "to_date('03/15/2013 11:00:00', 'mm/dd/yyyy<br />hh24:mi:ss')"<br /> backup location 'H:\backup<br /> nofilenamecheck;<br /><br />And I get the following similar error:<br />RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted<br /><br />Please help me !<br /><br />Regards, MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-74838582198646965102013-03-12T09:52:27.883-07:002013-03-12T09:52:27.883-07:00Hi,
So you have a backupset on disk/tape somewhere...Hi,<br />So you have a backupset on disk/tape somewhere and you want to restore the database from that directly?<br /><br />Regards,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-75627908601410482712013-03-12T08:58:41.214-07:002013-03-12T08:58:41.214-07:00Yes, I was talking about no connection to either c...Yes, I was talking about no connection to either catalog database or target database.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-22137642637362510302013-03-06T23:36:38.803-08:002013-03-06T23:36:38.803-08:00Hi,
If you are happy to connect to the target data...Hi,<br />If you are happy to connect to the target database you can just use duplicate from active database since 11.2.<br /><br />Or are you talking about using duplicate with no target connection and no catalog connection?<br /><br />Regards,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-4139115815097480392013-03-06T12:28:36.144-08:002013-03-06T12:28:36.144-08:00Is there a way we can do it without even connectin...Is there a way we can do it without even connecting to catalog database?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-15552756715979233022011-11-10T14:29:18.590-08:002011-11-10T14:29:18.590-08:00You rock Rich!!!.
Thanks a lot. I am able to rest...You rock Rich!!!.<br /><br />Thanks a lot. I am able to restore successfully.<br /><br />Thanks<br />PadhuAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-10960173752690921152011-11-10T00:05:03.036-08:002011-11-10T00:05:03.036-08:00Hi Padhu,
Ok I think i can see what the problem is...Hi Padhu,<br />Ok I think i can see what the problem is now. Try replacing the configure command with the allocate command.<br /><br />Configure will try and save to the control file - which you don't have.<br /><br />rman catalog rmanadmin/xxxxxx@rmancatdb auxiliary /<br />set parallelmediarestore off;<br />run {<br />set dbid 1582918119;<br />set until time "to_date('Nov 07 2011 22:00:00','Mon DD YYYY HH24:MI:SS')";<br />ALLOCATE auxiliary CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=SNA_CRED_MSZ_UNX-ORACLE-HOT-WELLSDB_ANY,NB_ORA_SERV=pisgsna01bmst01.firstamdata.net,NB_ORA_CLIENT=credprboradb9.infosolco.com,NB_ORA_SCHED=weekly)';<br />ALLOCATE auxiliary CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=SNA_CRED_MSZ_UNX-ORACLE-HOT-WELLSDB_ANY,NB_ORA_SERV=pisgsna01bmst01.firstamdata.net,NB_ORA_CLIENT=credprboradb9.infosolco.com,NB_ORA_SCHED=weekly)';<br /><br />duplicate database 'WELLSDB' to 'welsrstr' ;<br />} <br /><br />Cheers,<br />RichDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-85982378517200869722011-11-09T11:31:24.689-08:002011-11-09T11:31:24.689-08:00Thanks Rich for responding.
Per your suggestion, ...Thanks Rich for responding.<br /><br />Per your suggestion, created a spfile and started the auxiliary database in nomount mode and ran the rman script but still get the same error:<br /><br />RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted<br /><br />Please advise.<br /><br />Thanks<br />PadhuAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-302298286928742422.post-87152919687482754512011-11-09T03:40:18.569-08:002011-11-09T03:40:18.569-08:00Hi,
You need to make sure your auxiliary databases...Hi,<br />You need to make sure your auxiliary databases is started up in nomount mode (i.e. you need an spfile) in place so that rman can connect to it.<br /><br />So basically:<br /><br />create a text pfile )in vi/notepad etc)<br /><br />startup nomount<br /><br />create spfile from pfile;<br /><br />shutdown;<br /><br />startup nomount<br /><br />then run the rman script<br /><br />Note - you must use an spfile on the auxiliary or you weill have problemsDBAHarrisonhttps://www.blogger.com/profile/16901239165682958859noreply@blogger.com