Please complete these tasks on your project instance. Hints Please remember the status of database when creating offline

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Please complete these tasks on your project instance. Hints Please remember the status of database when creating offline

Post by answerhappygod »

Please complete these tasks on your project instance.
Hints
Please remember the status of database when creating offline
database backups.
select file_name from dba_data_files;
show parameters
show parameter spfile
NAME
TYPE VALUE
------------------------------------ -----------
------------------------------
spfile
string
/u01/app/oracle/product/11.2.0
/dbhome_1/dbs/spfileACM.ora
SQL> create pfile from spfile;
File created.
Task List
Create a tar (offline backup) of your Oracle installation.
Create a new tablespace under current data files location,
called as ACM.
Create a new archive log directory other than your data files
location.
Alter your database to archivelog mode.
Goto directory flash_recovery_area check the files under this
directory.
Run “alter system switch logfile;” command and check again
flash_recovery_area.
Create a new control file on different location.
Increase the size of recovery destination to 5GB. Consider the
difference between spfile and pfile.
Create a full database backup with RMAN.
Check where those RMAN backups are created.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply