Blink SQL BlinkSQL
← Postgres DBA Lesson 33 / 36
Playground
Postgres DBA · Lesson 33

Restore Oracle DB in Linux

To restore a database from the default directory /backup/rman use the cmd cmd: RESTORE DATABASE; Restore Specific Tablespace: Instead of restoring the full database, you can also restore only specific tablespace cmd:RMNAN> RESTORE TABLESPACE dev1; Here dev1 is the tablespace name To restore more…

connected · blinksql_demo

To restore a database from the default directory /backup/rman use the cmd

cmd: RESTORE DATABASE;

Restore Specific Tablespace:

Instead of restoring the full database, you can also restore only specific tablespace

cmd:RMNAN> RESTORE TABLESPACE dev1;

Here dev1 is the tablespace name

To restore more than one tablespace by separating them with commas.

cmd:RMNAN> RESTORE TABLESPACE dev1, dev2;

✦ Practice — AI-generated for this lesson

Write a query that shows each order status and how many orders have it — but only statuses with more than 1 order.