How to Back-Up and Recovery Oracle 18cXE using RMAN-SQL Developer 20.2 — oracle-tech

    Forum Stats

  • 3,707,908 Users
  • 2,240,908 Discussions
  • 7,839,918 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How to Back-Up and Recovery Oracle 18cXE using RMAN-SQL Developer 20.2

Hi, I am working creating PL-SQL procedures and functions to upload data from non-structured sources to NetSuite, and after some trouble regarding MultiTenant Architecture and some string functions, I am on my way to achieve the goal, to transform the non-structured data into structured data readable for NetSuite.

There are still some other administrative tasks that I must accomplish in order to protect these development efforts and artifacts.

To do the back-up, and according to the SQL Developer 20.2 documentation, in the DBA panel, with the SYS user? I must right click on RMAN Backup/Recovery, and SQL Dev generates the following file content:

-----------------------------------------------------------------------------------------------------------------------

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;

-----------------------------------------------------------------------------------------------------------------------


Once the script is generated, in SQL Developer a dialog pops up:



Note: I deleted the directory name above to keep my client information confidential.

Could you please let me know how can I run this script? I did try in SQLPlus, user SYS as SYSDBA but it didn't work.

Regarding users, with the user SYS I created a user called KHRISTINE who is the owner of the tables, indexes, sequence, procedures, functions, data model, etc I have developed; it's very important to backup the Khristine's schema because all these artifacts plus the software are now in production.

Which user is the right one to run the Backup process.


Thanks a lot in advance for your help,

Khistine

Answers

  • EdStevensEdStevens Posts: 27,790 Gold Crown

    I did try in SQLPlus, user SYS as SYSDBA but it didn't work.

    "it didn't work" is totally devoid of actionable information. However, the script is not a sqlplus script but an rman script. You run it in rman.

Sign In or Register to comment.