Creating and updating duplicate databases with rman american internet dating sites


17-May-2016 04:48

MYDOMAIN.it:/opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04 [email protected] MYDOMAIN.it's password: o1_mf_s_811860548_8otpo4nr_100% 9664KB 9.4MB/s Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 4 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. This may either be due to the server not having permission to access this directory, or a server error.Let's duplicate for the first time our target database PROD located on a different server (vsi10) using a backup taken from the source database PROD located on vsi08 server: the duplicated database have the same SID and directories structure of source database.So I need to take a backup of PROD database at vsi08 server [[email protected] ~]$ export NLS_DATE_FORMAT='DD-MM-RRRR HH24: MI: SS' [[email protected] ~]$ export ORACLE_SID=PROD [[email protected] ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 4 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. connected to target database: PROD (DBID=223010867) RMAN backup database plus archivelog delete input; Starting backup at current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=20 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=65 RECID=18 STAMP=811856828 channel ORA_DISK_1: starting piece 1 at channel ORA_DISK_1: finished piece 1 at piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114709_8otm0xgs_tag=TAG20130404T114709 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: channel ORA_DISK_1: deleting archived log(s) archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_65_8otm0wbf_RECID=18 STAMP=811856828 Finished backup at Starting backup at using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/opt/app/oracle/oradata/PROD/system01input datafile file number=00002 name=/opt/app/oracle/oradata/PROD/sysaux01input datafile file number=00003 name=/opt/app/oracle/oradata/PROD/undotbs01input datafile file number=00004 name=/opt/app/oracle/oradata/PROD/users01channel ORA_DISK_1: starting piece 1 at channel ORA_DISK_1: finished piece 1 at piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_nnndf_TAG20130404T114710_8otm0yrs_tag=TAG20130404T114710 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: Finished backup at Starting backup at current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=66 RECID=19 STAMP=811856855 channel ORA_DISK_1: starting piece 1 at channel ORA_DISK_1: finished piece 1 at piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114735_8otm1qyk_tag=TAG20130404T114735 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: channel ORA_DISK_1: deleting archived log(s) archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_66_8otm1qsm_RECID=19 STAMP=811856855 Finished backup at Starting Control File and SPFILE Autobackup at piece handle=/opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811856857_8otm1s7l_comment=NONE Finished Control File and SPFILE Autobackup at list backup; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 23 30.68M DISK BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20130404T114709 Piece Name: /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114709_8otm0xgs_List of Archived Logs in backup set 23 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 65 743889 777811 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 24 Full 740.51M DISK BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20130404T114710 Piece Name: /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_nnndf_TAG20130404T114710_8otm0yrs_List of Datafiles in backup set 24 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- ------------------- ---- 1 Full 777822 /opt/app/oracle/oradata/PROD/system012 Full 777822 /opt/app/oracle/oradata/PROD/sysaux013 Full 777822 /opt/app/oracle/oradata/PROD/undotbs014 Full 777822 /opt/app/oracle/oradata/PROD/users01BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 25 4.00K DISK BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20130404T114735 Piece Name: /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114735_8otm1qyk_List of Archived Logs in backup set 25 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- ------------------- ---------- --------- 1 66 777811 777836 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------- 26 Full 9.36M DISK BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20130404T114737 Piece Name: /opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811856857_8otm1s7l_SPFILE Included: Modification time: SPFILE db_unique_name: PROD Control File Included: Ckp SCN: 777847 Ckp time: [[email protected] PROD]$ scp -r /opt/app/oracle/flash_recovery_area/PROD/*back* vsi10.If you are the administrator for this site, please check the permissions on this directory and file a Help SU if you need help.If you are a user, please contact the administrators for this site, or Help SU if you think the error is due to a server problem.After I inserted those rows on PROD database @vsi08 server I took a backup of the archived redo log: as you can seen above that backup started at [[email protected] ~]$ rman target sys/[email protected]_AT_VSI08 auxiliary / Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 4 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. connected to target database: PROD (DBID=223010867) connected to auxiliary database: PROD (not mounted) RMAN duplicate target database to PROD until time 'sysdate-(40/(24*60))' nofilenamecheck; Starting Duplicate Db at using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=134 device type=DISK contents of Memory Script: { set until scn 777847; sql clone "alter system set db_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate; startup clone force nomount restore clone primary controlfile; alter clone database mount; } executing Memory Script executing command: SET until clause sql statement: alter system set db_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile sql statement: alter system set db_unique_name = ''PROD'' comment= ''Modified by RMAN duplicate'' scope=spfile Oracle instance shut down Oracle instance started Total System Global Area 1686925312 bytes Fixed Size 2213976 bytes Variable Size 1006634920 bytes Database Buffers 671088640 bytes Redo Buffers 6987776 bytes Starting restore at allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=133 device type=DISK channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811856857_8otm1s7l_channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811856857_8otm1s7l_tag=TAG20130404T114737 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: output file name=/opt/app/oracle/oradata/PROD/control01output file name=/opt/app/oracle/flash_recovery_area/PROD/control02Finished restore at database mounted contents of Memory Script: { set until scn 777847; set newname for datafile 1 to "/opt/app/oracle/oradata/PROD/system01.dbf"; set newname for datafile 2 to "/opt/app/oracle/oradata/PROD/sysaux01.dbf"; set newname for datafile 3 to "/opt/app/oracle/oradata/PROD/undotbs01.dbf"; set newname for datafile 4 to "/opt/app/oracle/oradata/PROD/users01.dbf"; restore clone database ; } executing Memory Script executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00001 to /opt/app/oracle/oradata/PROD/system01channel ORA_AUX_DISK_1: restoring datafile 00002 to /opt/app/oracle/oradata/PROD/sysaux01channel ORA_AUX_DISK_1: restoring datafile 00003 to /opt/app/oracle/oradata/PROD/undotbs01channel ORA_AUX_DISK_1: restoring datafile 00004 to /opt/app/oracle/oradata/PROD/users01channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_nnndf_TAG20130404T114710_8otm0yrs_channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_nnndf_TAG20130404T114710_8otm0yrs_tag=TAG20130404T114710 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: Finished restore at contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=1 STAMP=811860120 file name=/opt/app/oracle/oradata/PROD/system01datafile 2 switched to datafile copy input datafile copy RECID=2 STAMP=811860120 file name=/opt/app/oracle/oradata/PROD/sysaux01datafile 3 switched to datafile copy input datafile copy RECID=3 STAMP=811860120 file name=/opt/app/oracle/oradata/PROD/undotbs01datafile 4 switched to datafile copy input datafile copy RECID=4 STAMP=811860120 file name=/opt/app/oracle/oradata/PROD/users01contents of Memory Script: { set until time "sysdate-(40/(24*60))"; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at using channel ORA_AUX_DISK_1 starting media recovery channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=66 channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114735_8otm1qyk_channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T114735_8otm1qyk_tag=TAG20130404T114735 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_66_8otp7sqx_thread=1 sequence=66 channel clone_default: deleting archived log(s) archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_66_8otp7sqx_RECID=20 STAMP=811860121 channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=67 channel ORA_AUX_DISK_1: reading from backup piece /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T120505_8otn2kln_channel ORA_AUX_DISK_1: piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T120505_8otn2kln_tag=TAG20130404T120505 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_67_8otp7v1l_thread=1 sequence=67 channel clone_default: deleting archived log(s) archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_67_8otp7v1l_RECID=21 STAMP=811860123 media recovery complete, elapsed time: Finished recover at contents of Memory Script: { shutdown clone immediate; startup clone nomount; sql clone "alter system set db_name = ''PROD'' comment= ''Reset to original value by RMAN'' scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script database dismounted Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 1686925312 bytes Fixed Size 2213976 bytes Variable Size 1006634920 bytes Database Buffers 671088640 bytes Redo Buffers 6987776 bytes sql statement: alter system set db_name = ''PROD'' comment= ''Reset to original value by RMAN'' scope=spfile sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 1686925312 bytes Fixed Size 2213976 bytes Variable Size 1006634920 bytes Database Buffers 671088640 bytes Redo Buffers 6987776 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PROD" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE '/opt/app/oracle/oradata/PROD/system01.dbf' CHARACTER SET WE8MSWIN1252 contents of Memory Script: { set newname for tempfile 1 to "/opt/app/oracle/oradata/PROD/temp01.dbf"; switch clone tempfile all; catalog clone datafilecopy "/opt/app/oracle/oradata/PROD/sysaux01.dbf", "/opt/app/oracle/oradata/PROD/undotbs01.dbf", "/opt/app/oracle/oradata/PROD/users01.dbf"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to /opt/app/oracle/oradata/PROD/temp01in control file cataloged datafile copy datafile copy file name=/opt/app/oracle/oradata/PROD/sysaux01RECID=1 STAMP=811860141 cataloged datafile copy datafile copy file name=/opt/app/oracle/oradata/PROD/undotbs01RECID=2 STAMP=811860141 cataloged datafile copy datafile copy file name=/opt/app/oracle/oradata/PROD/users01RECID=3 STAMP=811860141 datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=811860141 file name=/opt/app/oracle/oradata/PROD/sysaux01datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=811860141 file name=/opt/app/oracle/oradata/PROD/undotbs01datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=811860141 file name=/opt/app/oracle/oradata/PROD/users01contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at backup archivelog all delete input; Starting backup at current log archived using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=16 device type=DISK channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=70 RECID=23 STAMP=811860462 input archived log thread=1 sequence=71 RECID=24 STAMP=811860486 input archived log thread=1 sequence=72 RECID=25 STAMP=811860546 channel ORA_DISK_1: starting piece 1 at channel ORA_DISK_1: finished piece 1 at piece handle=/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T124907_8otpo3bb_tag=TAG20130404T124907 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: channel ORA_DISK_1: deleting archived log(s) archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_70_8otplgnq_RECID=23 STAMP=811860462 archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_71_8otpm6bs_RECID=24 STAMP=811860486 archived log file name=/opt/app/oracle/flash_recovery_area/PROD/archivelog/2013_04_04/o1_mf_1_72_8otpo2p9_RECID=25 STAMP=811860546 Finished backup at Starting Control File and SPFILE Autobackup at piece handle=/opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811860548_8otpo4nr_comment=NONE Finished Control File and SPFILE Autobackup at [[email protected] ~]$ scp /opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04/o1_mf_annnn_TAG20130404T124907_8otpo3bb_vsi10.MYDOMAIN.it:/opt/app/oracle/flash_recovery_area/PROD/backupset/2013_04_04 [email protected] MYDOMAIN.it's password: o1_mf_annnn_TAG20130404T124907_8otpo3bb_100% 155KB 154.5KB/s [[email protected] ~]$ scp /opt/app/oracle/flash_recovery_area/PROD/autobackup/2013_04_04/o1_mf_s_811860548_8otpo4nr_vsi10.

creating and updating duplicate databases with rman-71

dating bexley

All the steps to set up a duplicated database are already explained in this previous post.The purpose of this blog article is to show how you can use RMAN active duplication feature to move a database on another file system on the same machine.



Sarajevo for marriage to black people singles in sarajevo for a guy newly divorced. … continue reading »


Read more

coach Blake Shelton, who is also recently divorced.… continue reading »


Read more

Many of these games are online only (MMO Sex Game) so an internet connection may be required to play.… continue reading »


Read more

There is caucasian, ebony, latin and some asian hookers occasionally. Join to get 10 free private teasers and 9.99 credits for free!… continue reading »


Read more

It became clear that the Israeli invasion and the subsequent Anglo-French attack had been planned beforehand by the three countries. Historians conclude the crisis "signified the end of Great Britain's role as one of the world's major powers".… continue reading »


Read more

I am delighted and excited to welcome you through this medium to our parish community. … continue reading »


Read more

Continue Reading Several of our former gymnasts have gone on to do gymnastics beyond their college careers through fitness competitions, stunt doubling, and performing.… continue reading »


Read more

cam chat rooms free chat for free webcam cam chat rooms free cam free chat.… continue reading »


Read more