#Como utilizar dbf manager how to
#Como utilizar dbf manager update
#Como utilizar dbf manager full
#Como utilizar dbf manager password

Actually, it must be an incremental Level 0 backup in order to allow the subsequent Level 1 to consider it.ДЇor the method we are going to use, there is no need to backup the Archived Logs, because the target database will be updated only with incremental backups.

#Como utilizar dbf manager full

The first backup of the source database needs to be a full backup. Perform a full backup of the source database LetвЂ™s copy all the Oracle configuration files to the target: ~]$ scp -i ~/EC2us-east-1.pem $ORACLE_HOME/dbs/spfileorclcdb.ora 100% 3584 4.9MB/s ~]$ scp -i ~/EC2us-east-1.pem $ORACLE_HOME/dbs/orapworclcdb 100% 3584 2.9MB/s ~]$ scp -i ~/EC2us-east-1.pem $ORACLE_HOME/network/admin/*ora 100% 336 264.6KB/s 00:00ДЄfter copying these files, you should review the content of the network files and make the necessary adjustments considering the host server is different.

#Como utilizar dbf manager password

Copy the SPFILE, password file and network configuration files to the target and adjust them Here I will just create the directories that will be used by the target database, the same way they exist in the source: ~]$ mkdir -p ~]$ mkdir -p $ORACLE_BASE/fast_recovery_area/orclcdb/ORCLCDB 3. SQL> select name, log_mode from v$database Дisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 2. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production I just want to check if the database is in ARCHIVELOG mode so I can execute all the backups online: ~]$ sqlplus / as sysdba

The database files, FRA, backups and everything else will be copied to the same paths in the target.

So whenever I connect to a database it will always be the right one.

All the environment variables are configured properly for the oracle OS user.

Both servers can communicate through the network, so I can easily transfer files between them.

In the source server I have only the database orcldb that will be used here.

The Linux prompt identifies which server I am working on.

The servers are named ora12c-1 (the source) and ora12c-2 (the target).

I am using two Oracle Linux virtual servers in AWS with Oracle 12.2 installed.

#Como utilizar dbf manager how to

I found very little documentation about this, so this post is to explain why usually a RESETLOGS would be necessary, and how to overcome this constraint.ДЇirst of all, some information about my environment: If you are using Oracle Enterprise Edition, you can configure a DataGuard between both databases, so you can switch to the new server almost without any downtime, and also revert to the source without any data loss at any moment if something goes wrong.Д«ut, what if you donвЂ™t have Oracle EE license, or for any other reason you donвЂ™t want to use DataGuard? Is there a way to open the database without the RESETLOGS option and also revert to the source if necessary? In practice you need to start your backup history from scratch, and if something goes wrong in the target you donвЂ™t have the option to revert to the old database, unless you accept to loose all the changes made in the target after the database was open. The main problem with this approach is the fact that you end the process by opening the target database with RESETLOGS, which make it to be a new incarnation, almost as if it was a new database.

Open the database with RESETLOGS option.

In the cutover window, perform a last incremental backup of the source with the database mounted, then copy and apply it to the target.

#Como utilizar dbf manager update

While you are waiting for the cutover window, perform periodic incremental backups in the source and update the target with them.

Copy the backup files to the target and restore the database from it.

Perform a full backup of the source database.

Copy all Oracle configuration files (spfile, password file, listener.ora, tnsnames.ora, etc) and make the necessary adjustments.

Prepare the new host (install Oracle software, etc).

ItвЂ™s also well known the technique to keep updating the target with all the changes in the source until the cutover window. ItвЂ™s well known the technique of moving an Oracle database to a new host, as explained for example in this documentation link.