oracle 12c backup and recovery

/o1_mf_users_dk5wmv12_.dbfChannel ora_disk_1:starting piece 1 at 10-may-17Channel ora_disk_1:finished piece 1 at 10-may-17Piece handle=/home/oracle/fast_recovery_area/andycdb/4ecf8621e3da38eee0531019640aa598/backupset/2017_05_10/o1_ MF_NNNDF_TAG20170510T234055_DK6F47WQ_.BKP tag=tag20170510t234055 Comment=noneChannel Ora_disk_1:backup set complete, elapsed time:00:00:36Finished

/oracleplus/SYSTEM01.DBF (0) block:1 dba:0x00000000------------------------------------------- -----------------Data File Header struct KCVFH, 1112 bytes @0 ub4 tailchk @8188 bbed> P kcvfhbfh struct kcvfhbfh, bytes @0 ub1 TYPE_KCBH @0 0x0b ub1 frmt_kcbh @1 0xa2 ub1 SPARE1_KCBH @2 0x00 ub1 spare2_kcbh @3 0x00 ub4 RDBA_KCBH @4 0x00400001 ub4 bas_kcbh @8 0x000000

Rman can perform db,tablespace,datafile,block level and TSPITR recovery in previous versions of 12C, 12C introduces table-level recoveryA single table can be recovered without opening the flashback.example, create a tableSql> alter session set CONTAINER=PDB2;Session altered.Sql> CREATE TABLE Frank.t1 as SELECT * from Dba_tables;Table created.Backing Up the databa

Oracle Database Operations (10)-logical backup and recovery of databases (tables), oracle backup and recovery Logical backup and recovery of

Received the first recovery rescue using Oracle 12C as a production library. There are two business data file file headers damaged, other data files are all a September backup, under current conditions, hope we can help them recover the data in the business documentDatabase version Information The code is as

Error: ORA-01194: File 1 requires more recovery to maintain consistency ORA-01110: Data file 1: ' E:\APP\XIFENFEI\ORADATA\XIFENFEI\SYSTEM01. DBF ' Idle> alter system set "_allow_resetlogs_corruption" =true scope=spfile; The system has changed. idle> shutdown Immediate ORA-01109: Database not open The database has been unloaded. The ORACLE routine has been closed. idle> s

Record the restoration of the ORACLE 12C CDB database when the current redo is lost. ORACLE 12C redo exception recovery test-some pdb are not open normallyIn order to verify the restoration of the ORACLE

ora_disk_1:finished piece 1 at 10-may-17Piece handle=/home/oracle/fast_recovery_area/andycdb/4ecf8621e3da38eee0531019640aa598/backupset/2017_05_10/o1_ MF_NNNDF_TAG20170510T234055_DK6F47WQ_.BKP tag=tag20170510t234055 Comment=noneChannel Ora_disk_1:backup set complete, elapsed time:00:00:36Finished backup at 10-MAY-17 Starting control File and SPFILE autobackup at

. . Exported "Xxcis". " Gtsdecheaddel "0 KB 0 rows. . Exported "Xxcis". " Gtsdecmessagesend "0 KB 0 rows. . Exported "Xxcis". " Gtsdecprintparameters "0 KB 0 rows. . Exported "Xxcis". " Gtsdecreceiptresult "0 KB 0 rows. . Exported "Xxcis". " Gtsdecsupplementlist "0 KB 0 rows. . Exported "Xxcis". " Gtsexportinvoice "0 KB 0 rows. . Exported "Xxcis". " Gtsmerger " 0 KB 0 rows. . Exported "Xxcis". " Investmode "0 KB 0 rows. . Exported "Xxcis". " Mergercolumnorder "0 KB 0 r

I. Mark data Log On with the scott user and set the tag data SQL> select table_name from user_tables; TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE EMP_BAK Creates a backup table emp_bak for the emp table. Ii. Back up the database 1. Close the database cleanly. SQL> shutdownimmediate Databaseclosed. Databasedismounted. Oracle instance shut down. 2. Package

Database version The code is as follows Copy Code BANNER con_id-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition release 12.1.0.1.0-64bit Production 0Pl/sql Release 12.1.0.1.0-production 0CORE 12.1.0.1.0 Production 0TNS for 64-bit windows:version 12.1.0.1.0-production 0Nlsrtl Version 12.1.0.1.0-produ