Explore Oracle RMAN_07 recovery of all database files lost

Between RmanAutomatic Recovery: We just backed up the full database, single tablespace, data file control files, and parameter files of the database. The backup content is an indispensable element for database operation, generally, you only need to back up the content in the production database. With these backups, even if any information in the database is lost, we can restore the database to run normally.ArchivelogAlso backup, of course it will be better, generally this can not be used for backup, backupArchivelogThe occupied space is very large. If there is a large amount of storage, of course the backup is fine.

Egg:

Delete all database files, retain onlyRedoLogs andArchivelogFile

Delete control file:

[Oracle @ wwldb WWL] $ pwd

/DBData/oradata/WWL

[Oracle @ wwldb WWL] $ ls

Control02.ctl control03.ctl

[Oracle @ wwldb WWL] $ rm-rf *. ctl

[Oracle @ wwldbWWL] $

[Oracle @ wwldb WWL] $ pwd

/DBSoft/oradata/WWL

[Oracle @ wwldb WWL] $ ls

Control01.ctl

[Oracle @ wwldb WWL] $ rm-rfcontrol01.ctl

[Oracle @ wwldbWWL] $

Delete data files:

[Oracle @ wwldb WWL] $ ls

Redo01.log redo02.log redo03.logsysaux01. dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf

[Oracle @ wwldb WWL] $ rm-rf *. dbf

[Oracle @ wwldb WWL] $ ls

Redo01.log redo02.log redo03.log

[Oracle @ wwldbWWL] $

Delete the parameter file:

[Oracle @ wwldb dbs] $ cd $ ORACLE_HOME/dbs

[Oracle @ wwldb dbs] $ rm-rfspfileWWL. ora

[Oracle @ wwldbdbs] $

Execute big recovery:

1. The database is closed now.

[Oracle @ wwldb dbs] $ ps-ef | grep ora

Root 2910 2888 0? 00: 00: 15hald-addon-storage: polling/dev/hdc

Root 28954 3478 0 pts/su-oracle

Oracle 28955 28954 0 pts/-bash

Root 29361 3438 0 pts/su-oracle

Oracle 29362 29361 0 pts/-bash

Oracle 29988 29362 0 pts/200: 00: 00 sqlplus as sysdba

Oracle 30102 28955 0 pts/ps-ef

Oracle 30103 28955 0 pts/grep ora

[Oracle @ wwldbdbs] $

2. to recover, you must first start the database to the mount State before it can be restored.

[Oracle @ wwldb dbs] $ sqlplus/assysdba

SQL * Plus: Release 10.2.0.1.0-Production on Wed May 23 17:03:42 2012

Copyright (c) 1982,200 5, Oracle. Allrights reserved.

Connected to anidle instance.

SQL> startup

ORA-01078: failure in processingsystem parameters

LRM-00109: couldnot open parameterfile '/DBSoft/product/10.2.0/db_1/dbs/initWWL. ora'

SQL>

3. Because the database does not have a parameter file, it cannot be started and can only be started to nomount state.

[Oracle @ wwldb dbs] $ rman target/

RecoveryManager: Release 10.2.0.1.0-Production on Wed May 23 17:06:32 2012

Copyright (c) 1982,200 5, Oracle. Allrights reserved.

Connected totarget database (notstarted)

RMAN> startup force nomount;

Startup failure: ORA-01078: failure inprocessing system parameters

LRM-00109: couldnot open parameterfile '/DBSoft/product/10.2.0/db_1/dbs/initWWL. ora'

Starting Oracleinstance withoutparameter file for retrival of spfile

Oracle instancestarted

Total System GlobalArea 159383552 bytes

Fixed Size 1218244 bytes

VariableSize 58722620 bytes

DatabaseBuffers 92274688 bytes

RedoBuffers 7168000 bytes

RMAN>

1 2 Next Page