Contents

  1. AYY備份恢復gopossbt
    1. gopos
    2. goposstb
      1. detail

AYY備份恢復gopossbt

gopos

su - oracle
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '~/goposstb.ctl';

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/temp_backup/full/full_%u_%s_%p'; 
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
scp ~/goposstb.ctl /u01/temp_backup/ goposstb:.

goposstb

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/temp_backup/full/full_%u_%s_%p'; 

su - oracle
RMAN> startup nomount
RMAN> restore controlfile from '/home/oracle/for_goposstb_20161023_v2.ctl';

RUN {
 set newname for datafile 00001 to '+GOPOS_DATA/goposstb/datafile/system.265.917923413';
 set newname for datafile 00002 to '+GOPOS_DATA/goposstb/datafile/sysaux.259.917923413';
 set newname for datafile 00003 to '+GOPOS_DATA/goposstb/datafile/undotbs1.267.917923413';
 set newname for datafile 00004 to '+GOPOS_DATA/goposstb/datafile/users.266.917923413';
 set newname for datafile 00005 to '+GOPOS_DATA/goposstb/datafile/hdapp01.dbf';
 set newname for datafile 00006 to '+GOPOS_DATA/goposstb/datafile/hdapp02.dbf';
 set newname for datafile 00007 to '+GOPOS_DATA/goposstb/datafile/hdapp03.dbf';
 set newname for datafile 00008 to '+GOPOS_DATA/goposstb/datafile/hdapp04.dbf';
 set newname for datafile 00009 to '+GOPOS_DATA/goposstb/datafile/hdapp05.dbf';
 set newname for datafile 00010 to '+GOPOS_DATA/goposstb/datafile/hdapp06.dbf';
 set newname for datafile 00011 to '+GOPOS_DATA/goposstb/datafile/hdapp07.dbf';
 set newname for datafile 00012 to '+GOPOS_DATA/goposstb/datafile/hdapp08.dbf';
 set newname for datafile 00013 to '+GOPOS_DATA/goposstb/datafile/hdappqry01.dbf';
 set newname for datafile 00014 to '+GOPOS_DATA/goposstb/datafile/hd_report01.dbf';
 set newname for datafile 00015 to '+GOPOS_DATA/goposstb/datafile/hd_report02.dbf';
 set newname for datafile 00016 to '+GOPOS_DATA/goposstb/datafile/hdappsettle01.dbf';
 set newname for datafile 00017 to '+GOPOS_DATA/goposstb/datafile/hdappsettle02.dbf';
 set newname for datafile '+GOPOS_DATA/gopos/tempfile/temp.263.917923477' to 
'+GOPOS_DATA/goposstb/tempfile/temp.263.917923477';
 set newname for datafile '+GOPOS_DATA/gopos/datafile/tempqry01.dbf' to '+GOPOS_DATA/goposstb/datafile/tempqry01.dbf';
 set newname for datafile '+GOPOS_DATA/gopos/datafile/temphdapp01.dbf' to '+GOPOS_DATA/goposstb/datafile/temphdapp01.dbf';
set newname for datafile '+GOPOS_DATA/gopos/datafile/temphd_report01.dbf' to 
'+GOPOS_DATA/goposstb/datafile/temphd_report01.dbf';
set newname for datafile '+GOPOS_DATA/gopos/datafile/temphdappsettle01.dbf' to 
'+GOPOS_DATA/goposstb/datafile/temphdappsettle01.dbf';
  restore database
}

$ rman target / @rman.sh


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

detail

SQL> SELECT DF.TOTAL/1073741824 "DataFile Size GB", LOG.TOTAL/1073741824 "Redo Log Size GB", CONTROL.TOTAL/1073741824 
"Control File Size GB", (DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/ 1073741824 "Total Size GB" from dual, (select sum(a.bytes) 
TOTAL from dba_data_files a) DF, (select sum(b.bytes) TOTAL from v$log b) LOG, (select sum((cffsz+1)*cfbsz) TOTAL from x
$kcccf c) CONTROL;

DataFile Size GB Redo Log Size GB Control File Size GB Total Size GB
---------------- ---------------- -------------------- -------------
      129.082031               24           .009536743    153.091568

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/temp_backup/full/full_%u_%s_%p';
RMAN> show all;

RMAN configuration parameters for database with db_unique_name GOPOS are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '+GOPOS_DATA';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_gopos.f'; # default

RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
input datafile file number=00009 name=+GOPOS_DATA/gopos/datafile/hdapp05.dbf
input datafile file number=00010 name=+GOPOS_DATA/gopos/datafile/hdapp06.dbf
input datafile file number=00011 name=+GOPOS_DATA/gopos/datafile/hdapp07.dbf
input datafile file number=00012 name=+GOPOS_DATA/gopos/datafile/hdapp08.dbf
input datafile file number=00014 name=+GOPOS_DATA/gopos/datafile/hd_report01.dbf
input datafile file number=00015 name=+GOPOS_DATA/gopos/datafile/hd_report02.dbf
input datafile file number=00016 name=+GOPOS_DATA/gopos/datafile/hdappsettle01.dbf
input datafile file number=00017 name=+GOPOS_DATA/gopos/datafile/hdappsettle02.dbf
input datafile file number=00013 name=+GOPOS_DATA/gopos/datafile/hdappqry01.dbf
input datafile file number=00003 name=+GOPOS_DATA/gopos/datafile/undotbs1.267.917923413
input datafile file number=00002 name=+GOPOS_DATA/gopos/datafile/sysaux.259.917923413
input datafile file number=00001 name=+GOPOS_DATA/gopos/datafile/system.265.917923413
input datafile file number=00004 name=+GOPOS_DATA/gopos/datafile/users.266.917923413
channel ORA_DISK_1: starting piece 1 at 2016-10-23 11:39:34
channel ORA_DISK_1: finished piece 1 at 2016-10-23 11:39:49
piece handle=+GOPOS_DATA/gopos/backupset/2016_10_23/nnndf0_tag20161023t113933_0.280.925990775 tag=TAG20161023T113933 
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 2016-10-23 11:39:49

Starting Control File and SPFILE Autobackup at 2016-10-23 11:39:49
piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/c-2618716754-20161023-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2016-10-23 11:39:50


su - grid
asmcmd
cp +GOPOS_DATA/gopos/backupset/2016_10_23/nnndf0_tag20161023t113933_0.280.925990775 /home/grid/goposFullWithoutPlus.dbf
scp /home/grid/goposFullWithoutPlus.dbf goposstb:.



su - oracle
RMAN> startup nomount
RMAN> restore controlfile from '/home/oracle/for_goposstb_20161023_v2.ctl';

Starting restore at 23-10��-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1654 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+GOPOS_DATA/goposstb/controlfile/current.288.925904919
Finished restore at 23-10��-16

RMAN> alter database mount

RUN {
 set newname for datafile 00001 to '+GOPOS_DATA/goposstb/datafile/system.265.917923413';
 set newname for datafile 00002 to '+GOPOS_DATA/goposstb/datafile/sysaux.259.917923413';
 set newname for datafile 00003 to '+GOPOS_DATA/goposstb/datafile/undotbs1.267.917923413';
 set newname for datafile 00004 to '+GOPOS_DATA/goposstb/datafile/users.266.917923413';
 set newname for datafile 00005 to '+GOPOS_DATA/goposstb/datafile/hdapp01.dbf';
 set newname for datafile 00006 to '+GOPOS_DATA/goposstb/datafile/hdapp02.dbf';
 set newname for datafile 00007 to '+GOPOS_DATA/goposstb/datafile/hdapp03.dbf';
 set newname for datafile 00008 to '+GOPOS_DATA/goposstb/datafile/hdapp04.dbf';
 set newname for datafile 00009 to '+GOPOS_DATA/goposstb/datafile/hdapp05.dbf';
 set newname for datafile 00010 to '+GOPOS_DATA/goposstb/datafile/hdapp06.dbf';
 set newname for datafile 00011 to '+GOPOS_DATA/goposstb/datafile/hdapp07.dbf';
 set newname for datafile 00012 to '+GOPOS_DATA/goposstb/datafile/hdapp08.dbf';
 set newname for datafile 00013 to '+GOPOS_DATA/goposstb/datafile/hdappqry01.dbf';
 set newname for datafile 00014 to '+GOPOS_DATA/goposstb/datafile/hd_report01.dbf';
 set newname for datafile 00015 to '+GOPOS_DATA/goposstb/datafile/hd_report02.dbf';
 set newname for datafile 00016 to '+GOPOS_DATA/goposstb/datafile/hdappsettle01.dbf';
 set newname for datafile 00017 to '+GOPOS_DATA/goposstb/datafile/hdappsettle02.dbf';
 set newname for datafile '+GOPOS_DATA/gopos/tempfile/temp.263.917923477' to 
'+GOPOS_DATA/goposstb/tempfile/temp.263.917923477';
 set newname for datafile '+GOPOS_DATA/gopos/datafile/tempqry01.dbf' to '+GOPOS_DATA/goposstb/datafile/tempqry01.dbf';
 set newname for datafile '+GOPOS_DATA/gopos/datafile/temphdapp01.dbf' to '+GOPOS_DATA/goposstb/datafile/temphdapp01.dbf';
set newname for datafile '+GOPOS_DATA/gopos/datafile/temphd_report01.dbf' to 
'+GOPOS_DATA/goposstb/datafile/temphd_report01.dbf';
set newname for datafile '+GOPOS_DATA/gopos/datafile/temphdappsettle01.dbf' to 
'+GOPOS_DATA/goposstb/datafile/temphdappsettle01.dbf';
  restore database
}

$ rman target / @rman.sh


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

首頁/2016-10-23 (last edited 2016-10-23 17:51:27 by localhost)