10.Backup 2 (Restore Backup) - eshan3101/DataBase-Architech GitHub Wiki

2.!rman target /

3.list backup;

4.delete backup

5.backup database plus archivelog;

6.In 2nd terminal (cd /u01/app/oracle/product/19.0.0/dbhome_1/dbs)

7.In 2nd terminal (remove spfile rm spfileprod.ora)

8.shoutdown immediate

9.In 3rd terminal do startup but it gets fail , database will not go in nomount mode

10.in 3rd terminal (!rman target /) and (startup nomount;)

11.in 3rd terminal tempraory instance is created

12.restoring spfile in 3rd terminal

13.shutdown immediate in 3rd terminal

14.exit in 3rd terminal

15.again startup in 3rd terminal

16 In 2nd terminal we recovered spfile

17.in 2nd terminal cd /u01/app/oracle/oradata/PROD

18.in terminal 2

19shutdown in terminal 3

20.restore controlfile in terminal 3

21.alter database mount;

22.restore database;

23.recover database;

24.select * from v$log;

25.select * from v$log;

26.in terminal 2

27.rm *.dbf in 2nd terminal

28.restore database; in 3rd terminal

29.recover database; in 3rd terminal