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

a. If the backed up database is accessible, execute the production conversion script:

Select 'set newname for datafile' | | file# | |'to''| | replace (name,'/old/data/path','/new/data/path') | |''; 'from v$datafile

b. If the backed-up database is not accessible, you can control the contents of the file by trace:

Alter database backup controlfile to trace

View the path and name of the generated trace file in alert

Edit the recovery script:

Vi recover.txt

Run {

Allocate channel c1 type sbt

Allocate channel c2 type sbt

Allocate channel c3 type sbt

Allocate channel c4 type sbt

Allocate channel c5 type sbt

Allocate channel c6 type sbt

Allocate channel c7 type sbt

Allocate channel c8 type sbt

Set newname for datafile 1 to'/ s01qqoracle.oradata.156.952859152'

Set newname for datafile 2 to'/ s01qqoracle.oradata.157.952859154'

Set newname for datafile 3 to'/ s01qqoracle to'/ s01qqoracle.oradataUniverse

Set newname for datafile 4 to'/ s01qqoracle.oradataUniversProdUniverse users.159.952855153'

Set newname for datafile 5 to'/ s01qqoracle to'/ s01max oradataUniverse undotbs2.168.956859305'

Set newname for datafile 6 to'/ s01qqoracle.oradataplicate.176.952859731'

Set newname for datafile 7 to'/ s01qqoracle.oradataUniplicate.177.952857539'

Set newname for datafile 8 to'/ s01qqoracle.oradataUniplicate.178.952850557'

Restore database

Switch datafile all

Recover database

Release channel c1

Release channel c2

Release channel c3

Release channel c4

Release channel c5

Release channel c6

Release channel c7

Release channel c8

}

Put it in the background to recover:

Nohup rman target / @ recover.txt log backup.log &

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.