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.
Please complete these tasks on your project instance. Hints Please remember the status of database when creating offline
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am