Shulou(Shulou.com)06/01 Report--

15. Full recovery in non-archived mode

Recovery in non-archive mode may be a full recovery or an incomplete recovery, and it is more likely that an incomplete recovery can only be done if the online redo log is overwritten.

Parameter file missing

1. Control the recovery of lost files, data files, and online redo log files

First do a full picture of the database. Includes data files, control files, and parameter files, and uses the flash recovery area as the backup directory.

SQL > shutdown immediate

SQL > startup mount

[oracle@oracle11g ~] $rman target username/password

RMAN > backup as compressed backupset database

Create a test table

SQL > alter database open

SQL > create table test123 as select * from dba_segments

Delete all data files, control files

[oracle@oracle11g ~] $rm-rf / u01According to an oradata or an orcluse *

Restart the database, where the direct shutdown immediate may fail or succeed.

SQL > shutdown abort

SQL >

First restore the control file

[oracle@oracle11g 2018 / 08 / 05] $rman target /

RMAN > restore controlfile from'/ u01ActionAccording to fastfastrecoveryAccording to autobackupUniverse, 2018 / 08 / 05, 2011 / 08 / 08 / 05, o1 / 1, fpdpkdox.bkp'

-- you can also let RMAN choose to back up files.

RMAN > restore controlfile from autobackup

SQL > alter database mount

Then restore the database

RMAN > restore database

Due to the loss of all online redo log files, you need to restore the database and use the noredo option to prevent RMAN from trying to apply the redo log to the database, and then rebuild the online redo log through resetlogs.

RMAN > recover database noredo

SQL > alter database open resetlogs

Verification test table is missing

SQL > select * from test123 where rownum shutdown abort

SQL > startup

RMAN > restore datafile 4

RMAN > recover datafile 4

SQL > alter database open

If the online redo log is not overwritten, a full recovery can be achieved, otherwise an incomplete recovery can only be done.

RMAN > restore database

RMAN > recover database

SQL > alter database open resetlogs

3. Restore the data file to a different disk directory

If the disk is damaged, the storage path of the data file must be changed when restoring the data file.

[oracle@oracle11g orcl] $rm-rf undotbs01.dbf system01.dbf

SQL > shutdown abort

SQL > startup

RMAN > run {

Set newname for datafile

'/ u01App to' / u01applash oradata'/ u01applash

Set newname for datafile

'/ u01appranumoradata racemorclandundotbs01.dbf' / u01 to' / u01According to undotbs01.dbf'

Restore database

Switch datafile all

}

RMAN > recover database until cancel

SQL > alter database open resetlogs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.