RMAN backup and recovery (2)

1: The method is the easiest, but it has deviated from the original intention of RMAN to resume learning. However, a prerequisite for this is that your pfile still contains createspfilec: oracleproduct10.2.0db _ 1databasespfileORCL. orafrompfilec: oracleproduct10.2.0db _ 1databaseinitORCL. ora; 2: Use

1: The method is the easiest, but it has deviated from the original intention of RMAN to resume learning. However, a prerequisite for this is that your pfile still has the create spfile = 'C: /oracle/product/10.2.0/db_1/database/spfileORCL. ora 'from pfile = 'C:/oracle/product/10.2.0/db_1/database/initORCL. ora '; 2: Use

1: The method is the easiest, but it has deviated from the original intention of RMAN to resume learning.

However, this requires that your pfile still exists.

Create spfile = 'C:/oracle/product/10.2.0/db_1/database/spfileORCL. ora 'from pfile = 'C:/oracle/product/10.2.0/db_1/database/initORCL. ora ';

2: Steps for using RMAN

1: shutdown immediate;

2: startup nomount

3: set DBID = 1274923109;

4: restore spfile from 'absolute backup file path ';

5: shutdown immediate

6: startup

C:/Documents and Settings/Administrator> rman target/recovery Manager: Release 11.1.0.6.0-Production on Thursday June 30 11:42:43 2011 Copyright (c) 1982,200 7, Oracle. all rights reserved. connect to the target database: ORCL (DBID = 1274923109) RMAN> shutdown immediate; Use the target database control file instead of restoring directory database closed database uninstalled Oracle instance closed

RMAN> startup nomount connected to the target database (not started) startup failed: ORA-01078: failure in processing system parametersLRM-00109 :???????????????? 'C:/APP/ADMINISTRATOR/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL. ORA 'start the Oracle instance without a parameter file to retrieve the global regions of the startup system of the spfileOracle instance totaling 159019008 bytes Fixed Size 1331852 bytes Variable Size 67112308 bytes Database Buffers 83886080 bytes Redo Buffers 6688768 bytes RMAN> set DBID = 1274923109; executing command: SET DBID

RMAN> restore spfile from 'C:/app/Administrator/flash_recovery_area/ORCL/BACKUPSET/201%06_29/o%mf_ncsnf_tag201%29t163604_70os14y2_.bkp '; start the restore in 30-6 months-11 and use the target database control file to replace the channel for restoring the directory allocation: ORA_DISK_1 channel ORA_DISK_1: SID = 115 device type = DISK channel ORA_DISK_1: The restore is working from autobackup c: /app/Administrator/flash_recovery_area/ORCL/BACKUPSET/20151106_29/o%mf_ncsnf_tag20151129t163604_70os14y2_.bkp restore spfile channel ORA_DISK_1: restore SPFILE from AUTOBACKUP completed restore in 30-6 months-11 RMAN> shutdown immediateOracle instance closed RMAN> startup; connected to target database (not started) oracle instance started Database loaded Database opened system global region total 535662592 bytes Fixed Size 1334380 bytes Variable Size 331350932 bytes Database Buffers 197132288 bytes Redo Buffers 5844992 bytes