repl FAT_BROWN_SONG 3 TALL_RED_FOOD 5 fill.sql CREATE TABLE fbs (pktest NUMBER(5) PRIMARY KEY, vctest VARCHAR2(15) NOT NULL) TABLESPACE FAT_BROWN_SONG STORAGE (INITIAL 50K); INSERT INTO fbs VALUES (1, 'FBS_1'); CREATE TABLE trf (pktest NUMBER(5) PRIMARY KEY, vctest VARCHAR2(15) NOT NULL) TABLESPACE TALL_RED_FOOD STORAGE (INITIAL 50K); INSERT INTO trf VALUES (1, 'TRF_1'); STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; select v$tablespace.name, v$datafile.name from v$tablespace, v$datafile where v$tablespace.ts#=v$datafile.TS#; /u01/uhy57/backup rman CONNECT TARGET / SHUTDOWN IMMEDIATE STARTUP MOUNT RUN { BACKUP DATABASE FORMAT '/u01/uhy57/backup/rman_%d_%U.bus';} cd wetfish/node02 rm fatbrownsong02.dbf CONNECT TARGET / connected to target database: WETFISH (DBID=1731625645) shutdown immediate using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of shutdown command at 09/13/2015 18:26:49 ORA-01116: error in opening database file 7 ORA-01110: data file 7: '/u01/uhy57/wetfish/node02/fatbrownsong02.dbf' ORA-27041: unable to open file Solaris-AMD64 Error: 2: No such file or directory Additional information: 3 connect / as sysdba alter tablespace FAT_BROWN_SONG offline immediate; rman connect target / retore datafile 7 delete noprompt obsolete; rman target / CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/uhy57/backup/rman/rman_%d_%U'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG; STARTUP NOMOUNT; RESTORE DATABASE; RECOVER DATABASE; select log_mode from v$database; startup nomount run { allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 type disk; allocate channel ch4 type disk; allocate channel ch5 type disk; allocate channel ch6 type disk; allocate channel ch7 type disk; restore controlfile from '/u01/backup/controlfile.bk'; alter database mount; restore database; recover database until time "to_date('14/03/2012 10:15:00','MM/DD/YYYY HH24:MI:SS')"; release channel ch1; } alter database open resetlogs; RMAN> startup mount ... RMAN> run{ 2> set until scn=25834569; 3> restore database; 4> recover database; 5> } RMAN> alter database open resetlogs; rman target / CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/uhy57/backup/rman/rman_%d_%U'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG; export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=pripadchev.artem.p3415 PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN rman @/u01/app/oracle/reprman.rman /u01/app/oracle/rep.sh ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_HOME ORACLE_SID=pripadchev.artem.p3415 export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH NLS_LANG=American_America.UTF8 export NLS_LANG NLS_SORT=AMERICAN export NLS_SORT NLS_DATE_LANGUAGE=AMERICAN export NLS_DATE_LANGUAGE rman @/u01/app/oracle/reprman.rman reprman.rman connect target; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/uhy57/backup/rman/rman_%d_%U'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG; exit; EDITOR=vi crontab -e 0 * * * * /u01/app/oracle/rep.sh 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /u01/app/oracle/rep.sh 0-55/5 * * * * /u01/app/oracle/rep.sh echo "0 */1 * * * /u01/app/oracle/rep.sh" >> crontab inintpripadchev.artem.p3415.ora log_archive_dest_1='LOCATION=/u01/uhy57/log/' log_archive_dest_state_1=ENABLE log_archive_format=%t_%s_%r.arc $ mkdir uhycp $ cd uhycp $ ls $ mkdir node01 $ mkdir node02 $ mkdir node03 $ mkdir node04 $ mkdir log startup alter database archivelog; alter system archive log start; alter database create standby controlfile as '/u01/uhycp/ctrlcp1.ctl'; /u01/uhy57/wetfish/node01/acume76.dbf /u01/uhy57/wetfish/node03/utebe94.dbf /u01/uhy57/wetfish/node03/wiz57.dbf /u01/uhy57/wetfish/undotbs01.dbf /u01/uhy57/wetfish/node04/agawaqo738.dbf /u01/uhy57/wetfish/node01/fatbrownsong01.dbf /u01/uhy57/wetfish/node02/fatbrownsong02.dbf /u01/uhy57/wetfish/node02/fatbrownsong03.dbf /u01/uhy57/wetfish/node03/tallredfood01.dbf /u01/uhy57/wetfish/node03/tallredfood02.dbf /u01/uhy57/wetfish/node03/tallredfood03.dbf /u01/uhy57/wetfish/node03/tallredfood04.dbf /u01/uhy57/wetfish/node03/tallredfood05.dbf cp /u01/uhy57/wetfish/node01/* node01 cp /u01/uhy57/wetfish/node02/* node02 cp /u01/uhy57/wetfish/node03/* node03 cp /u01/uhy57/wetfish/node04/* node04 $ vi initpripadchev.artem.cp.ora "initpripadchev.artem.cp.ora" 20 lines, 571 characters db_name='wetfish' memory_target=550M sga_target=90M processes=150 audit_file_dest='/u01/app/oracle/admin/orcl/adump' audit_trail='db' db_block_size=8192 db_domain='' db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' db_recovery_file_dest_size=2G diagnostic_dest='/u01/app/oracle' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files='/u01/uhycp/ctrlcp1.ctl' LOG_ARCHIVE_DEST_1='LOCATION=/u01/uhycp/log/' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_FORMAT=%t_%s_%r.arc DB_FILE_NAME_CONVERT=('/u01/uhy57/','/u01/uhycp/') LOG_FILE_NAME_CONVERT=('/u01/uhy57/','/u01/uhycp/') STANDBY_FILE_MANAGEMENT=AUTO cp -R node01 wetfish/node01 cp -R node02 wetfish/node02 cp -R node03 wetfish/node03 cp -R node04 wetfish/node04 cp -R node04/* /u01/uhycp/wetfish/node04/