rman backup and recovery

/201408/327614.htmlConfiguring Rman and backing upRman> Show All;RMAN configuration parameters for database with Db_unique_name SCPDB01 is:CONFIGURE RETENTION POLICY to RECOVERY windows of 7 days;CONFIGURE BACKUP optimization OFF; # DefaultCONFIGURE DEFAULT DEVICE TYPE to DISK;CONFIGURE Controlfile autobackup on;CONFIG

Command: connecttarget (connecttargetsystemoracle @ ora10g. If the database does not exist, you can directly start it with startup under the rman command. Command: connect target/(connect target system/oracle @ ora10g. If the database does not exist, you can directly start it with startup under the rman command. 1. Check the database mode:Sqlplus/nologConn/as sysdbaArchive log list (check whether the da

1. Check the database mode:Sqlplus/nologConn/as sysdbaArchive log list (check whether the database is in archive Mode) If not, the database archive mode is modified.Startup mountAlter database archivelogAlter database open 2. connect to the target database Command: connect target/(connect target system/Oracle @ ora10g. If the database does not exist, run the rman command to start the database using startup)You can connect to the target database. (

Monitor the Data Backup recovery progress (EXPDP/IMPDP/RMAN) 1. view the EXPDP/IMPDP progress 1. When you export data, if the data volume is large, some people may be anxious in the middle, but they may want to see how the progress is. You can see it using two views: Col owner_name for a10col job_name for a20col operation for a10col job_mode for a10col state for

One switch command1 switch command usageUpdate the data file name to the data file name specified during image copy under rmanUpdate the data file name to the name specified by the set newname command.2. Prerequisites for using the switch commandRman must be connected to the target databaseWhen you switch tablespaces, datafiles, and tempfiles, these files must be offline.When you switch the entire database, the database cannot be open.3. NotesSwitch... to copy command for

Tags: Oracle training Oracle Tutorial Oracle video Oracle Video tutorial Oracle Database tutorialOracle Video Tutorial Goals Oracle Video tutorial, wind Brother this set of Oracle Tutorial Training learning Oracle Database Rman Backup Recovery Foundation, such as Rman role and architecture, Nocatalog and Catalog Intro

Oracle rman catalog backup and recovery, rmancatalog 1. Lost control fileStart the database to nomount: restore controlfile from autobackup/restore controlfile from '+ data/backup/contrlbak /...'-> Alter database mount-> open;2. Accidentally deleting data filesStart to mount status-> alter database datafile 7 offline->

Case 6: --Recover data with image (mirrored backup) 1) Establish a mirrored backup rman> Delete backup; rman> list backup; rman> Backup

; print:aA----------0Sql> print:bB----------1Sql> Print:cC----------1Sql> exec DBMS_BACKUP_RESTORE.NIDPROCESSCF (: a,:b);The PL/SQL process has completed successfully.Sql> print:aA----------1Sql> print:bB----------1sql> exec dbms_backup_restore.nidend;The PL/SQL process has completed successfully.Sql> select dbid from V$database;DBID----------3935589514After the successful modification of dbid, the parameter files, control files, data files and log files are recovered in sequence: Sql>startup No

Run {Allocate channel C1 type disk;Allocate channel C2 type disk;Allocate channel C3 type disk;SQL ' alter system switch logfile ';SQL ' alter system switch logfile ';SQL ' alter system switch logfile ';SQL ' alter system archive log current ';Backup Incremental Level 0Format '/DATA/APP/RMANBACKUP/DB_FULL_%U.BKP 'Database plus archivelog;Release channel C1;Release channel C2;Release channel C3;}run{Set newname for datafile 1 to '/data/app/oradata/sour

; database closed. database dismounted. oracle instance shut down. sys @ orcl> host Rm-RF/u01/APP/Oracle/oradata/orcl/datafile/think. DBF restarts Database SYS @ orcl> startuporacle instance started. total system global area 419430400 bytesfixed size 1219760 bytesvariable size 125829968 bytesdatabase buffers 289406976 bytesredo buffers 2973696 bytesdatabase mounted. ORA-01157: cannot identify/lock data file 8-see dbwr trace fileORA-01110: Data File 8: '/u01/APP/Oracle/oradata/orcl/datafile/think

. Create a directory Mkdir-p/u01/apps/oracle/admin/fact/adump Mkdir-p/u01/apps/oracle/admin/fact/bdump Mkdir-p/u01/apps/oracle/admin/fact/cdump Mkdir-p/u01/apps/oracle/admin/fact/udump Mkdir-p/u01/fact/ Mkdir-p/u01/apps/oracle/flash_recovery_area Mkdir-p/u01/fact/datafiles Mkdir-p/u01/fact/logfiles 2. Determine Permissions Ls-l/u01/apps/oracle/admin/fact/ Ls-l/u01/fact Ls-l/u01/ Ls-l/u01/apps/oracle/ 3. view disk space Bdf4. ensure the availability of Remote Test Database

Restore databases in different locations Restore databases in different locations Machine: Select instance_name from v $ instance; Select name from v $ database; Select name from v $ datafile; Log query mode: Archive log list; Shutdown immediate; Startup mount; Change the log archive mode: Alter database archivelog; Alter database open; Alter system archive log current; Select name from v $ archived_log; Open Control file tracking: Alter database backup