tag:blogger.com,1999:blog-4096575.post1259428124964364016..comments2024-03-19T03:20:26.726-04:00Comments on The Arup Nanda Blog: Standby Database Using RMANArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-4096575.post-34834620853783075892023-11-14T12:13:05.885-05:002023-11-14T12:13:05.885-05:00Good way to do Databases with RMAN since it is an ...Good way to do Databases with RMAN since it is an Oracle tool designed to backup, restore and recover databases. It is especially useful for managing recovery in Oracle database environments.<br /><br /><br /><br />_________________________________<br />I work with <a href="https://factored.ai/transformer-based-language-models/" rel="nofollow">roberta model ai</a>Edwardhttps://www.blogger.com/profile/16207897155711243557noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-31833573014136041812020-08-07T19:48:25.192-04:002020-08-07T19:48:25.192-04:00I can't believe I can earn money weekly from t...I can't believe I can earn money weekly from trading , this is amazing , and all this is from the effort of a company called skylink technology whom I met online and help me out in trading and gave me good tips about trading physiology... indeed skylink technology is a bitcoin/binary forex experts and company and I won't stop thanking them and sharing my testimony until am fully satisfied...... Interested traders should free free to contact mail: skylinktechnes@yahoo.com or whatsapp/telegram: +1(213)785-1553 Anonymoushttps://www.blogger.com/profile/01804304680311897628noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-79466249864596230242020-07-15T01:48:05.734-04:002020-07-15T01:48:05.734-04:00best induction cooktop dulicate command.this is ju...<a href="https://yourhomeguide.in/best-induction-cooktops/" rel="nofollow">best induction cooktop</a> dulicate command.this is just my assumption.because standby is in differnt<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-11785773239112819082013-01-09T06:41:11.478-05:002013-01-09T06:41:11.478-05:00hai specify nofilenamecheck at the end of dulicate...hai specify nofilenamecheck at the end of dulicate command.this is just my assumption.because standby is in differnt locationLearn oracle from Oraclehttps://www.blogger.com/profile/15202248452556270692noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-53859909567219253232012-06-06T06:31:30.538-04:002012-06-06T06:31:30.538-04:00Good job now i m doing work on oracle and this hel...Good job now i m doing work on oracle and this help me in different steps when i face any issue i visit this blog and my confusion release.thank keep it up.Benjamin Bellhttp://www.diskdoctors.com/recover-files.htmlnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-78903802522199296672010-07-20T02:32:34.268-04:002010-07-20T02:32:34.268-04:00Hi ,
I am using the enterprise edition and i have ...Hi ,<br />I am using the enterprise edition and i have been able to create managed standby normally for my other non-rac databases.this is only for this case,i am getting the error.<br />i suspect this might be because i am using the rac db as a catalog too.vinay singhhttps://www.blogger.com/profile/15499708711139847227noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-90892088961224299762010-07-16T13:57:36.685-04:002010-07-16T13:57:36.685-04:00As far as I know, you have to have Enterprise Edit...As far as I know, you have to have Enterprise Edition for managed Standby Database. Otherwise, you need to manually copy archivelogs and apply them.Unknownhttps://www.blogger.com/profile/16654847849064502836noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-34229320986127382842010-07-01T11:11:23.402-04:002010-07-01T11:11:23.402-04:00looks nice. but have you ever heard about another ...looks nice. but have you ever heard about another way of <a href="http://www.recoverytoolbox.com/repair_my_open_database_and_restart_microsoft_access.html" rel="nofollow">repair access 2007 database</a>, provided by appropriate data recovery services?Unknownhttps://www.blogger.com/profile/05877384614316336123noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-52483790941986588162010-02-16T02:25:02.746-05:002010-02-16T02:25:02.746-05:00Hi Arup,
sorry but i didn't exactly understood...Hi Arup,<br />sorry but i didn't exactly understood the T1 -T2 thing.Do I need to take the backup of archivelogs after taking the database<br />database backup? I tried that too.<br /><br />I am trying to create a single node standby(on filesystem) for a 2 node cluster database(which is using ASM).<br />Below are the steps i am doing,but I am getting the same <br /><br />RMAN-06024: no backup or copy of the control file found to restore error.<br /><br />DB version is 11.1.0.6 .Host is unbreakable Linux 32-bit.<br />steps:<br />AT primary<br />export ORACLE_SID=racdb1<br />rman target / catalog rman@racdb (racdb is my rac database and catalog too)<br />backup current controlfile for standby format '/oracle/dumpdr/racdb_stby_01.ctl';<br />backup database format '/oracle/dumpdr/racdb_%s' plus archive log format '/oracle/dumpdr/arch_%s';<br />exit<br /><br />cd /oracle/dumpdr<br />scp * oracle@rac3:/oracle/dumpdr/ <br /><br />rman target / catalog rman@racdb auxiliary sys@racdr (racdr is tns for standby db)<br />duplicate target for standby nofilenamecheck dorecover;<br />(Tried allocating auxiliary channel manually too. )<br />--------------------------<br /><br />AT standby:<br /><br />Created the pfile and started the database in nomount state.<br /><br /><br />I am using db_file_name_convert and log_file_name_convert in standby pfile.<br />Am i missing something? Please help.<br /><br />Regards,<br />Vinay Singhvinay singhhttps://www.blogger.com/profile/15499708711139847227noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-19883476878750153162010-02-16T02:21:08.315-05:002010-02-16T02:21:08.315-05:00This comment has been removed by the author.vinay singhhttps://www.blogger.com/profile/15499708711139847227noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-51325390089745215442010-02-14T03:22:36.367-05:002010-02-14T03:22:36.367-05:00Hi Arup,
I have even created standby database wit...Hi Arup,<br /><br />I have even created standby database with same steps, but upon creation subsequent operation are not being carried out successfully.<br /><br />e.g. Log switching, Archive shipping, managed recovery process starting.<br /><br />Any corrective measures for same??<br /><br />Awaiting kindly response for same.<br /><br />Thanks & Regds,<br />Ninad shahUnknownhttps://www.blogger.com/profile/03632141816331603047noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-59964595680484076472010-02-14T03:19:12.562-05:002010-02-14T03:19:12.562-05:00Hi Sreejith,
This is ninad here. Attempt to creat...Hi Sreejith,<br /><br />This is ninad here. Attempt to create standby database might have gone failed because the path may not be accessible by standby server. So, possible remedies:<br /><br />1. Create backup on shared disk accessible by both servers.<br /><br />2. Copy backup to standby server on same directory structure as on primary and catalog that backup in RMAN.<br /><br />thanks,<br />Ninad ShahUnknownhttps://www.blogger.com/profile/03632141816331603047noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-37572614034182181992010-02-14T03:16:48.385-05:002010-02-14T03:16:48.385-05:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/03632141816331603047noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-49931101233829453922009-04-20T07:53:00.000-04:002009-04-20T07:53:00.000-04:00Hi Arup,
I could fix the error by copying the Back...Hi Arup,<br />I could fix the error by copying the Backup files to Standby server.<br />I was under the assumption that the file copy and restore will be handled by RMAN as I am connecting to target database, the catalog and the auxiliary database from RMAN prompt.I could understand that only the restore is handled by RMAN and not the Copy.<br />Thank you very much for the feedback.<br />SreejithSreejithnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-12683473959475611822009-04-17T11:58:00.000-04:002009-04-17T11:58:00.000-04:00Sreejith,
Your error message is:
ORA-19505: fail...Sreejith,<br /><br />Your error message is:<br /><br />ORA-19505: failed to identify file "/backups/oracle/TEST/TEST_1_684413087"<br /><br />This indicates that the backup copies (and archived logs, perhaps as well) have not been copied to the standby server. I don't see in your procedure where you peform that task. Thagt may be the error.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-50292405650940045442009-04-17T05:54:00.000-04:002009-04-17T05:54:00.000-04:00Hi Arup,
As part of doing a dataguard creation fro...Hi Arup,<br />As part of doing a dataguard creation from RMAN backup without shutting down the production backup,I am doing a testing with a database named - TEST. The proposed standby database name is TESTSBY which resides in another server with DIFFERENT directory structure.<br />I am seeing similar errors as you mentioned in the blog.Can you please help me out on this ?<br />Here is the steps that I followed and the error.<br /><br />Step 1: Take an RMAN backup of the TEST database.<br />rman target SYS/sree123@TEST CATALOG rman/password@rman<br />RMAN> backup database plus archivelog;<br /><br />RMAN> backup database plus archivelog;<br />Step 2: create a standby controlfile.<br /><br />RMAN> backup current controlfile for standby;<br /><br />Starting backup at 17-APR-09<br />using channel ORA_DISK_1<br />channel ORA_DISK_1: starting full datafile backupset<br />channel ORA_DISK_1: specifying datafile(s) in backupset<br />including standby control file in backupset<br />channel ORA_DISK_1: starting piece 1 at 17-APR-09<br />channel ORA_DISK_1: finished piece 1 at 17-APR-09<br />piece handle=/backups/oracle/TEST/TEST_1_684413087 tag=TAG20090417T104447 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02<br />Finished backup at 17-APR-09<br /><br /><br />RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';<br /><br />RMAN> BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES;<br />Starting backup at 17-APR-09<br />current log archived<br />using channel ORA_DISK_1<br />skipping archive log file /oracle/archive_logs/TEST/1_75_684327646.dbf; already backed up 1 time(s)<br />skipping archive log file /oracle/archive_logs/TEST/1_76_684327646.dbf; already backed up 1 time(s)<br />skipping archive log file /oracle/archive_logs/TEST/1_77_684327646.dbf; already backed up 1 time(s)<br />skipping archive log file /oracle/archive_logs/TEST/1_78_684327646.dbf; already backed up 1 time(s)<br />channel ORA_DISK_1: starting archive log backupset<br />channel ORA_DISK_1: specifying archive log(s) in backup set<br />input archive log thread=1 sequence=79 recid=79 stamp=684413147<br />input archive log thread=1 sequence=80 recid=80 stamp=684413158<br />channel ORA_DISK_1: starting piece 1 at 17-APR-09<br />channel ORA_DISK_1: finished piece 1 at 17-APR-09<br />piece handle=/backups/oracle/TEST/TEST_1_684413160 tag=TAG20090417T104600 comment=NONE<br />channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02<br />Finished backup at 17-APR-09<br /><br />Step 3: Perform a few log switches in the Primary and record the last log sequence number.<br /><br />SQL> alter system switch logfile;<br />SQL> alter system switch logfile;<br /><br />Step 4: Build standby database directory structures in the destination server.<br /><br />mkdir /oracle/oradata/TESTSBY<br />mkdir /logs/oracle/TESTSBY<br />mkdir /logs/oracle/TESTSBY/udump<br />mkdir /logs/oracle/TESTSBY/bdump<br />mkdir /logs/oracle/TESTSBY/cdump<br />mkdir /oracle/archive_logs/TESTSBY<br /><br />Step 5: Create pfile from spfile in TEST and transfer the pfile to destination server.<br /><br />$ . oraenv<br />ORACLE_SID = [WEBCTLVE] ? TESTSBY<br />ORACLE_HOME = [/oracle] ? /oracle/10g<br />$ cd $ORACLE_HOME/dbs<br />$ scp oracle@diver:/oracle/10g/dbs/initTEST.ora .<br /><br /><br />Make all necessary changes to the pfile for standby database.<br /><br />background_dump_dest='/logs/oracle/TESTSBY/bdump'<br />control_files='/oracle/oradata/TESTSBY/ctrl_01.ctl','/oracle/oradata/TESTSBY/ctrl_02.ctl'<br />core_dump_dest='/logs/oracle/TESTSBY/cdump'<br />DB_UNIQUE_NAME= TESTSBY<br />db_name='TEST' no change for this parameter<br />instance_name='TESTSBY'<br /><br />#log_archive_dest_1='' comment this<br />#log_archive_dest='/oracle/archive_logs/TEST' comment this<br /><br />log_archive_format='%t_%s_%r.dbf' no change for this parameter<br /><br />log_archive_dest_2='SERVICE=TEST VALID_FOR=(ONLINE_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=TEST'<br /><br />log_archive_dest_state_2='DEFER'<br />log_archive_dest_1='LOCATION=/oracle/archive_logs/TESTSBY '<br />remote_archive_enable='true'<br />fal_server='TEST'<br />fal_client='TESTSBY'<br />log_file_name_convert=('/oracle/oradata/TEST/', '/oracle/oradata/TESTSBY/')<br />db_file_name_convert=('/oracle/oradata/TEST/', '/oracle/oradata/TESTSBY/')<br /><br /><br />Step 6: Configure network files.<br /><br />Listener.ora in standby server has to be updated as shown below:<br /><br /> (SID_DESC =<br /> (GLOBAL_DBNAME = TESTSBY)<br /> (ORACLE_HOME = /oracle/10g)<br /> (SID_NAME = TESTSBY)<br /> )<br /><br />tnsnames.ora on primary node should have an entry like this:<br /><br />TESTSBY =<br /> (DESCRIPTION =<br /> (ADDRESS_LIST =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.uk)(PORT = 1521))<br /> )<br /> (CONNECT_DATA =<br /> (SERVICE_NAME = TESTSBY)<br /> )<br /> )<br /><br />LSNRCTL>RELOAD<br /><br />Step 6: Create the password file for standby database.<br />cd $ORACLE_HOME/dbs<br />orapwd file=orapwTESTSBY password=sree123 entries=10<br /><br />Step 7: Startup the standby instance in NOMOUNT stage.<br /><br /><br />sqlplus “/ as sysdba”<br />SQL> startup nomount<br /><br />$ sqlplus "/ as sysdba"<br /><br />SQL*Plus: Release 10.2.0.3.0 - Production on Thu Apr 16 14:52:12 2009<br /><br />Copyright (c) 1982, 2006, Oracle. All Rights Reserved.<br /><br />Connected to an idle instance.<br /><br />SQL> startup nomount<br />ORA-32004: obsolete and/or deprecated parameter(s) specified<br />ORACLE instance started.<br /><br />Total System Global Area 188743680 bytes<br />Fixed Size 2028784 bytes<br />Variable Size 100666128 bytes<br />Database Buffers 79691776 bytes<br />Redo Buffers 6356992 bytes<br /><br />Step 7: Duplicate the database by connecting to target,auxiliary and catalog.<br /><br />$ rman target SYS/sree123@TEST CATALOG rman/password@rman auxiliary /<br /><br />Recovery Manager: Release 10.2.0.3.0 - Production on Fri Apr 17 10:47:25 2009<br /><br />Copyright (c) 1982, 2005, Oracle. All rights reserved.<br /><br />connected to target database: TEST (DBID=1982474078)<br />connected to recovery catalog database<br />connected to auxiliary database: TEST (not mounted)<br /><br />RMAN> DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER;<br /><br />Starting Duplicate Db at 17-APR-09<br />allocated channel: ORA_AUX_DISK_1<br />channel ORA_AUX_DISK_1: sid=485 devtype=DISK<br /><br />contents of Memory Script:<br />{<br /> set until scn 207869;<br /> restore clone standby controlfile;<br /> sql clone 'alter database mount standby database';<br />}<br />executing Memory Script<br /><br />executing command: SET until clause<br /><br />Starting restore at 17-APR-09<br />using channel ORA_AUX_DISK_1<br /><br />channel ORA_AUX_DISK_1: starting datafile backupset restore<br />channel ORA_AUX_DISK_1: restoring control file<br />channel ORA_AUX_DISK_1: reading from backup piece /backups/oracle/TEST/TEST_1_684413087<br />ORA-19870: error reading backup piece /backups/oracle/TEST/TEST_1_684413087<br />ORA-19505: failed to identify file "/backups/oracle/TEST/TEST_1_684413087"<br />ORA-27037: unable to obtain file status<br />SVR4 Error: 2: No such file or directory<br />Additional information: 3<br />failover to previous backup<br /><br />RMAN-00571: ===========================================================<br />RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />RMAN-00571: ===========================================================<br />RMAN-03002: failure of Duplicate Db command at 04/17/2009 10:47:47<br />RMAN-03015: error occurred in stored script Memory Script<br />RMAN-06026: some targets not found - aborting restore<br />RMAN-06024: no backup or copy of the control file found to restoreSreejithnoreply@blogger.com