Database Reference
In-Depth Information
restore all the data files, recovery of database is required before
making it available to users.
There is very useful SQL statement and I usually call it a tool
than just a SQL statement. This statement will give you the
output with all the tablespaces within the database along with all
the data files associated with each of these tablespaces.
SELECT a.TS#, a.Name, b.Name
FROM V$TABLESPACE a, V$DATAFILE b
WHERE a.TS# = b.TS#;
Always keep this tools output handy before proceeding with the
backup.
Step 1: Put the tablespace in backup mode
Once connected to Oracle as SYSDBA, use the following
statement to put the tablespace in the backup mode.
ALTER TABLESPACE users BEGIN BACKUP;
Step 2: Copy the associated data files
Copy all the data files associated with the tablespace we placed
in backup mode at the operating system level or in other words
using operating system copy command in Window and cp in
Unix.
Step 3: Take the tablespace out of Backup mode
Once we have copied all the associated data files then its time to
take the tablespace out of backup mode using the following SQL
statement.
ALTER TABLESPACE users END BACKUP;
Note: Repeat Step 1 to Step 3 for each of the tablespace with the
database.
Search WWH ::
Custom Search