Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an SQL script that can be used to back-up all the database files (i.e. control, redo log, data files, Initialization Param Files [including SPFile],

Write an SQL script that can be used to back-up all the database files (i.e. control, redo log, data files, Initialization Param Files [including SPFile], and password file). The source and destination locations of the files must be provided as "substitution variables". The script must implement the following tasks

1. Connect as user SYS with SYSDBA role

2. Shutdown the database

3. Copy the database files from the source location and store in the destination location

4. Restart the database

5. Connect as user SCOTT

Assume the destination folder exists. In addition, the script must use the "HOST" command, to issue the operating system command to perform the copy task. The location for all the files is fairly standard especially when using "Oracle Flexible Architecture (OFA)". The location for the password file and the server parameter file (i.e., SPFILE) is located in the ORACLE_HOME\database directory. The parameter initialization file is located in the ORACLE_BASE\admin\\pfile directory.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started