rman restore database(spfile,controlfile, datafile)
SQL> select dbid from v$database;
DBID
----------
50441556
[oracle@mysql1 ~]$ rman target /
RMAN> set DBID=50441556
RMAN> startup force nomount;
startup failed:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/u01/app/oracle/dbs/inittestasm.ora'
starting Oracle instance without parameter file for retrival of spfile Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 1266320 bytes
Variable Size 58723696 bytes
Database Buffers 92274688 bytes
Redo Buffers 7118848 bytes
RMAN> restore spfile from '/home/oracle/backup/database_0cmdrgc8_1_1.dbf';
RMAN> restore controlfile from '/home/oracle/backup/database_0cmdrgc8_1_1.dbf';
RMAN> startup force nomount;
RMAN> restore controlfile from '/home/oracle/backup/database_0cmdrgc8_1_1.dbf';
RMAN> alter database mount
RMAN> restore database
RMAN> recover database
RMAN> alter database open resetlogs;
[@more@]找一個臨時pfile
RMAN> startup nomount;
RMAN> restore spfile to '/tmp/spfiletestasm.ora' from autobackup;
RMAN> !cp /tmp/spfiletestasm.ora $ORACLE_HOME/dbs
RMAN> startup nomount;
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
RMAN> restore database;
RMAN> recover database;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1050668/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Restore standby database controlfile in ASM (refreshing standby controlfile)RESTDatabaseASM
- RMAN-06100: no channel to restore a backup or copy of datafileREST
- Oracle基於TSM恢復實驗(模擬spfile、controlfile、datafile丟失)Oracle
- RMAN-06023 no backup or copy of datafile 1 found to restoreREST
- rman_restore controlfile_and_autobackup之關係測試REST
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- 轉:Oracle基於TSM恢復實驗(模擬spfile、controlfile、datafile丟失)Oracle
- RMAN restore validate database報ORA-19693RESTDatabase
- restore controlfile from autobackREST
- Restore Controlfile from SBT Tape Fails RMAN-6172 (Doc ID 1314134.1)RESTAI
- 應對 "RMAN-06023: no backup or copy of datafile 1 found to restore"錯誤REST
- rman copy asm datafile(rename asm datafile)ASM
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- oracle-新增 controlfile 以及重建spfileOracle
- 同事在QQ群提出的rman restore spfile報錯ORA-15046的問題REST
- restore database報RMAN-06026和RMAN-06023錯誤RESTDatabase
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- guarantee restore points-Flashback after RMAN restoreREST
- Renaming a Datafile in the Primary DatabaseDatabase
- restore database check readonlyRESTDatabase
- Cold backup and restore the entire databaseRESTDatabase
- rman restore archivelog logRESTHive
- ALTER DATABASE DATAFILE OFFLINEDatabase
- RMAN restore fails with ORA-01180: can not create datafile 1 (文件 ID 1265151.1)RESTAI
- recover database using backup controlfileDatabase
- rman datafile恢復(歸檔模式)模式
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node [ID 415579.1]RESTDatabase
- alter database datafile offline drop 與 alter tablespace drop datafile 區別Database
- alter database datafile offline and alter database tablespace ...offlineDatabase
- RMAN duplicat databaseDatabase
- rman recover databaseDatabase
- RMAN duplicate databaseDatabase
- alter database ... create datafile的原理及用途Database
- alter database datafile 4 offline drop;Database
- 恢復一則 alter database create datafile '' as ''Database
- recover database using backup controlfile理解Database
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST