Hi,
I am new in backup and recovery, and at the moment we are developing in XE 18c. We are in need of backup and recovery. Checking the SQL Developer, i did read that I can made a Data Pump, and I did it, it was so easy, it give us very good alternatives such as database, tablespaces, schemas, tables.
On the other hand, I got the connection with RMAN, by executing the the command prompt as follows:
CMD, in Windows command line
RMAN
RMAN> CONNECT TARGET SYS@XE;
But from here, I don't know how to run the RMAN scrips I got in SQL Developer:
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
RUN {
ALLOCATE CHANNEL SQLDEV_DISK_BACKUP DEVICE TYPE DISK;
RECOVER COPY OF DATABASE WITH TAG 'ORA_SQLDEV_LEVEL_0';
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR RECOVER OF COPY WITH TAG 'ORA_SQLDEV_LEVEL_0' DATABASE;
}
ALTER DATABASE OPEN;
So, in summary, somebody could please help me to clarify:
Which one is much better DATA Pump or RMAN
How to run the RMAN scripts
Best regards,
Khristina