Guess solved version 1.0.pdf - Database backup in archive...

This preview shows page 1 - 3 out of 5 pages.

Database backup in archive log SHUTDOWN IMMEDIATE; # Start up the database in case it suffered instance failure or was # closed with SHUTDOWN ABORT before starting this script. STARTUP FORCE DBA; SHUTDOWN IMMEDIATE; STARTUP MOUNT; # this example uses automatic channels to make the backup BACKUP DATABASE PLUS ARCHIVELOG; INCREMENTAL LEVEL 0 MAXSETSIZE 10M DATABASE TAG 'BACKUP_1'; # Now that the backup is complete, open the database. ALTER DATABASE OPEN; Add redo log members alter database add first logfile member '/u02/oracle/ONLINELOG/Log01.redoto group 1; /u02/oracle/ONLINELOG/Log01.redoto group 2; alter database add second logfile member /u02/oracle/ONLINELOG/Log02.redo' to group 2; /u02/oracle/ONLINELOG/Log02.redo' to group 2;
Create Tablespace with uniform size extends CREATE TABLESPACE user01 DATAFILE '/u02/oracle/data/user01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; Short Questions 1. PFILE A parameter fileis a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the following two types of parameter files: Server Parameter Files called SPFile Initialization Parameter Files called PFile Initialization Parameter Files (PFile) An initialization parameter fileis a text file that contains a list of initialization parameters. The file should be written in the client's default character set. The name of

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture