Error log: SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/ORCL/system01.dbf’…
How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to…
In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.…
In the previous blog, we saw Steps to create a Heterogeneous Dataguard between Windows and Linux Click here to read more. In this blog, we are going to perform a clone of Windows Oracle DB…
💡 In this article I am going to give you the steps of restoring an oracle DB on a new server: Step 1: Install the Oracle Software on the new server…
💡 Bài toán đặt ra là: Giả sử database server bị hỏng hoàn toàn, nhưng thật may mắn chúng ta đã có trong tay bản backup và database đã cấu…
1) Kiểm tra trước trong Source database: Step 1 : Kiểm tra kích thước cơ sở dữ liệu trong SOURCE: select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select…
Cách flashback cả database về thời thời điểm bất kỳ: SQL> select * from V$FLASHBACK_DATABASE_LOG; SQL> Shutdown immediate; SQL> Startup mount; SQL> flashback database to timestamp TO_TIMESTAMP( ‘2022-03-04 19:00:00′,’YYYY-MM-DD HH24:MI:SS’);…
In Flashback recovery, you can create restore point before any upgrade, patching and application testing activity. We can create restore point in two ways: Norman Restore Point: Its age out with…
Following are the things for running the RMAN Backup with Password Protected: Set the configuration of RMAN to use Encryption: — Check the configuration RMAN> Show all; — Set the…