Question
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\
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started