AYY備份恢復gopossbt

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

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '+GOPOS_DATA'; 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 BACKUPSET DATABASE 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 {

'+GOPOS_DATA/goposstb/tempfile/temp.263.917923477';

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';

}

$ rman target / @rman.sh

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